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!
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!