Jay,
What is the link between the table the report is based on and the "try2" table - is it just the dutyname field? Does each date field in the report file have a unique dutyname associated with it? Steve Steve Vellella Office: 520-498-2256 Cell: 520-250-6498 From: [email protected] [mailto:[email protected]] On Behalf Of Jay Ward Sent: Saturday, February 13, 2010 3:59 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Report Issue I'll just type them in Karen since, as Jan pointed out, I can't send them the easy way. chair fulln in try2 where dutyname contains 'chair' essay fulln in try2 where dutyname contains 'essay' discuss fulln in try 2 where dutyname contains 'discuss' In each case fulln is the field with the name of the member. The three options represent Meeting Chairman, Discussion Leader and Essayist. I have them set calculating on the break footer which is where the three fields plus the date field is printed. I have stripped down the report to nothing but a page header for column descriptions and the break footer. All three of the variables are "accepted" by the report designer as valid. Jay From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Saturday, February 13, 2010 3:52 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Report Issue Maybe you should paste your variable definitions here? So you have a break on the date column, you have a break footer where you have the date and "3 variables", all the breaks show the same information for the 3 variables, right? Post what your variables are and maybe that'll help us understand... Karen Yes, I am. It's an order by the date. The variables are being filled randomly as the three names come through in no set order.
