Print out a report by date

G

Goosgog

I have a database that requires the report printout to be by date. how do I
do this whenever i have tried they just get mixed up
 
Ã

Özcan ELMALI

hi,
create a new query, and date criteria; Between [Start Date] And [End Date]
create a new Reports; for RecordSource, use this query.

Ozcan ELMALI
(e-mail address removed)
 
Ã

Özcan ELMALI

your welcome :)
i made a sample;
http://ispapazarlama.com.tr/FruitsOrder.mdb

the database has 1 form and table; 4 queries and reports.
reports named as "withform", running over the form. Please inspect this
database.

Best Regards;
Ozcan ELMALI
(e-mail address removed)

Goosgog said:
Thanks for the reply, but I don't think I made myself clear. The report has a
list of entries on it, that each have a date when then were written.It is
these dates that I want to print out in the correct order (by date) When I
made the query and asked for dates to be in ascending order , I thought this
will do it but I find 2006 dates coming after 2007 dates in a random order. I
hope I make myself clear and that you can still help. Thanks

Özcan ELMALI said:
hi,
create a new query, and date criteria; Between [Start Date] And [End Date]
create a new Reports; for RecordSource, use this query.

Ozcan ELMALI
(e-mail address removed)

Goosgog said:
I have a database that requires the report printout to be by date. how do I
do this whenever i have tried they just get mixed up
 
G

Goosgog

Thanks for the reply, but I don't think I made myself clear. The report has a
list of entries on it, that each have a date when then were written.It is
these dates that I want to print out in the correct order (by date) When I
made the query and asked for dates to be in ascending order , I thought this
will do it but I find 2006 dates coming after 2007 dates in a random order. I
hope I make myself clear and that you can still help. Thanks

Özcan ELMALI said:
hi,
create a new query, and date criteria; Between [Start Date] And [End Date]
create a new Reports; for RecordSource, use this query.

Ozcan ELMALI
(e-mail address removed)

Goosgog said:
I have a database that requires the report printout to be by date. how do I
do this whenever i have tried they just get mixed up
 

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

Top