Explicit Query Parameters - Microsoft Access Expert 11


	Back to Access Expert 11 Comments List

Upload Images Link Email

Explicit Query Parameters

Ruth Muthoga

16 months ago

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 Muthoga OP 16 months ago
The dates would be inputted with a form as shown in the class.

	Kevin Robertson 16 months ago
Can you post a screenshot of your query in Design View please, clearly showing your criteria?

	Ruth Muthoga OP 16 months ago

	Ruth Muthoga OP 16 months ago
I tried it again, this time a got the too complicated error message

	Ruth Muthoga OP 16 months ago

	Ruth Muthoga OP 16 months ago
As a simple query, the explicit parameter works. The challenge comes when using the form to fill the query parameters.

	Kevin Robertson 16 months ago
Instead of a Parameter why don't you use the form field? Value From a Form

	Ruth Muthoga OP 16 months ago
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 16 months ago
You can still just specify one date (see screenshot).

	Kevin Robertson 16 months ago

	Ruth Muthoga OP 15 months 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.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 11.