Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Another Syntax Issue

Posted on 2014-12-01
2
Medium Priority
?
109 Views
Last Modified: 2014-12-01
What is wrong with:

=DMax("[QTY_ORDERED]","tblInventory","[PART_NO] = '" & [Reports]![rptQRY_REORDER_PT]![txtPART_NO] & "'"  AND "[TRNX_TYPE] = '"ORD"'")
0
Comment
Question by:SteveL13
2 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 2000 total points
ID: 40474552
This last bit

"'"  AND "[TRNX_TYPE] = '"ORD"'")

Should be

"' AND [TRNX_TYPE] = 'ORD'")
0
 
LVL 34

Expert Comment

by:Mike Eghtebas
ID: 40474691
is [PART_NO] numeric? If so use:
=DMax("[QTY_ORDERED]","tblInventory","[PART_NO] = " & [Reports]![rptQRY_REORDER_PT]![txtPART_NO] & " AND  [TRNX_TYPE] = 'ORD'")

Open in new window


If it is text, then use as Philip has it, repeating all put together:
DMax("[QTY_ORDERED]","tblInventory","[PART_NO] = '" & [Reports]![rptQRY_REORDER_PT]![txtPART_NO] & "' AND  [TRNX_TYPE] = 'ORD'")

Open in new window

0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question