Search:

Type: Posts; User: LukeB; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    27
    Views
    2,595

    Nevermind all that everyone, I didn't think I...

    Nevermind all that everyone, I didn't think I could set the Criteria in the expression that is using the IIf statement, but I put Like "Not Eligible" for the criteria of that expression and it...
  2. Replies
    27
    Views
    2,595

    Hey Hi Tech Coach and Andrew Lockton (and all...

    Hey Hi Tech Coach and Andrew Lockton (and all others),

    Forget about my last post (not necessary and not sure if I was making perfect sense either).

    I just added a Step 4a to my sample DB that...
  3. Replies
    27
    Views
    2,595

    I got it working perfectly now (well, not...

    I got it working perfectly now (well, not perfect, there is one problem, let me explain). Step 4 shows the results in what I like to call 'Expanded form' because it takes Step 3 and relinks it to...
  4. Replies
    27
    Views
    2,595

    Scratch that, I am pretty sure I have got it...

    Scratch that, I am pretty sure I have got it figured out now....thank you so much!!!!
  5. Replies
    27
    Views
    2,595

    I put it into production DB with same logic...

    I put it into production DB with same logic (except that there are more fields brought in the production version, don’t see why that would matter since it is based on the member name and date of...
  6. Replies
    27
    Views
    2,595

    So I have it working accurately now (please see...

    So I have it working accurately now (please see attached), but for presentation purposes\auditing purposes, I want it to show in an expanded form meaning I want all of the member’s Eligibility...
  7. Replies
    27
    Views
    2,595

    I don't understand what you are saying...

    I don't understand what you are saying (sorry)....Q_test is the query I am running the Mod_CoverStatus with your VBA code in it (please see attached).

    Q_test has nothing but the tables in it (I...
  8. Replies
    27
    Views
    2,595

    I was trying a nested IIf statement in...

    I was trying a nested IIf statement in qryClaimsEligible like this (but wasn't working):

    DATEFROM: IIf((([DATEFROM]>=[dbo_RVS_MEMB_HPHISTS].[OPFROMDT]) Or...
  9. Replies
    27
    Views
    2,595

    No it doesn't (actually Andrew's comes closer...

    No it doesn't (actually Andrew's comes closer than yours). Your query "Claims Recovery Paid_Summary_ProvName_Step_HiTechCoach" only returns 2 claim numbers out of the 6 I supplied in my sample DB.
    ...
  10. Replies
    27
    Views
    2,595

    HiTechCoach, Yes I am basing the Eligibility...

    HiTechCoach,

    Yes I am basing the Eligibility decision based on 1 claim number (so it would be nice to show the result set without having to show all of their Eligibility Histories, but does that...
  11. Replies
    27
    Views
    2,595

    Andrew (or anyone who can take a stab at it), ...

    Andrew (or anyone who can take a stab at it),

    I got through an Undefined function error and now validating the data (can't use same name for Module and function)...pls wait....

    So if you run...
  12. Replies
    27
    Views
    2,595

    So I just checked out that sample DB you uploaded...

    So I just checked out that sample DB you uploaded and that doesn't solve this problem....The Claims Recovery Paid_Summary_ProvName_Step1_HiTechCoach only pulls in the first DATEFROM (Date of Service)...
  13. Replies
    27
    Views
    2,595

    Not yet, it is really killing me that I have to...

    Not yet, it is really killing me that I have to first complete another tedious project right now (I will as soon as possible). Thank you so much!!
  14. Replies
    27
    Views
    2,595

    I will check out those links after I get a chance...

    I will check out those links after I get a chance to breathe from my other projects....did you happen to play around with my sample DB in post #5??

    Let me post my latest modifications (not sure if...
  15. Replies
    14
    Views
    1,371

    Yes

    Yes
  16. Replies
    14
    Views
    1,371

    Here you go.

    Here you go.
  17. Replies
    14
    Views
    1,371

    So attached is my spreadsheet I exported from...

    So attached is my spreadsheet I exported from Access sample DB I created with same logic and structure as real DB.

    I want to be able to handle it in Access, YES, so I guess this thread should...
  18. Replies
    27
    Views
    2,595

    The duplicates are what the issue is (duplicates...

    The duplicates are what the issue is (duplicates are caused by Member's Eligibility History Sequences).

    If you run the query in the sample DB, and check out the first 5 records (Name: One, Person ...
  19. Replies
    14
    Views
    1,371

    I will do that hopefully soon, then I can give...

    I will do that hopefully soon, then I can give that one to the Recovery person.

    But I really would like to get it to work in Access (my sample database is in post#4 above), just struggling on the...
  20. Replies
    14
    Views
    1,371

    Thank you in advance for all you do. Attached...

    Thank you in advance for all you do.

    Attached is a database sample.

    I think I would prefer to have the Eligibility column say Eligible if any of the DATEFROM (Date of Service) dates for a...
  21. Replies
    27
    Views
    2,595

    No need to worry about that (how interesting...

    No need to worry about that (how interesting about the whole d/m/yy thing....so foreign to me)

    I am going to create a small little simple database so you or anyone else can please help me with...
  22. Replies
    27
    Views
    2,595

    That is exactly the point. There shows 2...

    That is exactly the point.

    There shows 2 records as you can see in the screenshot (if I export results to spreadsheet, I would want to filter for only Not Eligibles so that we can RECOVER the...
  23. Replies
    14
    Views
    1,371

    Will do first thing tomorrow Steve (sorry got to...

    Will do first thing tomorrow Steve (sorry got to go to Dental appointment now) for sure (I was hoping someone would ask for a sample)...
  24. Replies
    14
    Views
    1,371

    Member Eligibility Formula Needed??

    I have a spreadsheet I exported from MS Access that shows a column called Eligibility (from my IIf statement in MS Access).

    Problem is that members have multiple eligibility periods in a History...
  25. Replies
    39
    Views
    10,161

    Thanks Andrew for all your help with this (it is...

    Thanks Andrew for all your help with this (it is really great),

    Can you please check out this post: "IIf statement for Member Eligibility" under the Access forum. I can't seem to come up with any...
Results 1 to 25 of 44
Page 1 of 2 1 2