R
Road Warrior
Been away from Access for a while, and know it can be quirky, and maybe this
is a simple question, but here's my problem:
Why won't the data from all fields in a query appear on a report?
For example, I ask for Fields A,B, C & D to be displayed using a query as a
source and only data from A&D appear.
But the header for B&C appear, and I can format B&C e.g., put a box around
where data should be---but no data is is in the box displayed
If I call the data direct from the table it all appears.
I've checked properties for fields that appear and those that don't appear
and they're identical--both in the table and in the query
Must be something basic I'm missing---any suggestions would be appreciated
is a simple question, but here's my problem:
Why won't the data from all fields in a query appear on a report?
For example, I ask for Fields A,B, C & D to be displayed using a query as a
source and only data from A&D appear.
But the header for B&C appear, and I can format B&C e.g., put a box around
where data should be---but no data is is in the box displayed
If I call the data direct from the table it all appears.
I've checked properties for fields that appear and those that don't appear
and they're identical--both in the table and in the query
Must be something basic I'm missing---any suggestions would be appreciated