Results 1 to 2 of 2

Thread: Report Help

  1. #1
    Join Date
    Jul 2005
    Provided Answers: 1

    Unanswered: Report Help

    Hello Experts,
    I have this membership database i am working on which has an option of
    active/expired field in it i use that field to filter the active memebrs on
    my report, since i dont delete memebers. Let me explain what is happening

    On my report properties i have this command Record Source:
    SELECT Addresses.* FROM Addresses WHERE (((Addresses.Status)="Active")); for
    filter: ([Status]=1)

    it works fine but when i try to view the report under my member types dield
    i see 1,2,3 which is memberID instead of member types
    (premium,full,newsletter). I am not sure how to fix that problem.

    Any help would be nice..
    here is the link for my database

    Thanks alot

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    Where do you store your member types definitions? I only see one table being referenced in your record source.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts