--- In [email protected], "Richard" <[EMAIL PROTECTED]> wrote: > > The easiest way would probably be to use a full QUERY - not simply a > FILTER - as you can sort on your QUERY (as one of the instructions > you give it from the query design window) and you can also include > exactly what fields you want, in the exact order you want (not > necessarily the same order in which they are listed in the table). > It sounds like you want a Select Query for this exercise. Hope this > helps! > > Alienwebmaster > > > --- In [email protected], "Hassan" <[EMAIL PROTECTED]> > wrote: > > > > 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.. > > >
Thanks Alien here is how i fixed my problem. MemberType is text, but in the one sample row, I had the number 1 in that field. If 1 = Yearly Member, then I changed MemberType to Number, Long Integer. On the Lookup tab, make these settings: Display Control: Combo Box Row Source Type: Table/Query Row Source: MemberTypes Bound Column: 1 Column Count: 2 Column Heads: No Column Widths: 0";1" Now change the Record Source of My report to: SELECT Addresses.*, MemberTypes.MemberType AS MemberTypeDesc FROM MemberTypes INNER JOIN Addresses ON MemberTypes.MemberTypeID = Addresses.MemberType WHERE (((Addresses.Status)="Active")); And finally, change the Control Source of the Type text box to MemberTypeDesc. ------------------------ 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/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/
