Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JS1521253

    What does LEN return?

    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,
  2. JS1521253

    What does LEN return?

    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...
  3. JS1521253

    **Instead of an IIF Statement...

    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...
  4. JS1521253

    Need to Compare the format of 2 fields

    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.
  5. JS1521253

    Need to Compare the format of 2 fields

    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...
  6. JS1521253

    RunSavedImportExport Macro not populating saved imports

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

    RunSavedImportExport Macro not populating saved imports

    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...
  8. JS1521253

    IIF Statement with OR

    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.
  9. JS1521253

    IIF Statement with OR

    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...
  10. JS1521253

    IIF Statement with OR

    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: (...

Part and Inventory Search

Back
Top