Search results

Yes Pat that was it. Your suggestion of the update query made me go back and look at their data. This data that I have was given to me by the client and I made the mistake of "assuming" they knew what they were doing when they set up data....LOL Thank you so much for your help

Got it - it was because EKGdates.DOS was hardset with slashes and the other table is imported from CSV and no slashes were there until it was in table with Input mask set. Redid the EKGdates data and all records pull with original query. Thanks to both of you for your help. You made me think...

Thank you for responding. There must be something in the tables that is not right so I'm going to go back and review all data. The same results came from this 2nd query you gave me and I moved the 1 record that it pulls to the bottom of the table (it was the 1st record) just to make sure and...

Let me explain it another - probably simpler way, just in case it makes a difference. There are about 25 doctors each assigned a numeric code for their billing system. Dr X=1 Dr Y=2 Dr Z=3 etc. The EKGdates table has every date (up to today) entered 1 time and the code for the doctor that did...

Thanks for help. This gave me the same results as before. I have a feeling that I'm just not doing this right at all. Let me explain what I need. 2 tables EKGdates which has only DOS (date of service) and Reading_Dr (numeric value based upon the Dr that read EKG's that day). DOS is unique...

I have a macro to import, and was wondering if there's any way to make it automatically "Next" through all options after selecting the file to import until the user gets to the "New Table or Existing Table" screen? I've tried adding SendKeys commands to the macro, but that doesn't work. Thanks

Ok, if this question was answered previously, I can't find it. After many days of beating my head against a wall it seems (and realizing that I am TRULY a blonde.. :eek: ), I finally was able to get my query to do what I wanted - with one exception....it stops after it matches the first record...

Actually, I don't have to update the table necessarily if there's a code snippet I can right for the Reading_Dr field on the report to make it pull that data at the time the report is generated. Thanks

Yes, DOS from Small table to DOS on large table.

Yes, I set DOS as primary key in the small table and set up relationship, but at this point I probably did that wrong too - I've tried so many things I've gotten myself confused...LOL

Please forgive me, I'm just in a serious blonde moment it seems. I'm having a major block on something I'm sure is very simple. I'm also new to SQL language so that's really giving me a run for my money. I have 2 tables - 1 is only 2 columns DOS and Reading_Dr and is updated each month with a...