Printing Just one Record

[nbaj]

Hello all,
I'm a bit of an Access (2000)novice, so please excuse me if this question is silly!

I want to create a report from a table, which has about 16 records, each of which contains 48 different fields (not every field will contain data though). What I'd like to do is to create a report of just one record - showing the data contained in each field for that one record e..g Record1 may have only have data in Fields 7-11 and Fields 19 and 25. So basically I want to see all the information I have stored on that one record.

Firstly, the report wizard won't let me create a report cause it says I have too many fields (I do actually need every one of these fields in the report). Secondly, even when I try and reduce the number of fields, I can't seem to select a report on just one single record - it reports on them all.

Please help!

 

[KenHigg]

nbaj, I would suggest you play around with doing some simple reports without the wizard stuff. I think you find out rather quickly that they are more of a handi-cap than a help in the long run. This should eliminate the number of flds problem. As far a one record, just base your report on a query instead of a table and place a parmeter on the appropriate fld.

???
Ken

 

[trucktime]

Print

Check out this link, it may be useful to you.

http://www.microsoft-accesssolutions.co.uk/print_form_record.htm

 

[Pat Hartman]

If Access complains about too many fields in a form, report, or table it may be that you need to compact the db. If you don't have more than 254 fields, then just compact the db so that Access can clean up deleted fields.