between query issues

[jderrig]

I have a query that I am trying to filter by TTLSales and it is bringing back too many records.

>=[forms]![frmGraphSalesRange>10]![BeginningSalesRange] And <=[Forms]![frmGraphSalesRange>10]![EndingSalesRange]

In the BeginningSalesRange I am inputting 100,000,000 and
int the EndingSalesRange I am inputting 200,000,000

What I get is everything with a value of 0-200,000,000

[RuralGuy]

Try using:
Between [forms]![frmGraphSalesRange>10]![BeginningSalesRange] And [Forms]![frmGraphSalesRange>10]![EndingSalesRange]
...I'm pretty sure in is inclusive.

[jderrig]

There must be something with using the form - when I substitute

Between[forms]![frmGraphSalesRange>10]![BeginningSalesRange] And[Forms]![frmGraphSalesRange>10]![EndingSalesRange]

for

Between 100000000 And 200000000, it gives me the correct number of records.

[jderrig]

Thanks for the reply. After further research, I had no idea that you had to set the format on the form to the same as in the query. I changed the format of the form to Standard and it worked.

[RuralGuy]

Great! Thanks for posting back and marking the thread as Solved.