Date select form

  • Thread starter Thread starter Guest
  • Start date Start date
John,
Ok this may sound weird but here's what I did to make it work. I removed the
whole "DateSerial" references and the "DateCreated" field from the query but
left all the combo boxes on my form. Now it works fine. How does it know what
month/year to select when there is no reference to the "DateCreated" field in
the query and no "DateSerial" reference either? It is working fine and
showing the "DateCreated" on the report but there is no reference to it. Does
this look/sound normal to you? Here is the new SQL that works.
Click to expand...

I'm officially and totally baffled.

John W. Vinson[MVP]
 

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

Date search query 0
Chart subform on report 12
expiry date e.g mm/yyyy 1
Looking for criteria in query that filters based on last month'srecord date 11
Selecting A single Month From a Table with Multiple Months 5
Problem with date criteria in Query 2
Query criteria 4
Date Based report 1

Back
Top