Recent content by emmorel

  1. E

    Query criteria using table1 range to extract table2 data

    theDBguy, I tried your last code and got a different error. "Syntax Error in Join Operation". Thanks for your all your efforts. Colin (isladogs), I tried your revised SQL code and it worked. I am getting descriptions from the RVU19_Import table for the codes within the ranges specified in...
  2. E

    Query criteria using table1 range to extract table2 data

    Here's a print screen!
  3. E

    Query criteria using table1 range to extract table2 data

    theDBguy, Thanks. I pasted your Vba code in a new query and it gave me the following error message I haven't been able to fix. "Between operator without And in query expression 'RVU10_Import.CODE Between [tbl_Code Range Table].[From Code]
  4. E

    Query criteria using table1 range to extract table2 data

    PBaldy, Thanks for your reply; this is the outcome I'm looking for based on the first range that's in Table1. HCPCS DESCRIPTION10021Doc lack perm+cont+parox fib1002FAssess anginal symptom/level10030Guide cathet fluid drainage10035Perq dev soft tiss 1st imag10036Perq dev soft tiss add...
  5. E

    Query criteria using table1 range to extract table2 data

    Hi, hoping someone can help. I'm trying to create a list of codes with their description using two Access tables. Table 1 contains various code ranges From: 10021 To: 10646 and From: 20240 To:20550 and so forth. Table 2 contains all the codes from 10000 to 99999 with their description. I want...
  6. E

    What is the syntax for % of Grand Total formula in an Access Grouped Report

    I have the following Access report: Status Expected Actual % of Expected % of Total Expected Completed 2,552,068 531,061 21.06% (531,061/2787,154) syntax? In Progress 235,086 44,205 18.80% (Status footer) Grand Total 2,787,154 575,266 (Report footer) The formula for % expected =...
  7. E

    How do I make Read only fields on Access Table?

    I need to make some fields Read Only by all Users in a Table while other fields can be updated for the same record. Is there a way to do this in the table properties without having to create a form? I'd appreciate any information you can anyone can provide. Thanks! emmorel
  8. E

    Hello from Rhode Island

    I've been an Access User for over 10 years; primarily use Access to import and export clinical data, sort and summarize data in reports. However for the past 5 years I've been developing databases for various purposes: collection of research data, creating surveys & datasheets, generating...
See more
Back
Top Bottom