Dates Query

[§wééT V]

Basically i'm creating a stock database but i want the user to view all the stock bought between certain dates which they can select how would i go about doing this

 

[Ukraine82]

If you have a date field run this in the criteria

Between #1/1/04# and #1/1/05# <--- Example ( you can use any date you wish)

hth,

Michael

 

[Mile-O]

Search the archive for some of my calendar examples.

 

[§wééT V]

If you have a date field run this in the criteria

Between #1/1/04# and #1/1/05# <--- Example ( you can use any date you wish)

hth,

Michael

yep i know how to do that bit but i want the user to be able to select any dates s/he wants

 

[Mile-O]

Here's one.

And you refer, in the query, to the form.

i.e.

Between [Forms]![MyForm]![txtStartDate] And [Forms]![MyForm]![txtEndDate]

 

[§wééT V]

thank u! i think thats what i'm looking for