"Field List" when designing a report does not include all items defined

  • Thread starter Thread starter Stuart Beaton
  • Start date Start date
S

Stuart Beaton

When the "Field list" is accessed whilst in report design
mode it does not include all of the defined fields from
the database table. How do I correct this please and get
the missing filds added. Closing and reopening the
database does not sort the problem. When the field list is
accesed during design of the database input field the
fields are present.
Thanks
 
The table is probably not the record source for the report.
It's either a query or an SQL statement.
Add the fields to the query/SQL, then save the query.
They should now show in the Report Field List.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't create a report from my query in Access 1
Crosstab report - handling Null fields 4
Access Does not recognize " as a valid field name or expression 1
Including non related text in a report 4
Access Access Report Works on One Machine but not Another 3
Report Detail Section Items Layed-Out Horizontally 1
Report to calculate total spent by customers in a customer db 8
Including records with null values in report 8

Back
Top