Inner Join Conundrum

[Aaron]

Hello,

I hope sombody would be kind enough to help me with this problem

I have 3 tables,

-Customer Details
-Customer Invoices
-Invoice Items

Customer details has a 1 to many relationship with Customer Invoices.
and Customer Invoices has a 1 to many relationship with Invoice Items.

The main purpose of this is for a user to generate invoices.

I have obtained an example of a code that performs a mail merge to
MSWORD from Access and it works fine, I need to change the SQL
statement within the code to select a specifc set of records as you
can see I will need the INNER JOIN FUNCTION can anyone point me to a
knowledgebase article or something.

Thanks

Aaron

[Jack MacDonald]

The easiest way to generate an SQL statement is Access is to create a
new query. Add the appropriate tables and join them using the
appropriate keyfields. Display the desired fields by dragging them to
the query grid. This is standard Access fare.

Next, display the resulting SQL statement that is behind the query:
View > SQL View. You can copy-and-paste the SQL statement into your
example code.

On 4 Aug 2004 19:02:49 -0700, aa***@rapid-motion.co.uk (Aaron) wrote:

Hello,

I hope sombody would be kind enough to help me with this problem

I have 3 tables,

-Customer Details
-Customer Invoices
-Invoice Items

Customer details has a 1 to many relationship with Customer Invoices.
and Customer Invoices has a 1 to many relationship with Invoice Items.

The main purpose of this is for a user to generate invoices.

I have obtained an example of a code that performs a mail merge to
MSWORD from Access and it works fine, I need to change the SQL
statement within the code to select a specifc set of records as you
can see I will need the INNER JOIN FUNCTION can anyone point me to a
knowledgebase article or something.

Thanks

Aaron

**********************
ja**************@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security