Search results

I have two fields, shop # and code date. If the shop # is blank, I want the code date to calculate as it is currently doing. If there is anything in the shop #, I want a Look-Up to control the code date (looking up the value from another session). Ideas?

I have a field with a pallet tag that is scanned. I have validation on this field to be unique in table, yet it does not check the SQL database to see if there is already a tag that is a duplicate of the one just scanned. Am I missing anything that needs to be added to this? I do have a live...

I'm having a hard time trying to subtract two dates. Overall I'm trying to come up with a way to take a receiving date, find the wednesday of that week and then add 49 to it. So I need a date that shows 49 days from that Wednesday of that week (which the week is Sunday - Saturday). I've tried...