I have an .asp page that adds records to an Access .mdb
file. I have 3 fields in the .mdb that need to be
updated: field1, field2, field3. I manually enter field1
and field2 on the .asp page. I want field3 to be
field1*field2. The only time that I manually open
the .mdb using Access is for maintenance. How can I
accomplish this? Thanks in advance.

UPDATE myTable SET Field1 = ::FormField1::, Field2 = ::FormField2::, Field3
= ::FormField1:: + ::FormField2::
WHERE UniqueIdentifierColumn = SomeValue

This example assumes that Field1, Field2, and Field3 are numeric

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
http://www.takempis.com
Neither a follower nor a lender be.

"Daniel" <(E-Mail Removed)> wrote in message
news:003c01c36666$050be9b0$(E-Mail Removed)...
> I have an .asp page that adds records to an Access .mdb
> file. I have 3 fields in the .mdb that need to be
> updated: field1, field2, field3. I manually enter field1
> and field2 on the .asp page. I want field3 to be
> field1*field2. The only time that I manually open
> the .mdb using Access is for maintenance. How can I
> accomplish this? Thanks in advance.

Kevin,

Where do I put this, I have setup the database connection
and have setup the form, but I'm not sure where to put
this statement.

Daniel


>-----Original Message-----
>UPDATE myTable SET Field1 = ::FormField1::, Field2
= ::FormField2::, Field3
>= ::FormField1:: + ::FormField2::
>WHERE UniqueIdentifierColumn = SomeValue
>
>This example assumes that Field1, Field2, and Field3 are
numeric
>
>--
>HTH,
>
>Kevin Spencer
>Microsoft MVP
>..Net Developer
>http://www.takempis.com
>Neither a follower nor a lender be.
>
>"Daniel" <(E-Mail Removed)> wrote in message
>news:003c01c36666$050be9b0$(E-Mail Removed)...
>> I have an .asp page that adds records to an Access .mdb
>> file. I have 3 fields in the .mdb that need to be
>> updated: field1, field2, field3. I manually enter
field1
>> and field2 on the .asp page. I want field3 to be
>> field1*field2. The only time that I manually open
>> the .mdb using Access is for maintenance. How can I
>> accomplish this? Thanks in advance.
>
>
>.
>

Custom Query. Other than that, I can't tell you much. I never use the DRW.
Kathleen and others here can.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
http://www.takempis.com
Neither a follower nor a lender be.

"Daniel" <(E-Mail Removed)> wrote in message
news:091301c3666d$d154cd50$(E-Mail Removed)...
> Kevin,
>
> Where do I put this, I have setup the database connection
> and have setup the form, but I'm not sure where to put
> this statement.
>
> Daniel
>
>
> >-----Original Message-----
> >UPDATE myTable SET Field1 = ::FormField1::, Field2
> = ::FormField2::, Field3
> >= ::FormField1:: + ::FormField2::
> >WHERE UniqueIdentifierColumn = SomeValue
> >
> >This example assumes that Field1, Field2, and Field3 are
> numeric
> >
> >--
> >HTH,
> >
> >Kevin Spencer
> >Microsoft MVP
> >..Net Developer
> >http://www.takempis.com
> >Neither a follower nor a lender be.
> >
> >"Daniel" <(E-Mail Removed)> wrote in message
> >news:003c01c36666$050be9b0$(E-Mail Removed)...
> >> I have an .asp page that adds records to an Access .mdb
> >> file. I have 3 fields in the .mdb that need to be
> >> updated: field1, field2, field3. I manually enter
> field1
> >> and field2 on the .asp page. I want field3 to be
> >> field1*field2. The only time that I manually open
> >> the .mdb using Access is for maintenance. How can I
> >> accomplish this? Thanks in advance.
> >
> >
> >.
> >