ASP to Access

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

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.
 
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
 
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.
 
Back
Top