Need parameter query assistance here!
- Thread starter fhs
- Start date
boblarson
Smeghead
- Local time
- Today, 13:40
- Joined
- Jan 12, 2001
- Messages
- 32,040
Okay, found the problem. It had to do with null dates. So, I am uploading a fixed version of it. It took a little bit to get it working but it does. You'll notice I have
#1/1/1900#
in one part of the new field - it places that valid date there if a field is null. And it is such that nobody would enter that date anyway but you could if you wanted to get those records that have either field as null.
#1/1/1900#
in one part of the new field - it places that valid date there if a field is null. And it is such that nobody would enter that date anyway but you could if you wanted to get those records that have either field as null.
Great Job, Bob! I really appreciate your persistence with this. The query works just fine AND there will be some Null fields due to the guys only Clocking In or Clocking Out, but not both. So, your solution will cover that. I would like to ask one more thing. As you could see, this is an Access 2007 application. I've found '07 to be a little awkward to use. But you referenced a possible 'reference' issue. Can you refer me to something that should identify the references that I should have? Again, thanks so much for your help. I don't come here to often, but it's great that real professionals like you take time to work with the rest of us.
boblarson
Smeghead
- Local time
- Today, 13:40
- Joined
- Jan 12, 2001
- Messages
- 32,040
The reference issue I talked about is something I don't think you should concern yourself with yet. If you really have a problem there then maybe but I think it would only cloud your mind with unneccessary details.
I only mentioned it because sometimes if a date is having an issue then we can try unchecking the DAO reference and then checking it again. And just so you don't get too confused, you won't see an Accdb file with a DAO reference so-to-speak. You would see one for Microsoft Office Access Database Engine Object Library (or ACE as it is known). It is the new JET Engine(database engine) for Access 2007 and above (which the Access team now controls instead of the Windows team).
I only mentioned it because sometimes if a date is having an issue then we can try unchecking the DAO reference and then checking it again. And just so you don't get too confused, you won't see an Accdb file with a DAO reference so-to-speak. You would see one for Microsoft Office Access Database Engine Object Library (or ACE as it is known). It is the new JET Engine(database engine) for Access 2007 and above (which the Access team now controls instead of the Windows team).
Nice post!!! I too was thinking of using a simple input box and couldn't remember and example. I've been programming now for over 15 years and forgot the reasons why I don't use input boxes. I actually stopped reading the thread after this post. For me I'd rather put a little more work into a small form after reading the FAQ. Thanks a bunch boblarson!!
