access

[DIRTsquirt]

I am new to MS Access and trying to figure out the layout for a table.
My question is this.. can you search a field for value say there are multiple values in the field ie: 1,4,10 .. and if the value is found, print all records containing that value. I want the entire record to print.
What method would be used to print such a page ie query, filter etc.

 

[EagleKeeper]

Create the query and then click the print icon. All records that matched the query will be printed. Depending on the formatting, it may cross multiple pages for both columns and rows.

 

[WannaFly]

query:
select * from <table> where id=1 or id=4 or id=10