In the Employee Work Log lesson, we reviewed querying dates. Back in Beginner 9 we learned about Explicit Query Parameters. When I used them to get HoursWorked for day, it worked just fine. The challenge came when trying to use an explicit query parameter and criteria supplied by a form--that just did not work.
The question: is there a way to input the data for the explicit query parameter and the query criteria simultaneously?
Ruth MuthogaOP
@Reply 3 years ago
The dates would be inputted with a form as shown in the class.
Kevin Robertson
@Reply 3 years ago
Can you post a screenshot of your query in Design View please, clearly showing your criteria?
Ruth MuthogaOP
@Reply 3 years ago
Ruth MuthogaOP
@Reply 3 years ago
I tried it again, this time a got the too complicated error message
Ruth MuthogaOP
@Reply 3 years ago
Ruth MuthogaOP
@Reply 3 years ago
As a simple query, the explicit parameter works. The challenge comes when using the form to fill the query parameters.
Kevin Robertson
@Reply 3 years ago
Instead of a Parameter why don't you use the form field?
With the explicit query parameter I was able to get around training issue regarding about end dates--as in, if we are query HoursWorked for just 8/1/2013, there is only one date to enter.
Using the form, we have to use the CDate function with the training challenge that comes with it. I am hoping there was another way around this training issue using the explicit query parameters. But alas.
Kevin Robertson
@Reply 3 years ago
You can still just specify one date (see screenshot).
Kevin Robertson
@Reply 3 years ago
Ruth MuthogaOP
@Reply 3 years ago
I tried this way and still didn't work.
In any case Richard tells us end users should not have access to queries and tables, this process gives them a query to manipulate.
But now we've learned how to create reports, whatever information we need can be obtained using another method.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 11.
