Hello all,



I'm working on an Access databse for work that keeps an inventory of all of the computers in the building. One of my queries contains a calculated field that takes the service tag from each computer and converts it into the URL for Dell's support page for that computer.

Code:
 
Dell URL: "http://support.dell.com/support/topics/global.aspx/support/my_systems_info/details?c=us&cs=RC978219&l=en&s=slg&servicetag="+LCase([Service Tag])
Unfortunately, although most of our computers are Dell computers, not every machine we use is. So I would like to create an IIf statement to handle the few cases in which a computer isn't a Dell, and leave the URL filend blank. I've constructed the statement like this:

Code:
 
Dell URL: IIf([Model]= like "*Dell*","http://support.dell.com/support/topics/global.aspx/support/my_systems_info/details?c=us&cs=RC978219&l=en&s=slg&servicetag="+LCase([Service Tag])," ")
My intention is that any computer that contains the word "Dell" in its model will show the calculated URL, while computers without "Dell" will leave this field blank. I believe that the syntax for the IIf statement is correct, but what I'm hung up on is how to use "like" or "contains" with Access. I know that "like" is used for filtering criteria, but it doesn't seem to be working with my calculated field. Any ideas?

thanks,
chellion