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 now.
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.. ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
