Recent content by liftshaft

Figured it out.... Using group by in my query where I did not need to.... Thanks for all your help.... Please close thread....

I hate to sound thick, but where would I put this?

Can I make a count default to zero if criteria is not met, rather than passing a null value to a report? <snip> This was originally posted in Report forum and has been followed up on a fair bit if you would like background information please follow this link...

Cheers Mac... I think I will plod on and try to come up with a hack, thanks for the offer but to tell you the truth I am fed up to the back teeth with it (pun intended).... Thanks for your help Chris ---Mac a shining beacon in a dark, scary world....All hail Mac

Thanks Mac.... I like the design, has given me some things to think about, makes me wonder what I am giong to do to turn around my stabbings in the dark. My only problem here is that the record is generated based on patients attendance, at which point any of the procedures and or complications...

Yeah... started off as a small project and grew.... Client is always wrong type of thing.....;) Query forest.... thats right... My first larg(ish) database, so imagine my horror when I tried to use more than a certain number of queries on on report.... I will get around to tidying it up a...

Please see attached cut down version.... contents Dummy data table (Patient Stats) 2 Reports (Report1 and complications) A lot of queries.... In this instance, the value of Cons query causes problem, can be demonstrated by changing 1 Cons value (table) to yes..... Hope this makes sense...

Please ignore my dumbness The only thing with this is where would I use the NZ function, in my query or on the report... From what I have read about NZ it is used exclusively with variables. Will I pass the information generated by the query to a variable and do it this way or will I...

Sorry, I should also say that I am looking to return zero (0) if criteria doesn't match.

I have a number of queries which when referenced through my report and conditions match work fine. e.g. SELECT Count([Patient Stats].[Anaesthesia Lip]) AS [CountOfAnaesthesia Lip] FROM [Patient Stats] WHERE ((([Patient Stats].Date) Between [Start Date] And [End Date])) GROUP BY [Patient...