How to add data into a field based of the value of another

[VhbuiA]

Hi, I have done a lot of research and have not quite found the solution to a problem I am having...hope someone can point me into the right direction.

I created a table using VBA to pull data from an Excel spreadsheet into my db. However, I only require select fields for the purpose of the db. So I then created a event that only captures the fields I need into a new table. The reason why I am doing this is to keep the original source data in tact. OK, so here's the problem: After the data is pulled in the SQL event, I want it to take the values of Field X (populated after the event) and determine if it is a specific value (say "YES"), then Field Y = "CASH", all others "CREDIT"

Is this possible to do? Any help is greatly appreciated! Thanks!

 

[rubbernilly]

You can run two update queries...

UPDATE YourTable SET YourTable.FieldY = 'CASH' WHERE YourTable.FieldX = 'YES'

UPDATE YourTable SET YourTable.FieldY = 'CASH' WHERE YourTable.FieldX <> 'YES'

You can also do it through DAO, but this is quicker and less painful if it does what you need.

 

[VhbuiA]

Thanks! It worked like a charm...=)

 

[rubbernilly]

Sorry, that second query should have been setting the field to CREDIT, but I'm sure you figured that out.