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!
-
Enter Parameter Value IIf problem
Well, it didn't give me the Enter Parameter Value box, but it didn't add $2 to the BillTotal for Orders from Naples. Any other ideas? Thanks! feafee- feafee
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Enter Parameter Value IIf problem
Ok, I need to make a calculated field named BillTotal that adds the order amount and the delivery charge. I also want to use the IIf function to add $2 to the BillTotal field if the city is Naples. I've been pretty stuck on this, so any help would be appreciated. I am able to add the two...- feafee
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
