i am now currently making a qurey to be used to make an invoice (report) but coz every invoice needs a unique number i have added an auto number but it doesn't seem to work and the other fields are blank...whats wrong???

Based on the explanation,
I can't understand the situation.
Can you more fully explain your query,
so I can at least formulate a theory?

I’m making the following assumption from what you’ve said,

I would guess that you have some existing data in several tables, possibly Items sold, customer sold to, maybe a couple of other tables as well. You need an invoice but you don’t have an invoice number so you have made an empty table, and provided that table with an auto ID field.

Now you are trying to pull all the information you want together in to one query including the new empty table with the auto ID field.

I’m afraid it won’t work, the only way you could do it like this is by making an entry based on the new table with the auto ID field, this would establish an invoice number then you would need to add the relevant data from each of the other tables with a combo box or something similar.