Recent content by PvL

Hi guys If I have a table containing fields: - employee - date - amount of jobs As different employees work different days and have occasionally off days of course, how would I make a query with the result of a list of the employees and the average amounts of jobs per day? Guess this is an...

Again, I really appreciate your help, but am still stuck on this (although I am close) I took my own field out of the vehicle table and added the factor field. Built the query and ran it (which works!!). BUT, I have 2 issues: 1) You stated "Make this column number, type single", but the result...

Thank you ever so much Ben for your reply! But stupid enough it is the first bit I struggle with, which is to unify the vehicles as being mileage in one table. How do I make the table that unifies the vehicles to say "just " mileage. (For the vehicles I got a seperate table with a field "km_ml"...

I seem to break my head over the following problem and can't get it sorted so am turning to this awesome community to see if someone knows the answer :) I have a fleet database where I need to calculate MPG. I have looked on google but haven't found the answer (or not easily understandable for...

Hi guys (and gals) Got a bit stuck in a database. I have a form based on a query On the form I have 4 comboboxes. The combo boxes filter eachother without a problem (based on custom select query) Now I want after the fourth combobox value is selected, I want to populate a text field with a...

Hi guys (and gals) Got a bit stuck in a database. I have a form based on a query On the form I have 4 comboboxes. The combo boxes filter eachother without a problem (based on custom select query) Now I want after the fourth combobox value is selected, I want to populate a text field with a...