Correct Syntax for Query

  • Thread starter Thread starter Chad Cook via AccessMonster.com
  • Start date 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
 
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?
 
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?
 
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?
 
Back
Top