Multiple Update

J

JA

I want to be able to check course attendance on-line. How
can I modify the query below to update more than one
record at a time?

SELECT * FROM FromTrainersTable WHERE (UserID
= '::UserID::' AND CourseCode = '::CourseCode::')
 
V

Vijay R Gangolli [MSFT]

Hi James,

The syntax is
UPDATE tablename SET TXTFieldName = 'TXTFieldValue', NumericFieldName =
NumericFieldValue
WHERE TXTFieldName = 'TXTFieldValue' AND NumericFieldName =
NumericFieldValue

Hence you can change your statement to,

UPDATE FromTrainersTable SET FieldToUpdate1 = Value1, FieldToUpdate2 =
Value2
WHERE (UserID = '::UserID::' AND CourseCode = '::CourseCode::')

Ensure that you test your query in Access or SQL with hardcoded values
before using in FP.

Regards,
Vijay

Disclaimer: This posting is provided "as is" with no warranties and confers
no rights

--------------------
| Content-Class: urn:content-classes:message
| From: "JA" <[email protected]>
| Sender: "JA" <[email protected]>
| Subject: Multiple Update
| Date: Thu, 4 Mar 2004 02:11:43 -0800
| I want to be able to check course attendance on-line. How
| can I modify the query below to update more than one
| record at a time?
|
| SELECT * FROM FromTrainersTable WHERE (UserID
| = '::UserID::' AND CourseCode = '::CourseCode::')
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select response from dropdown in field1, populate both field1 & fi 2
Crating User Form to Add Names 1
How to modify and updte specific styles for specific paragraphs across the document 0
Adding data to MS Access from csv file 0
Tracked changes by multiple people modified to one 0
create report grouped by various criteria 6
Embed the same Excel multiple times 0
Style Gallery View 3

Top