Search results

just wondered if anyone had had a chance to look at this and come up with any ideas? Wasn't in the office yesterday so i couldn't check. Thanks for your time.

the customer name i use is "cpl" i've scaled it down to just the essential tables. i didn't build the initial db that this takes its data from, so table structure etc was not of my doing

I tried as you suggested but it just comes back with an error "too many fields defined". As we have to pull results back from only the last year i will also rewrite Jan: IIf(Month([InspectionDate])="1","Checked","") to Jan: IIf(Month([InspectionDate])="1" AND...

The inspections table is used as follows Every time we get a fleet inspection we create a new record which is given an InspectionID (autonumber), and the registration number of the vehicle links to the vehicle table to give us a customer name, fleet name, fleet location and the dedicated dealer...

No problem. I will get to work on it after lunch, and post it online

I did try a cross tab but it still displays a new line for each check it finds on a vehicle, rather than combining them into one line, and it also then displays all job dates across the whole range of results as column headings. Thats why i went with the query that gave the least messy results...

damn, it removed my formatting on my examples. never mind i'm sure you'll get the picture of what it is im after.

I have a query which pulls the dates of all jobs performed on a customers vehicles. Currently we create a summary report in excel which shows in which of the last 12 months their vehicles were inspected, which takes a long time. Currently my query will look at the inspection date month, and...

oh, and im on access 2007.

Yeah i got that posted in correctly. I went through the whole thing checking that anything that wasnt a comment was as it is in the website. But now i've hit another brick wall anyway. Because of the way use several Db's together, from DOS sources and Access sources etc we (or should i say, I)...

Yes. Unfortunately i do. but then again i don't really know anything about VB etc, so im just picking things up as and when i can

Actually i sent an email to Allen Browne but the reply didn't shed any light "Needs to be in a standard module (not that of a form.)" I just copied and pasted into a module, and saved as ECount. but never mind

Swapping "Sum" for "Cint" i have managed to get the text boxes to display a value. BUT. it only displays the values for the final group footer, rather than adding up every group footer in the report. what can i do to get this to add up?

I have now sorted the problem using David's suggestion, and a modified report design Thank you both for your help

I have a report which groups a set of information about transport fleet costs. After each grouping i used an unbound text box so the report calculates the total costs for a fleet of vehicles, and the average cost per vehicle in the grouping footer. In the page footer i want to total the number...

its probably easier in the long run to remove duplicates before you run the query. post your sql. im no expert, but im picking things up every day (mainly off these forums) and i might have a solution for you, but i need to see where your data is coming from

If there are discrepancies in the names etc that would suggest the names are input manually more than once? I'd revise the linking of your tables so that names are pulled into a recordset using ther pupils ID number. This way you wont get the discrepancies in your data. If this isn;t the case...

I have put the following in an unbound textbox: =ECount("[RegistrationNumber]","[Costs By Fleet Location]","[RegistrationNumber]",True) However when i run the report it prompts me for a value for ECount. What could be causing this and how would it be fixed?

mike, I have implemented the Ecount, however, it prompts me for an "Ecount" when i run the report, and therefore returns an error. BUT the "Cost per vehicle" still works out a value, so it must be finding a value somewhere. David, I am also working on implementing your solution, and will let...

my bad, im trying to sum vehicle regs instead of count aren't i? monday mornings...