report fields

[Lois]

Hi
can i generate a report by using both a query & a table? i have too many fields for the 1 query to hold all the info i need on my report...

[hertfordkc]

normalized. Perhaps you need to create another table where your fields are records?
I can't directly answer your question as I've not encountered such a situation.

[Lois]

Hi,
i just have to show so many fields because i have delivery address fields & customer address fields which can relate to different addresses & lots of other fields as well..
do i need to add every field i want to use to the query or can i also use fields from tables. i tried this but a warning came up telling me the report would no longer be based on the query. i need it based on a query because it is a parameter query to look up a specific job nº...

[hertfordkc]

I'll take a look. Access provides so many ways of doing things that I'm sure there is an answer.

[ssanfu]

Hi,
i just have to show so many fields because i have delivery address fields & customer address fields which can relate to different addresses & lots of other fields as well..
do i need to add every field i want to use to the query or can i also use fields from tables. i tried this but a warning came up telling me the report would no longer be based on the query. i need it based on a query because it is a parameter query to look up a specific job nº...

Yes, you need to add every field to use to the query. No, you cannot use a field and a query (at the same time) as the record source.


It would help to know why you need so many fields for the report. How do you fit so many fields on a sheet of paper (the report)?

If you have repeating fields, then your design is wrong. Repeating fields is the way you would design an Excel spreadsheet, not a relational database.

Would you post the table structures?




Have you tried/thought about sub reports??