Cathy,
Make sure you COPY your original report and name it another name then use the new report to do your trial and error. That way you always have your original report to fall back on. I have learned from experience (the hard way) to have that backup. Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of cfgrimes Sent: Monday, July 06, 2009 6:14 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Fw: Need Help Report P.S. Forgot to mention what I've tried already. I added vOrd# variable referencing column want from Categ table. Couldn't sort by using R prompt. Then ADDED second table to report, but couldn't figure out how to change report entry vord# to ord# (doesn't display in pull down list). Cathy ----- Original Message ----- From: cfgrimes <mailto:[email protected]> To: RBASE-L Mailing List <mailto:[email protected]> Sent: Monday, July 06, 2009 3:50 AM Subject: Need Help Report Sorry for the simple question. I've been happy with all my reports, tables, forms, etc., so it has been many years since I actually designed one....and have forgotton a whole lot. I have a main table with data entries. Have second Category table with 3 columns. One of the Category columns is also included in main data table, so can easily sort by that. Now, however, I would like to sort a report based on a Second Column in Category table without having to add that column to my main data table. Can't for the life of me remember how to do this - or even if I can. Is there some easy way? I have 7.6. Cathy Huntington Beach, Calif
