ACCESS FEED: Re: [MS_AccessPros] MAKE TABLE QUERY INVOLVING UNION QUERY

Selasa, 20 November 2012

Re: [MS_AccessPros] MAKE TABLE QUERY INVOLVING UNION QUERY

Candrope (name?)-

What are you trying to do here? Why are you using a Totals query? Using
First is totally unreliable - it fetches the "first" physical record that
meets the criteria. You could certainly build a Make Table query using
this as input, but not sure you'll get what you want.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: candrope <candrope@yahoo.com.br>
Reply-To: <MS_Access_Professionals@yahoogroups.com>
Date: Tuesday, November 20, 2012 9:03 PM
To: <MS_Access_Professionals@yahoogroups.com>
Subject: [MS_AccessPros] MAKE TABLE QUERY INVOLVING UNION QUERY

Hello everybody

I want to write an MS Access Make Table query in order to create a table
called tblMyNewTable.
This query will use records retrieved from another MS Access query
described below.
Is it possible? If so, how can I make it?
Thanks in advance.
----------------------------------------------------------
SELECT tblA.name, First(tblA.address) AS FirstAdd, First(tblA.city) AS
FirstCity
FROM tblA LEFT JOIN tblB ON tblA.NumInsc= tblB.NumInsc
GROUP BY tblA.name
HAVING tblA.name Is Not Null
UNION SELECT "Unknown", Null, Null
FROM tblA
ORDER BY tblA.name;

------------------------------------

Yahoo! Groups Links