Recent content by NigelC

jdraw, Thanks, I think I understand what you are saying. I need to look the query from a different perspective. I will review my logical data model and re-write my queries. Nigel

jdraw, Your summation of what is required is absolutely correct. My problem is that I understand what I want, but the query/report finds its data from the project table that links to the worksheet table that is linked to the staff table. Therefore all the engineers rates of pay is taken...

Hi All, I have developed a report that runs a query to work out all the engineers wages for a particular week. I have a table called projects, all the hours that our engineers work on a particular project is recorded in a table called WorkSheets. The Query asks for the date range and then...

Thanks David. Unfortunately we do have an accdb. Looks like I will need to learn Sharepoint.

GaryPanic and Lightwave, Thanks for your help. Its manic at work at the moment, so I will have to wait until xmas eve to try out your solutions.... can't wait! Nigel

Thanks sportsguy, that's working! nigel

Hi All, Quick background: I used to be a software engineer for military fighter jets, so I am not a bad programmer. But my knowledge of languages outside of ADA is nowhere near as good. Four years ago I started a company with my two brothers, and we soon needed a database to run the company...