Querry Criteria

  • Thread starter Thread starter injanib via AccessMonster.com
  • Start date Start date
I

injanib via AccessMonster.com

Hellooo Monsters!

I have a report that is based on a querry. The querry has two fields,
StartMeter and EndMeter.
I have a form with two textfields, txtSartMeter and txtEndMeter where I enter
a value for start meter and end meter and a button to open the report. I
would like to set the criteria in the querry under StartMeter and EndMeter to
reffer to these two text boxes respetively and filter the report for records
starting from the StartMeter and ending with EndMeter. In other words
records between txtStartMeter and EndMeter. I know how to do this under one
field, but don't know how if the criteria fields are two different fields.
 
Use criteria under each of the fileds.
Like this --
StartMeter EndMeter
=[Forms]![YourFormName]![txtSartMeter] >=[Forms]![YourFormName]![txtEndMeter]
Click to expand...
Use the criteria on the same row.
 
Thanks allot!

KARL said:
Use criteria under each of the fileds.
Like this --
StartMeter EndMeter
=[Forms]![YourFormName]![txtSartMeter] >=[Forms]![YourFormName]![txtEndMeter]
Click to expand...
Use the criteria on the same row.
Hellooo Monsters!
Click to expand...
[quoted text clipped - 7 lines]
records between txtStartMeter and EndMeter. I know how to do this under one
field, but don't know how if the criteria fields are two different fields.
Click to expand...
Click to expand...
 
I just noticed an error - the criteria for EndMeter should be <=
--
KARL DEWEY
Build a little - Test a little


injanib via AccessMonster.com said:
Thanks allot!

KARL said:
Use criteria under each of the fileds.
Like this --
StartMeter EndMeter
=[Forms]![YourFormName]![txtSartMeter] >=[Forms]![YourFormName]![txtEndMeter]
Click to expand...
Use the criteria on the same row.
Hellooo Monsters!
Click to expand...
[quoted text clipped - 7 lines]
records between txtStartMeter and EndMeter. I know how to do this under one
field, but don't know how if the criteria fields are two different fields.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top