Recent content by drewdt3

I think I've attched a screen shot of the update query. cheers Drew

Hi Guys Not been here for a long while but would love some help. I am trying to update a table to show that a vehicle from a certain date belongs to someone else. I have been messing around with update queries but it ends up updating to the new owner for all past and present services, not just...

Thanks guys I knew someone would come up with the answer. Cheers

I need to collate a league table of up to 50 people with 10 rounds of which the top 8 for each person will count. I need to be able to withdraw from the running total the bottom 2 results for each person on a monthly basis.

Hi, could anyone tell me how to remove the 2 lowest numbers from a row or colum of numbers. I know I can use MIN to remove the lowest but need to remove the 2 lowest. Thanks

Thanks Stopher What can I say but thanks very much for your time and genius. I don't understand a bit of it but it works!! Cheers Drew

Thanks Stopher, thanks for that, god only knows how you came up with it. One strange thing about it though is that it is ok when the total comes to an exact hour, however when it is say 37hours and 30mins it comes out as 38:-30, is thier a way around this?

I have a really annoyong problem in a report that when I try to calculate the total hours per person for the week the sum comes up with time that are well short of the mark. My total box in design view reads - =Sum([total hours]) Can anyone suggest a modification to this line please. My sanity...

Scratching Head Thanks guys for the hel, however I'm still scratching my head. I'm at the dummy end of databases so you perhaps need to spell it out a bit simpler to me. I am trying to use, at the moment, in the criteria section: - between [from date] and [to date] [from date]is...

Hi, hope someone can help. I want the option of leaving perameters blank in a query in more than one field. the problem is that if I leave one blank and fill the perameters in for the other it brings all records up anyway. Is there a way around this? :rolleyes:

I have a database that logs vehicle, vehicle Mileage and qty of fuel issued at that mileage. I want to calculate the miles per gallon for each vehicle in a report. To do this calculation I need to omit the very first fuel qty for each vehicle but not the mileage, can anyone think of a way of...

Thanks very much mate. sorted!!

I have a small fleet of vehicles that I need to keep a check on the last services. I want to adjust my query so that it only shows the last service for each vehicle, i.e. the latest date. I have messed around with the MAX function on the drop down box to no avail, can anyone please help a...

query to extract the "next due date" I have a fleet of vehicles with a form to fill in every time they are serviced. The last field in the form automatically fills in the last field which is "next service due", (6 week intervals). What I want is to draw a report off that tells the next service...

Last Date Could you please expand a little further and explain what you meen by table1? Thanks