Search results for query: *

Thank you both. I had been staring at this forever, but couldn't see the goofy mistakes. Just to complete the thread I've included the final code: IIf(IsNumeric([PatientAccountNumber]),IIf(Len([PatientAccountNumber])=10,1,0),0) Thanks again,

I am trying to use the following formula within a query: IIf(IsNumeric([AccountNumber]),IIf(Len([AccountNumber]=10),"1","0"),"0") Ultimately, I am trying to create a case hit that shows that the accountnumber is numeric and is 10 numbers long. I continue to get a Data Match error. I want...

Davec8723, I'm not a great SQL person either, but I think you can do it this way: SELECT Score.Field1, Score.Percentage, GradeNm.Grade FROM Score INNER JOIN GradeNm ON Score.Percentage > GradeNm.GradeMin AND Score.Percentage < Grade.GradeMax Just switch your view to SQL and add...

Actually, I was saying those formats would not match. It may have been better to say that an id could be in a format(mask) of ####-XXX, ######, ###-##-XXX, etc. I am really looking that 1234-abc matches (or doesn't match) the expected format ####-XXX. Thanks for the help.

I apologize if there is a repeat here, but I've looked for this topic and can't seem to find it. I am trying to find a way to compare fields (both are account id's) from separate sources to see if their accounts id's are in the same format. I picture having a table with the expected format...

I still can't get the macro to work, but I found the DoCmd.RunSavedImportExport "SavedImportName" command which worked.

Hello, I am trying to create a macro to import files into my database. I've already been through the hidden action in the Macro settins (Show All Actions), I've digitally signed my database and I've trusted all macros. When I use the Action, RunSavedImportExport, I am required to specify the...

Sorry, I didn't see your response MajP. I think a new table is probably in order. I'll try that and see what happens. Thanks.

Here is a sample of what I would be looking for: AccountNumber Client Dollar Output 1005001 ClientA 25000 >10,000 1005001 ClientA 25000 >5,000 1005001 ClientA 25000 >1,000 1005020 ClientB 11000 >5,000 1005020 ClientB 11000 >5,000 1006010 ClientC 1200 >1,000 Thank you for your help on this...

I am trying to write a query that will tag a record if it meets certain criteria. I have a couple different criteria that I want to separate using OR, but I'm not sure how to do this within the select statement. I'm am currently getting "0" or "-1" with the following statement: (...