Search results

If i select 0 then it just brings the sum of those that are zero, not those that are higher than zero

Hi guys, I have the following information in a table: NI Num Subscription Balance NI # 1 17 36 NI # 1 50 500 NI # 1 100 0 NI # 1...

Thanks for your response Trevor G - i'm in the same position stuck with update queries - can you suggest a structure

Hi guys, I’m having trouble with append queries. I have the following tables: Customer Number First name Surname DOB Post-code A company will occasionally send us large updates to post-codes which will show records and new data. It’s not as simple as replacing the entire...

Thanks for the welcome. Only one item can be purchased per purchasing event. I tried using a query but it simply takes all stock of all items and minuses it against all purchases of all items so it's bulk stock rather than item. For example i have the following stock 10 ipads 20 blackberries...

Hi guys, Firstly apologies if I’m in the wrong place. I’m reacquainting myself with Access and have created a simple database for the logging of purchases through a store. I have the following tables: Customer Customer_number First_name Surname Item Item code Item name...