Hi Alex, thank you for your response. Could you perhaps be a bit more specific, about this discrepancy in field header section vs. different field Text Box in that section? Thank you very much! You and Richard are really helping me to learn Access (slowly, but surely.)
Reply from Alex Hedley:
If your query has multiple fields and you have grouped them they will show a sub query for each group, this can have a sort/order, Since you are grouping by a specific field and you place that in the header it will show that given value, since they are all the same, add the same field to the detail section and you will see. If you add a field that isn't in the group to the header it will show the first value in the sub query since it can only show 1 value, again see this in the header against the detail when you are displaying the data.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 12.