Many thanks to each of you who took the time to read and respond, especially dhookom and Remou. I realize now how finicky the syntax parser is (quotes around arguments). And Remou's suggestion (AND link) to the old version of Northwind was the best advice I have gotten in weeks. (I was using...
Thanks PH. DSum was the first thing I tried. I used "=DSum(ExtAmt, tblOrderDetail)" (sans quotes) as an expression for a textbox in the Parent Form and all I could get was "#NAME?" in the textbox. So I came to the forum to see if there was another way. DSum should work but I have no clue why...
Thank you for this. If you would earn my thanks even more, please help with an additional item.
Per your suggestion I have eliminated the storage of a totaled field (thank you). Now, using your suggestion, I have created a query to be called by the parent form. However, the query opens a new...
Two tables: tblOrderDetail and tblOrder
Two forms: frmOrderDetails (subform) and frmOrders
Common data field of each table is “Order#” (key in tblOrders and non-key/required in tblOrderDetal)
In subform frmOrderDetails, I am able to calc tblOrderDetails.ExtAmt (currency) field using a CALC...
Apologies in advance for the remedial question.
How do I configure the Menu Bar on the results of a pivot table query to only permit printing of the results?
Currently the menu bar permits most of the tools and view options.
Thank you,
Bill
Scottsdale
All,
Finally got it. The only syntax that works is:
If (DLookup("MGID", "MG Names", "MGID=" & "[intMGID]")) Then
Seems so simple once I got it right. Thanks for all your attention and assistance.
-bill
fneily/PHV - Thanks for the prompt assistance!
Alas neither works. fneily, yours will not compile and PHV's yields: syntax error (missing operator) in query expression 'MGID='.
Sorry to be such a dough head but can you please take another look and suggest what is needed to make it work...
I have a similar situation and need help.
MGID is a Long Integer in MG Names table.
The code in my validation form is:
Dim intMGID As Variant
' Validate the MGID, if any
If DLookup("MGID", "MG Names", "[MGID] = Forms!intMGID") Then
Else
' Not good - tell them
MsgBox "The MG...
Thanks Leslie and PH for the lightning-quick replies! (I have been trying different approaches since midnight US/MST to no avail).
Leslie: yours works, many thanks. Can you recommend a book on SQL examples that I might reference?
PH: your suggestion, while more concise, still gives me the...
I created two queries against my ACTIVITY table:
“qryActivity0”
SELECT Activity.Zip, Activity.Cat, Activity.SubCat, Activity.Office, Activity.Date
FROM Activity
ORDER BY Activity.Zip;
“qryActivity1”
SELECT qryActivity0.Zip, Count(*) AS CountOfZips
FROM qryActivity0
WHERE (((qryActivity0.Date)...
Hi jpiscit1
I tried that already (Order By CountOfZip) and Access grumbles at me, asking for the parameter value of CountOfZip.
I don't know how to get around that one.
Thanks for your prompt post.
-bill
I have an ACTIVITY table with Date, Zip, Category (from lookup table CAT) and Sub-Category (from lookup table SUBCAT).
I have successfully created a Pivot-Table query that shows activity counts by Zip for each Category and Sub-Category within a date range.
The SQL for the above is:
SELECT...
Hi PHV,
Please disregard previous post. It works perfectly now that I added ALL to each UNION. MANY thanks for your excellent advice AND your prompt posts.
Most Gratefully,
-b
Thanks PH! Yes, it does indeed help. But I might have missed something as the count results are ONE for each Flavor, when in fact there are thousands. Any suggestions?
Thanks,
-bill
Thanks PHV. Alas I am still a novice with no mentor to query save the useless books I purchased and of course, this forum. Might I prevail upon your expertise to kindly provide a simple example of how I might accomplish this?
Many Thanks, -b
Excellent thread and superb advice! I have a similar and slightly more complicated opportunity. Rather than give my complete scenario, I will use the "coffee" example.
Assume that each BEVERAGE record had room for 4 coffee orders instead of 1. Each of the 4 flavor fields in BEVERAGE...
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.