Search results

Hi All, I have searched and searched, and searched some more. I still cannot get this to work. I have a simple Table of - [IDNo] [PaymentNo] [PaymentDate] [PaymentAmount] I want to create a running total in a query for each IDNo. What's the best way of doing this? DSum? Crosstab? Please help.

Hi All, I need to be able to have the staff in my dept. record their visits for the month. I have one query which works out how many working days per month for the next two years. I am having difficulties knowing where/how to enter the physical data. I have 7 members of staff that need to...

Hi All, My boss has asked me if I can change the visit log spreadsheet into a database to provide better reporting of time. I have attached an image of the spreadsheet and I need to turn this into a dbase. To be honest I have been racking my brains trying to think how to do this. I know...

Hi All, I have searched, and searched again but what I need is not here, unless I am being a plank. (Which is highly probable!!) I can find out how to query working days between two dates but what I need is slightly different. My staff fill in a spreadsheet at the moment with the visits...

I've looked but cannot find my answer. I am changing the way my works record repairs. At present they are using an excel worksheet but I said that Access would, of course, be much more productive. I have transferred 600+ addresses over but as it's previously in excel everything is in one...

Hi all, Thanks to the help previously I have managed to create a Combo Box to select information. I am getting good at this!!! On my form I have details of customers and my combo box allows me to update their progress. Once updated a new text box appears, which remains not visible, to allow...

Hi all, I have a form with a combo box with the following selections: No Contact Support Commenced Refused by Agency Refused by Tenant What I want sounds simple, if i select one of these, for example, Refused by Agency a form pops up and asks to input reasons why. Or if Support Commenced is...

Hi folks, I am having problems with my report. It groups together information on a monthly basis (Count([Referral Date 1]))- January x3, Feb x12, Mar x1 etc.. What I want to do is have a grand total at the bottom. Can anyone help? Thanks