Printing report in the same order as entered on a form

J

JFI

I am having trouble printing a report in the same order as the items are
entered in the Access Form. The query runs the items in the correct order,
but the report scrambles the items all over the board. Can anyone help?

Thanks
 
G

ghetto_banjo

are you recording the date the record was entered in one of your
tables? if so, open the Sorting & Grouping options in your report and
sort on that date ascending.
 
K

KARL DEWEY

ghetto_banjo told you the how but the why is that Access reports ignore sorts
done in a query.
 

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

Similar Threads

Access2007: CustomReport - User entered Sort order 0
Print Report without openning it / Fast printing 1
Printing of sub-report skips to second page. 3
report not following the query 2
Group Items on Report but do Not Sort the Group alphabetically 2
repeat a copy of a report based on a parameter 1
Missing Report Header 1
Master/Child what section 4

Top