Jocelyn
If you're familiar with SQL, use the SQL view in the Query Desgin
mode to view the code that you'll be more familiar with. The Query
Design window is just a GUI representation of the SQL code behind it
so you can just work in SQL
Brett
At 06:48 17/08/06, you wrote:
>I have this append query (Query1) in my access application. It seems
>select the data from a different query (query2) and append the records
>to the destination table(Table 1). I am very familiar with SQL
>database, but I am new to access.
>
>I am just wondering how this thing works. Does it mean if I try to
>execute query1, query1 will auto execute the underlying query2 first
>then append the records to the table 1?
>
>anything will be helpful.
>
>Thanks,
>Jocelyn
>
>
>
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>--
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.1.405 / Virus Database: 268.11.0/420 - Release Date: 16/08/06
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.11.0/420 - Release Date: 16/08/06
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
