Microsoft Access Query Help!?

Question

I am trying to do a query on Access where by it will only display
customers who are "AWAITING DEPOSIT" "PAID IN FULL" "ENQUIRIES" which also contains 4 records in the Customer field which represent address1, address2, address 3 & post code. I really can't get this to work for some reason and wondered if anyone could help, further more I need this information displayed in such a way that it would fit on Averies in Microsoft Word...

Help would be much appreciated.

Answer 1

You need to apply NORMALISATION. (Look it up if you need to)



Create a table for Status with 2 fields - one for text and one for an ID. Put in the different states (as listed in your question) in ascending order (think about this order carefully). Go to your original table, create a lookup field referring to the Status table. When building your query, now use the value of the ID field (e.g. StatusID>2)

Answer 2

Use this condition in your where clause: MOD(columnname, 100) = 0 or column % 100 = 0 depending on the query syntax needed. Try the first one first.

Answer 3

in you query grid (aka QBE grid) in the criteria section of the filed you want to query on you need to seperate each value by "or". you can also put them going down in the same field.



Hope this helps..