Help

[Manuel Jose Gonsalves]

Hi there,



It's me again,

I don't know why, but nobody wants to tell me what I can do to end my Data
Base.

I am new at making programs in Ms Access and I need to know if this is
possible:

I am trying to make a Form where I can put the date in a range format. I
need my form to be able to show me between date to date how many Items I
purchased and how many I sold in one period of time.

For example: From (01-Jun-03) to (31-Aug-03)

How many Items I purchased and how many I sold during that period (all of
them).

Right now I have a Form where you can enter the Purchase Date and Sale Date
and you can see the purchased and sold Items in that specific date. But,
what I need is for a period of time.

I used this code "Between Date() And DateAdd("m",-1,Date())" for my Report
to which should show me the information for one month, from 29 or 30 days
before to now.



Please if somebody knows about it, tell me. I'd appreciate any help
possible. Thanks in advance.







Kind Regards,

Manuel

 

[John Vinson]

I am trying to make a Form where I can put the date in a range format. I
need my form to be able to show me between date to date how many Items I
purchased and how many I sold in one period of time.

Use a criterion of

BETWEEN [Forms]![NameOfForm]![txtStart] AND
[Forms]![NameOfForm]![txtEnd]