Create new table

[lizray]

I have no experience in this area so I appreciate any help/suggestions. I have a Table containing several fields, including VALUE,ID and TYPE. I want to create a new Table with fields VALUE and ID only, but if TYPE=D then ID should = ID+10000. What is the simplest way to do this ?

 

[Remou]

This can be done easily enough with a query.

In SQL view, it would look something like this:

SELECT IIf(tblA.Type='d',tblA.ID+1000,tblA.ID), 
tblA.Value
INTO NewTable
FROM tblA

http://lessthandot.com

 

[missinglinq]

You should note that two of your three fields names, Value and Type, are Reserved Words in Access and really need to be changed to something else. Not doing so almost assures that, sooner or later, the Access Gnomrs will jump up and bite where you sit!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[lizray]

Thanks Remou. you have made it look easy! and Misslnglinq for your very useful advice