Recent content by hurst75

Hi All, My apologies if I have posted this in the wrong thread - please point me in the right direction if this is the case. Background to my Question; My potential clients fill in a form on my website which populates a Mysql DB. I use Access to connect/link to the Mysql DB and from each...

Thanks Mailman, I've done it and without DCount as recommended. Cheers

I'm afraid my access knowledge is a little rusty, having designed this database some 5-6 yrs ago. Is the statement below true; Left Join Properties = Include all the records from 'Asbestos' and only those records from 'AsbestosSample' where the joined fields are equal If the above is true...

Hi All, I posted the other day, got two perfect answers from Anchoress and Scooterbug (thanks for that guys!) and then realised that my question didn't go far enough for what I want to do. So to briefly outline, I have 2 tables, Asbestos and AsbestosSample I am a surveyor and visit sites...

@Anchoress - Thanks so much thats great. I forgot to mention one thing though. I only charge for the item identification where a sample is taken from said item and sent to a lab. Therefore, there is criteria for the count : where, the field named identificationlevel = "sample" How do I...

Hi All, I'm trying to get my database to produce invoices. I am a surveyor and carry out asbestos surveys which involves inspecting sites and identifying asbestos containing materials. Below are the database parameters; I have two tables - Asbestos, AsbestosSample Asbestos contains the...