Search results

update queries let u update EXISTING records- but thing is i actually need to create a new record on the "points" table and just change the "appended" field from no to yes in a already existing record

i need to append data to another table, but at the same time i need to modify the current table. Table "seats" has flight no., seat no. ... and appended what i want to do is append some of the selected fields to a table called points. but at the same time change the appended field from no to...

hmmm is it not possible to do this via forms alone? (i.e. setting a 'after update/change' event to update the other form. the two tables are linked in my ERD

i want to update a form called points automatically when i update the form seats. im trying to code it in VB but got no idea how to reference the external form for example i want it to be PointsAccumulated (of points table)= PointsSaved (in Seats table) any thoughts thnx sachin

the reason i want to calculate values like this is so that i want to update the next table automatically without me actually having to update it. for example theres a table called Accumulated points: it has fields: CustomerID Points Date Time so I want points (in AccPoints...

hi all, ive got a table called seats and it containes the following fields: Flgiht_No. Seat_No. Cost Points_Worth Cash Points_Paid i want to make the expression; Points_Paid=Points_worth*(1-Cash/Cost) such that as soon as u enter the fields cost, cast and points worth it updates the field...