Query Help

**ncurran217** · 02-09-2012, 05:52 PM

Well in the end there will be alot of different ones depending on brand and a type of that brand. If that makes sense

**alansidman** · 02-09-2012, 06:30 PM

This could be done in a query, but would require nested iif statements. I think it would be better to do it in a form with a Select Case Statement in VBA.

Here are links to both types of tutorials.

Nested IIF http://office.microsoft.com/en-us/ac...001228853.aspx

Select Case http://www.techonthenet.com/access/f...anced/case.php

Re: Query Help