jayrolando
New member
- Local time
- Today, 07:05
- Joined
- Mar 25, 2020
- Messages
- 4
New to Access and have been practicing using old assignments I've found online. Enjoying the functionality of it all but now I've hit a roadblock.
The instructions are the following:
Create a query using the tblCustomer table. Display CustomerID, FirstName, LastName, and a new calculated field named Coupon?, in that order. In the Coupon? field, use the IIf and Like functions to display No Coupon if the customer did not take the tour and Send 10% off next visit if the customer did take the tour.
Tours being recorded as checked boxes in the tblCustomer table.
Up until now I've been using IIF and Like separately and I am now stumped as to how to use them together.
Any help would be greatly appreciated.
The instructions are the following:
Create a query using the tblCustomer table. Display CustomerID, FirstName, LastName, and a new calculated field named Coupon?, in that order. In the Coupon? field, use the IIf and Like functions to display No Coupon if the customer did not take the tour and Send 10% off next visit if the customer did take the tour.
Tours being recorded as checked boxes in the tblCustomer table.
Up until now I've been using IIF and Like separately and I am now stumped as to how to use them together.
Any help would be greatly appreciated.