Help with update query problems

[RJL1]

I have a table that I need to populate a field based on another field. I need to populate pick_area based on pick_location. My problem is that I have aplha/numeric locations so my pick_location field is set to TEXT. I would like to update my pick_area field like this

if the pick_location is aplha/numeric set pick_area = CAGE
if the pick_location is numeric only set pick_area = BULK

Thanks in advance for any help with this.

Thanks
Ricardo

 

[CosmoKramer]

Check out Access help for the IsNumeric function....



A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
Douglas Adams

 

[zrzr]

did you try the isnumeric function ?

iif(isnumeric(pick_location)=True,"BULK", "CAGE&quot

It will return BULK if pick_location is numeric, CAGE else. I suppose if pick_location isn't numeric, it is alphanumeric.

 

[RJL1]

I never used the isnumneric function but it worked great. This will help me out in several projects I'm working on.

Thanks
Ricardo