Querry Criteria

[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.

 

[Guest]

Use criteria under each of the fileds.
Like this --
StartMeter EndMeter

=[Forms]![YourFormName]![txtSartMeter] >=[Forms]![YourFormName]![txtEndMeter]

Use the criteria on the same row.

 

[injanib via AccessMonster.com]

Thanks allot!

Use criteria under each of the fileds.
Like this --
StartMeter EndMeter

=[Forms]![YourFormName]![txtSartMeter] >=[Forms]![YourFormName]![txtEndMeter]

Use the criteria on the same row.

Hellooo Monsters!

[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.

 

[Guest]

I just noticed an error - the criteria for EndMeter should be <=
--
KARL DEWEY
Build a little - Test a little

Thanks allot!

Use criteria under each of the fileds.
Like this --
StartMeter EndMeter

=[Forms]![YourFormName]![txtSartMeter] >=[Forms]![YourFormName]![txtEndMeter]

Use the criteria on the same row.

Hellooo Monsters!

[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.