Enter just the year.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to run a report that the user only needs to input the year in a
form, Ie 04 or 2004 and then the form would feed the Query that feeds the
report.

Thanks

Keith
 
Your query might look like
Year([YourDateField]) = Forms!frmA!txtYear
 
Thank you!!

Duane Hookom said:
Your query might look like
Year([YourDateField]) = Forms!frmA!txtYear

--
Duane Hookom
MS Access MVP


KAnoe said:
I would like to run a report that the user only needs to input the year in a
form, Ie 04 or 2004 and then the form would feed the Query that feeds the
report.

Thanks

Keith
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pull a field from a form to be the criteria of an append query 0
VBA? Program Command Button to Open Data Entry Form instead of Report 1
Filter Query by Year on a form 13
Hello happy new year to all, Text box input for year of purchase 0
Using an Access form to enter parameters for a Query 1
Build a query to pull current week data only. 5
Parameter queries 1
Format Date in query 6

Back
Top