Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Formats for Criteria

Status
Not open for further replies.

OB1too

Technical User
Jun 7, 2000
37
AU
I have an Input Form with a Date field which is formatted with Input Date Mask(00/00/00;0;_). When submitted, it runs a query.
The field that I'm querying is a date field.
My question is - What is the format of the Criteria in the Query?

I currently have it as [Forms]![PPER]![PPE] which is not complete I believe......any ideas much appreciated
Thanks
 
Got it sorted...related to refreshing Forms correctly
Thanks anyway
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top