Upload for Bob Larson

[jcaptchaos2]

Bob,

Here it is, also can you tell me why this opens like to databases so when I close I have to X out twice

JC

 

[boblarson]

Just a note to say I got it.

 

[jcaptchaos2]

Bob,

I also might have messed the database I sent to you up as I deleted a bunch of names in the employee table, the query I was having problems with was the one I called Edit Test

Thanks
JC

 

[boblarson]

Yeah I had to change one of the employee numbers in the employees table to match something in the shop floor table otherwise I wouldn't get anything.

But I came up with a way to work it. I originally tried using a form and such too but it just didn't want to do it with your particular date field. So I finally just created a new field in the query which uses the DateValue function and then putting a single date criteria works fine for that. If you want a range you will need to use a totally separate parameter prompt (or better yet, a form with a start date text box and an end date text box).

So, here's the file and I'll be posting the answer over on Mr. Excel as well so anyone seeing it there will know.

Oh, and you can change your prompt back to

[Enter Date MM/DD/YYYY]

if you want. I just used [Enter Date] as it was shorter and I was working on this while on the bus this morning.

 

[jcaptchaos2]

Thanks for all your help.