My database tracks products - the product table includes descriptors like UPC, Category, Brand, Description, Size, and also tracks whether a specific product is approved at State level. The approval status is maintained within the JnctnStateUPC table at the SUUPC level in the RecentStatus field.
I'm trying to use that data to determine if a BRAND is approved. For example, if any of the RecentStatus records at SUUPC level indicate the UPC is approved, then I want to populate a field that says "Approved". Here are my tables
Here are the query results I'd like to see:
State-- Brand-- State Brand Status (assume this is a calculated field)
I would use criteria within the brand to select the brand, and the results I would then like to see would be one record for each state. Right now I've got the query written using calculated/expression fields to determine the State Brand Status, but that is giving me the results at SUUPC level. Again, for a specified brand, if any SUUPC is approved, I'd like to show that the brand is approved within that state.
Help?
I'm trying to use that data to determine if a BRAND is approved. For example, if any of the RecentStatus records at SUUPC level indicate the UPC is approved, then I want to populate a field that says "Approved". Here are my tables
Here are the query results I'd like to see:
State-- Brand-- State Brand Status (assume this is a calculated field)
I would use criteria within the brand to select the brand, and the results I would then like to see would be one record for each state. Right now I've got the query written using calculated/expression fields to determine the State Brand Status, but that is giving me the results at SUUPC level. Again, for a specified brand, if any SUUPC is approved, I'd like to show that the brand is approved within that state.
Help?