Question
Thread display: Collapse - |
All Answers
Share your knowledge
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
SQL in MS Access
Is there anyone out there that knows Access query?
I am used to straight SQL query via a back-end connection like TOAD, so the restrictions of MS Access have me at a road block.
My SQL code is below and below that is what I would like it to do:
SQL code I am using in query
This is the body of my original query. It works fine, except I would like to customize it with the parameters in the bottom of this reply:
SELECT [Paste SYNETICS PNs Here].SyneticsPN, dbo_resource.description, dbo_resource.user1 AS Extended_Description, dbo_manufacturer.name_of AS MFG_Name, dbo_source_manuf_items.source_manuf_catalog AS MFG_Number
FROM ([Paste SYNETICS PNs Here] LEFT JOIN (dbo_resource LEFT JOIN dbo_source_manuf_items ON dbo_resource.resource_no=dbo_source_manuf_items.resource_no) ON [Paste SYNETICS PNs Here].SyneticsPN=dbo_resource.resource_no) LEFT JOIN dbo_manufacturer ON dbo_source_manuf_items.source_manuf=dbo_manufacturer.id;
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
What I want is when [Paste SYNETICS PNs Here].SyneticsPN is LIKE "%__AB____%" AND dbo_manufacturer.name_of AND/OR dbo_source_manuf_items.source_manuf_catalog IS BLANK (meaning the table has no data to display), then the fields MFG_Name & MFG_Number, in the query [Get SYNETICS PNs Here] (IF EITHER ARE BLANK), need to display the text "ANY"
Thanks!