Help Needed To Fix Date Problem On Form

[Guest]

I have made a querry from 2 tables (Sales) & (Purchase) to do INVENTORY. Its
running perfectly fine. As this querry is run on a FORM the only problem am
having i want dates to be shown on FORM i.e from Date To Date (the specific
period mentioned in the querry is Month & Year) the following command is used
in the querry.

Between DateSerial([Enter Year:],[Enter Month:],1) And DateSerial([Enter
Year:],[Enter Month:]+1,0)

With this above command i just enter Month & Year.


Please advise what to do on FORM that I Get the Following Results.

1. Complete Date From (DD/MM/YY) To (DD/MM/YY)
2. Only Month & Year (e.g August 2005 not as 08/2005)
3. Only Month (e.g August)


Thanks
Awaiting Reply

Aamer Sheikh

 

[Douglas J. Steele]

Add two computed fields to your query, DateSerial([Enter Year:],[Enter
Month:],1) and DateSerial([Enter Year:],[Enter Month:]+1,0)

You can bind them to hidden fields on your form so that you can display the
values.

To display August 2005, use a format of mmmm yyyy

To display August, use a format of mmmm