Loading ...
Sorry, an error occurred while loading the content.
  • Back
  • About Group

  • Join Group
82 messages added in the last 7 days
New MessagesSee All
  • Modify query field names

    Greetings, I am using this crosstab query TRANSFORM Count(Q.Symptom) AS CountOfSymptom SELECT Q.CASEID FROM (SELECT tblListSymptomsOther.CaseID,

    argeedblu 1 hour ago
  • Re: Report to not show Zero balances

    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 4 hours ago
  • Re: Report to not show Zero balances

    John, I'm still getting Zero balance rows. Khalid ... Khalid- Add this to your Where clause: And DSum("AmountReceived","[Clients Transaction]","TransactionID

    khalidtanweerburrah 6 hours ago
Fetching Sponsored Content...

Group Description

SPAM-FREE advice and knowledge pool for beginners through advanced users of Microsoft Access and databases in general.
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.

Group Information

  • 5013
  • Microsoft Access
  • Mar 28, 2002
  • English

Group Settings

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

Message History