Re: Complicated Query

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 04/30/04 

Date: Fri, 30 Apr 2004 00:44:49 -0600

On Thu, 29 Apr 2004 05:36:03 -0700, "George Schneider"
<anonymous@discussions.microsoft.com> wrote:

>I going to create an access table to store them.

Create an Append query based on the SQL table, using the partnumber as
a criterion and parameters for the additional fields; e.g.

SELECT [Parts].[P.O. Number], [Parts].[Vendor], [Parts].[Part],
[Parts].[Description], [Parts].[Quantity Received], [Parts].[Price],
[Parts].[Received Date], [Forms]![MyForm]![txtShippingCost] AS
ShippingCost, [Forms]![MyForm]![txtPalletCharge] AS PalletCharge,
[Forms]![MyForm]![txtOther] AS OtherCharge
INTO youraccesstable
WHERE Part = [Forms]![MyForm]![txtPart]

The user would enter a part number into txtPart on the form named
MyForm, and the additional values into the txtShippingCost etc.
textboxes; then click a button which calls VBA code or a Macro to run
this Query.

                  John W. Vinson[MVP]
    Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public