Q quantz New member Local time Today, 11:06 Joined Jan 1, 2003 Messages 8 Jan 3, 2003 #1 how can i make my financial query view by month/year that i enter.. and where i have to place the creteria under date field or total field... somebody help me please
how can i make my financial query view by month/year that i enter.. and where i have to place the creteria under date field or total field... somebody help me please
J Jon K Registered User. Local time Today, 11:06 Joined May 22, 2002 Messages 2,209 Jan 4, 2003 #2 Try this in a column in the query grid (using the correct date field name):- Field: Format([DateField],"m/yy") Show: uncheck Criteria: [Enter m/yy] When the query is run, input 12/02 for December 2002, 1/03 for January 2003, etc.
Try this in a column in the query grid (using the correct date field name):- Field: Format([DateField],"m/yy") Show: uncheck Criteria: [Enter m/yy] When the query is run, input 12/02 for December 2002, 1/03 for January 2003, etc.
