Hi all, registered in order to ask this. I've searched around, and haven't found this one anywhere.
I am running MS Access 2016. Application is part marking in a manufacturing setting. The marking is driven by the customers, so we make the part but have to mark for customer. Customer 1 is different than what Customer 2 needs, for example.
So, we also have customers who have marking based on who owns the trademark. They bought out a company from a different country, and we made parts for both companies. Now, we are marking parts that went to Customer 2, and selling them to Customer 1, after they bought out Customer 2 (for example).
The issue here is that the marking has to include something prefixing the marking if it was trademarked by Customer 2, but does not go in if it was trademarked by Customer 1.
Code:
IIf([TrademarkOwner]="Customer 2","Cust 2 prefix"," ") & "ALL PREFIX " & [CustomerPN] & " " & [Serial Number Prefix] & "----- " AS PartMark
This is my query. I have a field in my table for "TrademarkOwner", which calls out either Customer1 or Customer2 (with their actual names). I have a query prompt on the PO number. I have a report built off the query.
When I run the query, the query results look good, it gives the prefix. When I run the report, I put in the PO as the prompt, and the report does not show the prefix, even though it's pulling from the same query. It just gives me the strings starting at "ALL PREFIX" above.
Any thoughts? I can't upload the original but I might be able to make a dummy to upload if needed.