Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: raisinchicky
- Content: Threads
- Order by date
-
Unexpected "Enter Parameter Value" pop up box
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...- raisinchicky
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
-
Can you spot the syntax error?!
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...- raisinchicky
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
-
wildcard query in approach
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...- raisinchicky
- Thread
- Replies: 1
- Forum: Lotus/IBM: Approach
