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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.