Query between dates

[hopkins]

I have mastered forms and simple reports, buut now a querey seems to have me bogged down.

Following is my "Transaction" table:

TransactionNumber : AutoNumber
AllotmentCode: Text (Look-up from separate table)
Business Line: text (look-up form separate table)
Resp Centre: Text (look-up form separate table)
Line Object: Text (look-up form separate table)
ProjectCode: Text (look-up form separate table)
Initial Allocation/Adjustment: yes/no
Requisition: Text
RequisitionDate: Date/Time
Originator: Text
SupplierName: text
ItemDescription: text
EstimatedCost: Currency
FinalCost: Currency
RunningCost: Currency
Comments: Text
Allotment Description: Text
FMSPeriod: Text
CreditCard: text


My report currently works off a query called " Transactions Query" which sorts information based on Resp Centre and Project code. It has expressions which reduce expenditures against an initial allocation and returns a free balance.

When you first run the report it asks for input such as Resp Centre and Line Object.

I would also like to run the report based on date and have it return records with a requisition date between (for example) May 1, 2003 and May 31, 2003.

I understand this should be done in the "Criteria" of the querey. This is what I have and it does not work:

Between [Type the beginning date (dd/mm/yyyy):] And [Type the ending date (dd/mm/yyyy):]

This brings up the input boxes I want, but it returns blank informaiton.

When I input data via the form it shows as 08-may-03. The tables stores it as 05/08/03

Any ideas?

Trish

 

[jtvcs]

This may sound silly, but have tried testing as mm/dd/yyyy in your parameter questions and entries ? JT

 

[hopkins]

I guess sometimes it's just the easiest things!

Yes... that works. In a query such as this is there a way to use a point-and-click calendar?

Thank you!

 

[jtvcs]

Two things: 1) Always been taught to use mm/dd/yyyy even though the format might be different in your data look. 2) You could use a calendar to pick the dates but only if you built a form then fed the choices to the query from the form. JT