Multiply in Query

Hello

The method I gave you, if it was prompting for the figures each time, you would have been spelling the field names incorrectly! You should be creating a Query, with the two fields you want to calculate. after you add these to the query, run the query... you should see a datasheet list of all the rates charged and hours worked per record.
Return to design view. Add a new field by typing directly in the field row of the query grid, call this whatever you like, followed by Colon. Then type square bracket and within type the name you have called the hours worked field, exactly as it appears in the table, close square bracket. Type * then open square bracket and the name of the field of the hourly rate, close square bracket. Your whole field line should look like this.
totalpaid:[hours field name]*[hourly rate field name]

run this query, you should see results.. if you get a dialog box pop up, you have mis-spelt the field names!
if you still have problems send me a sample of your database mm@stl-training.co.uk




I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer