Date Parameter in a Union Query

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Date Parameter in a Union Query

Access VBA Discuss using VBA for Access programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

January 17th, 2008, 03:52 AM

bright_mulenga bright_mulenga is offline

Authorized User

Join Date: Nov 2005

Posts: 27

Thanks: 0

Thanked 0 Times in 0 Posts

Date Parameter in a Union Query

I have created a Union Query of Three Tables A,B,C. Now My problem is that I would like the Result to display only Records from the three tables falling in the date Criteria that I specify. The Statement I used looks like this "TABLE[stock_track] UNION ALL TABLE[tblktzstocks]UNION ALL Select * from tblExpenseDetails where companycode=can;
This Union displays all Records
Iam Stuck

Bmulenga

__________________
Bmulenga

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date Parameter in a Union Query	bright_mulenga	Access VBA	8	January 25th, 2008 08:13 AM
problem with the parameter date in a mdx query	olmouy	SQL Language	0	May 30th, 2007 05:32 AM
UNION QUERY Help	Corey	Access	1	October 27th, 2006 05:29 PM
UNION query.	rupen	Access	3	April 28th, 2006 02:49 AM
Error on Make-Table Query In Union Query	rylemer	Access	1	August 20th, 2003 07:42 PM