Reports

A

Alvin Smith

How do I select orders from a date section. I have a report date range built
but this is as far as I got. I have no clue where to start. I am new at
access and have learned what I know on my own. If someone would give me a
small example and let me know a little detail as to what all I need It would
be greatly appreciated.
Thanks in advance.
 
C

Chris Reveille

If you are using a query put this in the criteria for order
date.
between [enter start date] and [enter and date]
I suggest creating a form to hold these dates. add 2
unbound text fields in the form and in criteria section of
the query reference these dates by
[Forms]![NameOfForm]![NameOfTextbox]
On the form add a command buttonm that runs the query

Chris
 
A

Alvin Smith

I built the Form and named it form1 for now & entered
between [enter start date] and [enter and date] In the date criteria
Question now is where do I need to put the expression
[Forms]![Form1]![NameOfTextbox]
In same criteria box as between [enter start date] and [enter and date]
I have a Query also that has the fields to contain the info.

Thanks chris, I am close Thanks to you



Chris Reveille said:
If you are using a query put this in the criteria for order
date.
between [enter start date] and [enter and date]
I suggest creating a form to hold these dates. add 2
unbound text fields in the form and in criteria section of
the query reference these dates by
[Forms]![NameOfForm]![NameOfTextbox]
On the form add a command buttonm that runs the query

Chris
-----Original Message-----
How do I select orders from a date section. I have a report date range built
but this is as far as I got. I have no clue where to start. I am new at
access and have learned what I know on my own. If someone would give me a
small example and let me know a little detail as to what all I need It would
be greatly appreciated.
Thanks in advance.
.
Click to expand...
Click to expand...
 
A

Alvin Smith

I got it!!!! Thanks Chris, I figured out I had to change some code in the VB
part of the report to solve this issue. All is well and thank you!
Alvin Smith
 
Top