How to write the query?

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.



Go Back   Webforumz.com > Main Forums > Program Your Website > Databases

Notices


Reply
 
LinkBack Thread Tools
  #1 (permalink)  
Old Oct 21st, 2005, 16:16
Junior Member
Join Date: Sep 2005
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
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.
Reply With Quote

Reply

Tags
write, query

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

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


All times are GMT. The time now is 07:25.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43