Comparing field values in different records

[cfcanter]

Store Account Amount
500 12000 1000
500 12000 2000
600 12000 2000

I want to loop through an Access table like the one above and when the store number changes the loop stops. Basically I am writing to a file and want a new file to be created when the store number changes. any suggestions b/c I don't even know where to start

Craig Canter
Cost Accountant
Sipex
Milpitas, CA

 

[PHV]

Why not using a report ?
Or the DoCmd.OutputTo method ?
Or the DoCmd.TransferText method ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244