What do you want to do exactly (exemple??)?

Create two textbox (one per parameter) and set the values there. Then in the report's input parmater property add something like this :

Forms!FormName!TxtDateStart, Forms!FormName!TxtDateEnd.

Then the report will show...

Not gonna happen .

That's a good idea. The real problem is that you must find a default that will never be in the table... shouldn't be too hard if you know your...

We'll have to start a group, call it work and meet there .

Then what are you doing here ?

I didn't know this site had turned into a chat... maybe some on us should get back to work (opening the door real big here

Why not use meaningfull alias as the best practice commands .

No because the values are APPROXIMATE. If you want the real value to be kept in the db you must use the DECIMAL datatype. Check the books online...

I'll take that as a no .

I tested on one of my average table. It took ±50 packets for 20 rows and 1700 packets for 21k rows. This would tell to me that access fetches...

You can use the wizards of the jobs for that. Just add the 2 dts packages as the first steps, then the proc. It's all wizard and well...

Forgot to ask... do you ALWAYS need the third max or this number can be dynamic (major change in the last subquery)?

Congrats on the big K AJ ... and I see this one is not about loops so that's cool

That's far off... but for once it's also her fault so she can't complain this time .