Greetings, I am using this crosstab query TRANSFORM Count(Q.Symptom) AS CountOfSymptom SELECT Q.CASEID FROM (SELECT tblListSymptomsOther.CaseID,argeedblu
Khalid- How are you calculating TotAmountReceived and TotExpenses? Those fields are not in your query. John Sent from my iPad On Feb 14, 2016, at 11:45,jlviescas
John, I'm still getting Zero balance rows. Khalid ... Khalid- Add this to your Where clause: And DSum("AmountReceived","[Clients Transaction]","TransactionIDkhalidtanweerburrah
Please Note: New Members will have their posts moderated for a period of time so we can be sure you are a real member and not a spammer. Sorry for the inconvenience.
Please Note: We do not allow job postings or recruiting at this site. Doing so will only get you banned.
Whether you are seeking help in database design, user interface, complex MS Access VBA code, MS SQL Server, we can help.
Our membership includes several MS Access MVPs and questions are answered quickly and accurately! Our Archive contains many sample databases, Utilities, Add-ins, code samples and more.
Share your knowledge and it will come back to you ten-fold!
For more accurate answers, please indicate which software version you are using when asking a question.
- Microsoft Access
- Mar 28, 2002
- This is a restricted group.
- Attachments are not permitted.
- Members can hide email address.
- Listed in Yahoo Groups directory.
- Membership requires approval.
- Messages from new members require approval.
- All members can post messages.