printing based on ID range

[znyder]

Hi,

First, Im really new in access and all I can say is this site is such a help.. Learn so much.. but still I have this problem.
Im working on Access 2007, my problem is I want to print a certain data from my table based on their ID. I wanted to range it from ID = 1 up to ID 20 then the printout will display all the data. Sorry for my bad english and poor explanation...
I hope someone will take time to comprehend what im saying...

thanks...

[ChipR]

You can set the recordsource of the form/report that you want to print to
SELECT TOP 20 FROM ... ORDER BY id

[znyder]

thanks for the reply..
Is this the same if I have 1 to 100 entries and I only what to display on the report 50 to 70 data? thanks again..

[ChipR]

In that case, it would probably be eaiser to use BETWEEN like
SELECT * FROM ... WHERE id BETWEEN 50 AND 70 ORDER BY id

[znyder]

In that case, it would probably be eaiser to use BETWEEN like
SELECT * FROM ... WHERE id BETWEEN 50 AND 70 ORDER BY id

Hi ChipR,

Can you walk me through how to do this? please.. I have the following.
table: tbl_VouchDetail s
Fields/Data type
ID/Number "which i have done to increment automatically thanks to bytes"
Company/text
Payee/text
Amount/Number

thanks,
znyder