Parameter criterion not working

[mgerada]

Hi to all

I am setting up a query to report on the turnaround time for appication to be processed.

I have a calulated column to calulate the numbe rof days betwen receipt and approval of applications. I now want to be able to run the query and subsequently the report by having a prompt to enter anlower and upper number of days range.

I have used the experssion Between [Lower range] and [ Upper range] to prompt and when I enter say 1 to 5 days the query returns all days.

Any thoughts as to why it is not working and what can I do differnetly?

Regards

mgerada

 

[KenHigg]

I'm guessing that you're testing a text data type in which case you may have problems with the 'between' method. Try to put your fld inside a val() function before it gets to the 'between' statement and see if it works. There are other ways around the problem, this is just a quickie...

Edit: Welcome to the forum!

 

[mgerada]

Many thanks Ken for your quick response.

I am nort sure what you are suggesting here "Try to put your fld inside a val() function". Can you explain what is fld and val () fn and how to use them?

Thanks again

mgerada

 

[KenHigg]

See if this helps:

 

[mgerada]

Thanks again Ken for getting back so quick however I am no wiser with what fld and val () fn are and how to use them.

I am probably a novice and if you can go a little slower would be much appreciated.

I actually have solved it while looking at different aspects of parameters. Under query I defined the Parameters and their type. As you suggested I may have been dealing with a text rather than an integer.

Thanks again for your assistance.

I would still be interested in what you meant by putting fld inside a val() fn.

Cheers

mgerada

 

[KenHigg]

My bad - I uploaded the wrong sample db... Look at this:

 

[mgerada]

Thanks Ken

Now it makes sense.

Thanks again for your input.

Cheers