This is a discussion on "How to write the query?" within the Databases section. This forum, and the thread "How to write the query? are both part of the Program Your Website category.
|
|
|
|
|
![]() |
||
How to write the query?
|
||
| Notices |
![]() |
|
|
LinkBack | Thread Tools |
|
|||
|
How to write the query?
Hi:
In MS Access I have a table, 2 queries: One of the queries have input: [Enter value:] Second of the queries use the previous query to run. Query: Retrieve Invoices SELECT Input.* FROM [Input] WHERE (((Input.[Date Received])>=[Start Date:] And (Input.[Date Received])<[End Date]; Query: Not Received Invoices SELECT DISTINCT [Vendor List].[Vendor Name], [Vendor List].[Vendor Code], [Vendor List].[Billing Code], "Accrual" AS [Invoice Date] FROM [Vendor List] LEFT JOIN [Retrieve Invoices] ON [Vendor List].[Vendor Name] = [Retrieve Invoices].[Vendor Name - Long] WHERE ((([Vendor List].[Billing Code])="BC 1" Or ([Vendor List].[Billing Code])="BC 2") AND (([Vendor List].Status)="Active") AND (([Retrieve Invoices].[Vendor Name - Long]) Is Null)); So, How can I combine 2 queries into one query using the SQL View. |
|
|
![]() |
| Tags |
| write, query |
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| [SOLVED] do you write | quicker | Hosting & Domains | 8 | Dec 12th, 2007 05:13 |
| MySQL query query | dangergeek | Databases | 3 | Apr 12th, 2007 12:45 |
| Do you write like a girl? | snow | Webforumz Cafe | 17 | Jan 4th, 2007 22:14 |
| better way to write this? | jimz | PHP Forum | 4 | May 9th, 2006 11:21 |