I would guess that you defined member types as a lookup, but the data type is a number. If the lookup is to another table, simply include that table in your Record Source query and display the name, not the number. If your lookup is a Value List, then you can use the Choose function:
=Choose([MemberType], "Premium", "Full", "Newsletter") Make sure that you name the text box on your report that has the above as its Control Source something other than "MemberType". John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hassan Sent: Sunday, November 06, 2005 12:56 PM To: ms_access@yahoogroups.com Subject: [ms_access] 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 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 ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> 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/
