Search results

Right i have created the 2nd query, but it just says that either the expression is typed incorrectly or too complicated to be evaluated, i know i tried something similar orignally but got the same error message. Here is the SQL: SELECT tblVehicle.Customer, tblVehicle.FleetName...

It would be highly likely, because we often send out workmen to look at a vehicle which is now based 200 miles away from the fleet location we have on record because our customers don't always pass on updates. nature of the industry i think. we are aware that this would have a bearing on the...

Try report grouping I've attached an example to your db file. Just run the "Courses" report and see if its more of what you're looking for hope this helps.

What you could do is use the following as a criteria for staff name (or the unique identifier NI?) Like "*" & [Staff NI (Leave Blank For All)] & "*" And then if you output that to a report, and group the report by Staff NI (or name as you wish) it should list all training courses for that...

Hi, I have a query which outputs to a report. It takes a full set of customer vehicles, groups them by fleet location and count the total costs incurred by that fleet for repairs/inspections etc. The report then works out the average cost per vehicle, by fleet. In the report i do a count...

Re: you tried to execute a query that does not include "" as part of the aggregate Thanks David It was already expressed as a percentage, however i didn't think about dividing by 100 at the end. Like i said, simple solution Thank you

Re: you tried to execute a query that does not include "" as part of the aggregate Ahh ok, i have got it working now, so thank you very much for your help. However, my solution is supposed to also calculate a percentage based on a couple of values, in order to calculate a service failure...

Re: you tried to execute a query that does not include "" as part of the aggregate Yeah i noticed that just after i posted it. oops. It would appear that if i remove the two count functions, the query runs. Before i added in the count functions i tested the query, and it only pulled back...

you tried to execute a query that does not include "" as part of the aggregate Hi, I have keep getting the error message "you tried to execute a query that does not include CUSTOMER as part of the aggregate function" I've had a nose around the net but not found any solutions so thought i'd...

nope. unfortunately not.

No thats not the problem either hmmm

Yep i removed it from both the sql and the parameters.

No it is just based on a single table. I just copied and pasted a query which used identical fields, and removed the old parameter and added a new one to the field required. I've checked the sql and there was nothing abnormal in there compared with my other queries

No it wasnt a reserved word because i have queries pulling the same data but with different parameters. And im really not sure why it wouldnt accept the implicit parameter, but once i declared it at the top of the sql it was fine. although now i have another query which is asking for a...

Thanks for all your help I ended up combining the FJ number with a tyre positioning number to create a unique (and instantly more relevant) number which is unique, and identifies which tyre position on the lorry was worked on. Thanks again

Many thanks for your help, DCrake's solution was just what i needed. Thanks a lot.

Thanks for all your help I will try it out when i get back to work and let you know if anything works out....

Ok based on Brians advice i have decided to implement an update query which will add a CAN Number. I cannot use Mailmans primary key idea as this database draws all its information from a DOS based system that we do not want to touch, and the CAN Number is going to be the primary key. At...

SELECT AllCasingJobs.CUSTOMER, AllCasingJobs.INVNUM, AllCasingJobs.[CAN Number], AllCasingJobs.DELIVERY, AllCasingJobs.INVDATE, AllCasingJobs.Destination, AllCasingJobs.REGNUM, AllCasingJobs.POSITION, AllCasingJobs.TREADM, AllCasingJobs.SERIALON, AllCasingJobs.SERIALOFF, AllCasingJobs.SECTION...

Hi I have a query which asks the user to input a value to find a specific record, and when i run the query, access does not prompt the user to enter a value, and just returns all records which do not have a null value in the said field. Is there a reason as to why it might do this?