Basic IF...AND Statement in Access

[John P]

I know this is a basic function, but I am having a major brain cramp....I want to write a statement that does the following....

If Market (test field) is blank and admin is greater than 0, then populate with BUS, else leave the Market field as is....

Any assistance is greatly appreciated.

John

 

[Philem]

Hullo. This should do the trick:

NewField: Iif(IsNull([Market]) And [Admin]>0,BUS,[Market])

HTH

P

 

[Norie]

You need to create an update query.

The SQL would look something like this

UPDATE Table1 SET Table1.Market = "BUS"
WHERE (((Table1.Market) Is Null) AND ((Table1.Admin)>0));

 

[John P]

Thank you