Hi,
I've got a tricky to explain problem, so I'll try to explain with an example. Basically, I have a payments table, with various payment types (fee, porterage, travel, early start etc). What I want to do eventually, is to create separate remittance advice reports for each supplier, detailing the fee for each payment type. However, I want the fee payment type to appear first.
When I enter the data to the payments table, I always enter the fee field first (in this case, it's number 1, which is connected to the payment type table). However, when I run a query on the payments table, the payment types don't seem to be in any discernible order. Apart from putting it in alphabetical order, which wouldn't help anyway, I'm not sure how to arrange it so that the fee payment type is at the top. I'm using Access 2007 if that's relevant.
Edit: I just did some more investigating, I think actually the query is displaying the payment types in reverse order, to which I entered them. Is there an easy solution to this?
Many thanks for any help.