Search results for query: *

Try using a >[date here]and<[date here] in the date colum of your query. This will produce a msg box to fill in the dates required

I have a queary that prompts for a name then delivers a report showing data against the name I have chosen. The report calls on a query with the following prompt that is in a msg box. [Enter area name here] What i would like is the message box with a combo list of the area names in it to...

Check your calender setting for the tasks and the resources assigned to the task. If one tasks is behind schedule it will affect the mean average of the total WBS rollup percentage Cheers John www.palmcrest.com.au

Thanks for that. It just dawned on me I was calling the resource name from the wrong table and the outer left join was not showing any difference. It helps when you call the field from the correct table Thanks JB

I have a query with a list of names called Resources It contains 5 resource types Plumber Electrician Painter Carpenter Tiler I have another table with job names [Assignments] and assigned resource types with work hours IE: Cut timber Carpenter 4 hours First floor Fix pipes Plumber 2 hours...