Correct Syntax for Query

  • Thread starter Chad Cook via AccessMonster.com
  • Start date
C

Chad Cook via AccessMonster.com

Hi all,

I have looked everywhere but have been unable to get the syntax right for a
query that I have been developing. I have generated a value in a report
and I want to call a query using this value as a parameter. I have tried
Where Duration > [Reports]![myReport]![txtDur]
txtDur it the name of my Text Box in my report and my Report is the name of
the report. Any suggestions would be greatly appreciated.

Thanks in Advance,

Chad
 
D

Duane Hookom

Are you really attempting to use a text box from a report as the criteria in
a query? Is the query the row source or record source of a chart or
subreport in the main report?

What's wrong with using a text box on a form?
 
C

Chad Cook via AccessMonster.com

Yep, I am trying to use a text box from a report as the criteria in
a query. The query is the record source for the report and I can't use a
form because it is not in the specs. As guess another question is whether
or not what I am trying to do is possible?
 
D

Duane Hookom

You can't use a value from a text box on a report as the value in a criteria
for that report's record source.

Can you provide more information on what you would like to accomplish rather
than how?
 
Top