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.. > ------------------------ 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/
