Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by RaphDawg

  1. RaphDawg

    Sub-Query SQL Question

    Awesome!!!!!!!! Just what I needed! A week and a half of frustration over. Thanks big for your patience and time. Great learning experience as well. Thanks!
  2. RaphDawg

    Sub-Query SQL Question

    KOOL!! Almost there. I see You got the 2 value to display for the records on 11/3 as Nichol & Bradley have a record for that day. Problem is on 11/4 only Nichol has a record but the CountOfServiceDate value displays 2. Nichol has 2 tblCareDayRecord’s on the 4th. Here is the deal; my daycare lady...
  3. RaphDawg

    Sub-Query SQL Question

    Hey Remou, I uploaded the tables and query to the listed URL. Please note the CountOfServiceDate query. Thanks for all your time!!http://www.lccleaning.com/Data/SubQuery.zip
  4. RaphDawg

    Sub-Query SQL Question

    Thanks Remou, CountOfServiceDate still returns a 1 for both Nichol & Bradley. I really just want to know that the Johnson family had 2 records on 03-Nov-08. Is this possible?
  5. RaphDawg

    Sub-Query SQL Question

    Get error that query doesn’t include the specified expression tblClients.FamilyID=2 AND tblClients.ClientType=3 as part of an aggregate function
  6. RaphDawg

    Sub-Query SQL Question

    Hey Remou, Thanks for the reply. Unfortunately that option won’t work for me. Count(ServiceDate) returns a 1 for both Nichol & Bradley. Each child can have 1 or more records per day (from the tblCareDayRecord table). My query just displays the child 1 time if they had at least 1 record for the...
  7. RaphDawg

    Sub-Query SQL Question

    Hi All, I have Sub-Query SQL question. I can’t figure out the correct Sub-Query SQL that will count the amount of ServiceDate records per day. I want the CountOfServiceDate column to displays a count value for the total amount of displayed ServiceDate’s for each record. So since Nichol & Bradley...
  8. RaphDawg

    Sum Unbound Textbox with WHERE Clause

    Thanks I got it!!! Added parenthesis at the end and it worked! =Sum(IIf([Taxable]=-1,Nz([ExtendedPrice],0),0))
  9. RaphDawg

    Sum Unbound Textbox with WHERE Clause

    Hey THANKS!!! Used this syntax: =Sum(IIf([Taxable]=-1,Nz([ExtendedPrice],0),0) I now am getting the following error: The expression you entered is missing a closing parenthesis, bracket (]), or vertical bar (I). Any thoughts??
  10. RaphDawg

    Sum Unbound Textbox with WHERE Clause

    I have a form with an Unbound text box called NonTaxPrice where I want to SUM records WHERE the Taxable column = -1. Right now I have an Unbound text box named ExtendedPrice that SUMS ALL records to give me a total price. It works as expected but my problem is I need to display a separate amount...
See more

Part and Inventory Search

Back
Top