how to quiery and print it?????

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i would like to create an quiery on my table by the "date" column. ex: "between this date and this date". Then put it on a form or sheet ( i guess) then print it if i wanted to. Can any one direct me to some code or to a site where i can learn more to accomplish this task....HELP!
 
----- Luis wrote: ----

i would like to create an quiery on my table by the "date" column. ex: "between this date and this date". Then put it on a form or sheet ( i guess) then print it if i wanted to. Can any one direct me to some code or to a site where i can learn more to accomplish this task....HELP

i neglected to mention that when i said "between this date and this date" it would come from "date1.text" text box on a form.
 
Create the query (using the New Query Wizard if you need to). Once it is
displaying the info you want in the correct format, then create a new report
(again, using the wizard if needed) based on that query. Access makes this
sort of thing reasonably simple...

Post back if you need more info...

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

Luis said:
----- Luis wrote: -----

i would like to create an quiery on my table by the "date" column.
Click to expand...
ex: "between this date and this date". Then put it on a form or sheet ( i
guess) then print it if i wanted to. Can any one direct me to some code or
to a site where i can learn more to accomplish this task....HELP!
i neglected to mention that when i said "between this date and this date"
Click to expand...
it would come from "date1.text" text box on a form.
 
ok, i have played around with the quiery wizard, but how do i call it and how do i import the "date_from" to "Date_to" textbox.txt to the new created repot????
 
textbox? Is there a form involved here? You would use the expression
builder (in the query design view) to add the form's controls as criteria in
the query
--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

Luis said:
ok, i have played around with the quiery wizard, but how do i call it and
Click to expand...
how do i import the "date_from" to "Date_to" textbox.txt to the new created
repot????
 
Your looking to create a parameter query. Under the
criteria area in the query, you must insert something
along the lines of Between[Start Date] and [End Date].
This will give you the date parameters you are looking
for.

Frank
 
How would the quiery look like and how do i apply the quiery to the report that i created in the wizard????

----- (e-mail address removed) wrote: ----

Your looking to create a parameter query. Under the
criteria area in the query, you must insert something
along the lines of Between[Start Date] and [End Date].
This will give you the date parameters you are looking
for.

Fran
-----Original Message----
Create the query (using the New Query Wizard if you need to). Once it i
displaying the info you want in the correct format, then create a new repor
(again, using the wizard if needed) based on that query. Access makes thi
sort of thing reasonably simple..
Post back if you need more info..
--
Click to expand...
Kevin Hil
Presiden
3NF Consultin
Click to expand...
 
Back
Top