Count function which will ignore duplicates?

[Brianwarnock]

I'm on 2002 sp3 and if I make a function name the same as the module I get an undefined function when I try to execute it

Brian

Happy zzzzzz's Mike

 

[Rik_StHelens]

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) link them together using Access's external data linking. But it makes it difficult to normalise because some systems are looked after by external developers.

So when i put a date parameter on my query to put a total cost against each fleet, it pulls back every single instance in which that vehicle has been worked on because the date parameter comes from the TRNLIST (job) table.

Which then messes up my vehicle count, so i show all records in an on screen report in the detail section, but omit them from the printed version which serves as a summary of costs per vehicle per fleet.

But now when i want to do total costs, vehicle numbers etc, it just aint happening.

http://www.access-programmers.co.uk/forums/showthread.php?t=182959


I just love computers

 

[Rik_StHelens]

oh, and im on access 2007.

 

[Mike375]

I m sure I hve had that notice too Brian.

I could not help myself. Attached

The attched is the same form, table and module except I knocked lots of records and fields out of it. Now it won't work if I call the function ECount. The Textbox has a #Name

 

[Mike375]

That is weird. I just went back to the extract and reimported the full table and get #Name with function called ECount.

But where then the form, module and table are in the full data base it works with the function called ECount.

I knew I shouldn't started this at 2.00am