Recent content by lyletti

Yes, thank you. They are already set to CaseID. Lila

Thank you for considering this problem. This database keeps records for a clinic. Fees are tracked by CaseID. A case can include more than one client, a client receiving a variety of services can have more than one case. My report LedgerByCaseID gives ledger information for a given case...

Thank you. Cut and pasted each one in and got errors on each for Dcount, just #Error in the control on the form for Ecount, and error message box that says: Syntax error (missing operator) in query expression 'AND Attendance = 'A" I see the single quote, A, double quote at the end of the line...

Thank you. That makes perfect sense of course. The question is HOW. Any guidance on this matter would be appreciated, and then I can experiment with it. As noted in my original post I tried =Ecount("*","q_SessionGrid","Attendance = 'A'") but it's not working. I'm grateful for your reply, and...

Greetings. I have a form based on a query q_SessionGrid, that shows inforamtion on therapy sessions and includes the following fields: SessionID Client Therapist Date Attendance (the values here can be A,C or N) FeeDue FeePaid I am using Allen Browne's Search2000 combo box method to filter...