QUERY criteria seems good but not working

[rickyfong]

I have put the following criteria in a query form, but not working!

>[forms].[custloss].[dayloss1] And <[forms].[custloss].[dayloss2]


I have tested it with input parameters said 7 and 15 in the query form according to query asking for entering the data for dayloss1 and dayloss2. The result show nothing! However, when I simply put >7 and < 15 in the criteria field, the desired result appearing!! I don't think this is a sytnax problem!! Any idea?? Thanks!

 

[GinaWhipp]

Try...

Between [forms].[custloss].[dayloss1] And [forms].[custloss].[dayloss2]

 

[Brianwarnock]

I think that you should use a bang ! Not a Dot .

Ie forms!custloss!dayloss1

Brian

 

[rickyfong]

1) when using "between", the query return all results from thousand to unity.
2) when I put "!" instead of ".", the query simply reacted the same as before, ie. show nothing!!

 

[CJ_London]

suggest show your full query so we can see it in context - also, Brian is right, you should use bangs and not dots.

Have you tried using the expression builder?

 

[JHB]

Are you sure the field type is number and not a string type field?

 

[vbaInet]

... query asking for entering the data for dayloss1 and dayloss2.

You must open the form and keep it open before you run the query. Also add those two references in the Parameters list.

 

[rickyfong]

Thanks all! I used another way to work it out!!

 

[jdraw]

Want to enlighten readers with your solution. It may help others.