Upload for Bob Larson

jcaptchaos2

Registered User.
Local time
Yesterday, 20:34
Joined
Apr 28, 2011
Messages
12
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
 

Attachments

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
 
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.
 

Attachments

Users who are viewing this thread

Back
Top Bottom