Many fields

[skydiver]

Okay...bear with me please. I have a report based on a query. The query/report contain 58 fields that I would like to be displayed on a one page report. Help!!!

 

[Kryst51]

Please give us more details, what exactly do you need help with?

 

[skydiver]

I've set up a table with many fields. From this table, I created a parameter query containing 58 fields. I would like to run a weekly report based on these particular fields and have them displayed on a one page report.

 

[Kryst51]

How many fields are in your table? 58? If so this may suggest normalization issues.

 

[skydiver]

83 fields in my main table. 58 for the query/report.

 

[Kryst51]

That certainly indicates an unnormalized db. Read up on normalization.

Here are some links:

http://databases.about.com/od/specificproducts/a/normalization.htm
http://bytes.com/topic/access/insights/585228-database-normalization-table-structures
http://www.allenbrowne.com/casu-22.html

Google Access DB normalization and you can find a lot on the topic. Until your db is normalized there is no use moving on to a report, Your db will be much more useful and easily dealt with once it is.

 

[skydiver]

Okay. Thank you.

 

[Kryst51]

Here's one more link

And your welcome, I'm sorry that you didn't get the answer you are looking for, but you will be better off taking care of the problem now, especially when you go to build reports.

 

[skydiver]

Got it! I love this forum. You guys are always helpful.