Search results for query: *

pwise, you're a genius! It took me a while to find the query properites, but you were right, it had Query1.BusinessUnit in there. No idea why! Thankyou very much, I can sleep easily tonight ;o) Tanya

Thankyou for getting back to me so quickly! I've had a look at the SQL and can't find any reference to Query1 in any of the other queries, but I suppose it must there somewhere, else I wouldn't be getting the error. I've been working on this all day so I'm going to go home now and look at it...

Hello, I'm struggling with a database. Before I even start to explain the problem, I want to say that I know I'm way over my head but my boss is insisting, so although any help would be appreciated, I might not understand it! All I've had is a one-day, intermediate level training course and the...

Thankyou all for your help!! I swear, I'd been staring at the daft thing so long I'd almost gone blind, no wonder I didn't spot that I didn't have enough IIf's! love, t xxx

I've been puzzling over this all evening! I'm sure its incredibly simple, but Access is telling me I have a syntax error (comma) in the following statement: IIf([BusinessUnit]="Registrations",(IIf([TotalCalls]=0,0,[Total Plans]/[TotalCalls])>0.012,"Over","Under"),0) AS ConvTarget Any help...

I designed a database in Access but then had to change it into Approach. I had a query set up whereby the user would enter the text they wanted to find into a popup window and Access would search the relevant field, automatically inserting a wildcard either side of the text. Is there any way to...