I need to show records that have a contract number like US-###### (6 digits)
The issue is that sometimes a user forgets the 'dash'
I have developed a qry and not sure if it is correct.
Please see bold part below.
I am not sure if I need to test for 6 digits or not or just have 1 '#' sign.
I think the "#" sign represents a digit but not sure about that.
The "?" represents any character and a space I think.
(excuse me....not a programmer)
SELECT Projects.ProjectNo, Projects.ContractingEntity
WHERE (((Projects.ProjectNo) Like "*US?#*") AND ((Projects.ContractingEntity)<>2));