Recent content by Riz-Man

I see - what is the calculation (Access formula) I would perform in such an event...for say just one record (say Manufactuer X) in a given field (say the year 2007)? Thanks.

Hi, I have two tables: Table A provides total sales volume of the UK shoe market from 2000-2007. Table B provides the sales volume of different shoe manufacturers from 2000-07. I want a third table created, called Table C. This should look exactly like Table B but instead of sales volume it...

The sum of selected cells in different columns on the same row.... Hi, Thanks for your help. I got the total query working though not quite the way you showed me but oh well. Thanks for your help. Before, I move on to the next problem ;o) can you please confirm if it is possible to perform...

The sum of selected cells in different columns on the same row.... Thanks for your help. Still working on the totalling bit but I'm not getting the desired results. Since I have not started reading up on queries yet, I'll need to look into this, as this may be why I've got it wrong. However...

Hi, Sorry if this is simple stuff but I've just started learning Access (using a book from the In Easy Step's series) and taking it step by step...at the moment. Currently I'm building tables and forms. My first table (called Clients) lists the details of fictional clients. My second table...