Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > Courses > Access > Expert > X11 > < X10 | X12 >
Back to Access Expert 11    Comments List
Explicit Query Parameters Upload Images   Link   Email  
Ruth Muthoga        
9 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        
9 months ago
The dates would be inputted with a form as shown in the class.
Kevin Robertson            
9 months ago
Can you post a screenshot of your query in Design View please, clearly showing your criteria?
Ruth Muthoga        
9 months ago

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

Ruth Muthoga        
9 months ago
As a simple query, the explicit parameter works. The challenge comes when using the form to fill the query parameters.
Kevin Robertson            
9 months ago
Instead of a Parameter why don't you use the form field?

Value From a Form
Ruth Muthoga        
9 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            
9 months ago
You can still just specify one date (see screenshot).
Kevin Robertson            
9 months ago

Ruth Muthoga        
8 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.


The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/19/2024 2:47:09 AM. PLT: 0s