Recent content by AnnC

Thank you both. Just tested your theory and you're absolutely right. You have just completey changed my understanding of how Access works!!

I often have to export data from a table to a .csv (text) format. It is very important that the data remains in the right order. I even add an indexed auto number to ensure this happens. Sometimes, but not always, the data gets out of order. Not completely scrambled but chunks of records just...

Brilliant. It's easy when you know how!! Thanks very much.:)

I have a report which includes grouping. The number of groups can vary. The report then gives me a grand total at the end. But I then need to add a set amount multiplied by the number of groups. Can anyone tell me how to arrive at the number of groups every time the report is run but without...