Querry/Form Date Issue

A

Aamer

In my sales and purchase ledger i have 2 tables (Sales) & (Purchase) where
sales and purchases are recorded respectively.

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
 
C

chriske911

In my sales and purchase ledger i have 2 tables (Sales) & (Purchase) where
sales and purchases are recorded respectively.

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

use a form for input of the query parameters

an inputbox is fine for text input or with some code you could also
check for numbers
but for dates or any other kind of validation it is too unpractical

create a form with 2 fields in a short date format
put a hint on the form witch format is required for parameters

and set the criteria of the query to the values of those text boxes on
your custom made form

grtz
 
A

Aamer

chriske911 I could not understand what u are saying can u please state it in
step by step how to do what you are saying.

aamer

chriske911 said:
In my sales and purchase ledger i have 2 tables (Sales) & (Purchase) where
sales and purchases are recorded respectively.

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

use a form for input of the query parameters

an inputbox is fine for text input or with some code you could also
check for numbers
but for dates or any other kind of validation it is too unpractical

create a form with 2 fields in a short date format
put a hint on the form witch format is required for parameters

and set the criteria of the query to the values of those text boxes on
your custom made form

grtz
 
P

Pete Dochers

I am having a related problem.

I have used a startdate / endate input box on a Supplier form to show
records regarding these dates - it runs after I have created the
queries/reports, but as soon as the dbs is closed/opened, the queries and
reports ask for the parameter queries, even though the Supplier is open.

What is a form witch and where can i find her? Do you reckon this will solve
my prob?

Cheers
 

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


Top