If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Update Query
I am trying to create an update query, but i don't know
what expressions to use, if any. I need to create a form to update products, prices, quantity, and customers. Please help if you can. Thank you, Liz |
#2
|
|||
|
|||
Access Update Query
UPDATE TableName SET FieldName = Whatever;
is the syntax, but if the form is bound to the underlying table, you do not need to use a query. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access "Liz" wrote in message ... I am trying to create an update query, but i don't know what expressions to use, if any. I need to create a form to update products, prices, quantity, and customers. Please help if you can. Thank you, Liz |
#3
|
|||
|
|||
Access Update Query
Do I have to use code to do this? Can I just do it in an access database query by choosing Update Query for Query Type and typing something in this space? If I am supposed to type something in this space, what do I type to update the fields?
|
#4
|
|||
|
|||
Access Update Query
On Mon, 14 Jun 2004 17:13:01 -0700, Liz
wrote: Do I have to use code to do this? Can I just do it in an access database query by choosing Update Query for Query Type and typing something in this space? If I am supposed to type something in this space, what do I type to update the fields? What is "this"? You can create an Update query (to edit existing records) or an Append query (to create new records in a table). What you type into the Update To field depends on... well, what you want to update to; since I have no clue what that might be I can make no suggestions! To run the query, simply click the ! icon in query design view; or save the query and doubleclick the query name in the query window. Or you can run the query from code or from a macro. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
#5
|
|||
|
|||
Access Update Query
Okay, say I have a database that has test and assignment scores, and attendance. These fields need to be updated every time a score is added to the database or a day is added for when someone attended class. I am specifically asked to create a form to update tests, assignments, and attendance in this database.
The database has already been made and I am having a problem as to what I should type in the Update Query Field (if it is an expression). Please be patient as I haven't used Access too much in the past and I don't understand the 'Lingo' associated with it. Thank you kindly, Liz |
#6
|
|||
|
|||
Access Update Query
On Tue, 15 Jun 2004 14:13:01 -0700, Liz
wrote: Okay, say I have a database that has test and assignment scores, and attendance. These fields need to be updated every time a score is added to the database or a day is added for when someone attended class. I am specifically asked to create a form to update tests, assignments, and attendance in this database. What is the structure of your Table, or tables? Remember, you can see your database; we cannot. If you're storing derived data - such as the number of days present - then consider NOT doing so. Anything that can be calculated from data already in the table should be calculated on the fly in a Query rather than stored in the table. The database has already been made and I am having a problem as to what I should type in the Update Query Field (if it is an expression). What you have not told us is what field you want to update, and what you want to update it to, nor where that information is coming from. Again - *you* know your problem. We do not. Please be patient as I haven't used Access too much in the past and I don't understand the 'Lingo' associated with it. If you'll please be as patient with me asking for clarifications, I'll certainly try! John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|