Need quick help for IIF function. Returning results of a certain format

[Aero11]

Hello everyone. I have been trying to figure out queries for a little while now at work, and usually I can find my answer by myself. However, I have been unable to find my answer this time, and I'm hoping to get some help here.

What I am trying to do is to create an IIF function that returns results in a certain format. I'm sure this can be done, but I don't think I am using the right commands. Specifically, I want the query to return the result "Commercial" if the search result is in the format 12-34-56, and return "Military" if the number is in any other format.

Something like...

IIF((Wo_headc.ATA_MAN_NBR) LIKE "**-**-**",'Commercial','Military')

??

Please help. Thanks! This is driving me crazy!

 

[Aero11]

Didn't get the answer I was looking for here, but I ended up figuring out how to do what I wanted.

Instead of using "%"'s, the trick is to use underscores "_"'s. So the proper syntax is

IIF((Wo_headc.ATA_MAN_NBR) Like '__-__-__','Commercial','Military')

 

[cstimart]

Anyone? I could really use some help with this one.

Are you able to get a query to work properly in access w/oMS Query?

 

[Aero11]

Are you able to get a query to work properly in access w/oMS Query?

I figured it out. Thanks