how do i add data to a query

D

dor

hi all heeelp

i am trying to store hotel guests data so i have 2 tables
the first one is guest details (name passport etc..) and the second
one is visiting date in one to many relation so one guest can have few
visiting dates

i made a query for the guests that paied for the next day and i want
for that guests to add another day to the visit date how can i do that
with code
my problem is to run through the record of the query and to add to them
another date field
many tnx
 

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

using selection from calendar control as the criteria for a query 1
Setting field value if a value exists in another table 3
how do I specify a date range = date(2010,4,1 thru 30) 1
Adding data to MS Access from csv file 0
Counting consecutive dates 5
Help with counting distinct records! 3
Imported Access report, need to save as separate docs 1
Copy Data from one Subform to another Subform 2

Top