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 biv343 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: Sarrkazztic
- Order by date
-
Access Query
UPDATE BREM SET LDC = IIf([Rate] Like 'V1*', 'VDO', IIf([Rate] Like 'VRC*', 'COH', IIf([Rate] Like 'REN*', 'DEO', [LDC]))) had to figure a few things out...but I got it...had to add the UPDATE YOUR TABLE part...and change Your TABLE to the name of the table.... Works great....being able to...- Sarrkazztic
- Post #6
- Forum: Microsoft: Access Other topics
-
Access Query
I am using Access 2002 on an XP machine.- Sarrkazztic
- Post #4
- Forum: Microsoft: Access Other topics
-
Access Query
Can I trouble you to tell me exactly where to put that code? I am fairly new to access but seem to be learning pretty quick.- Sarrkazztic
- Post #3
- Forum: Microsoft: Access Other topics
-
Access Query
Ok. I have a database and several tables and queries. I need to finish this off with either a make table query or an update query. Right now my final query produces a table with the following columns LDC Prospect Verify LDCAcct Billing Telephone Email Rate In my Rate column I have...- Sarrkazztic
- Thread
- Replies: 5
- Forum: Microsoft: Access Other topics
