Creating Entries

G

Guest

I want to create a data base for a Hotel. I want to create a form with
fields such as DATE, NAME, ROOM NUMBER, RCID (RESERVATION CHECK IN DATE),
RCOD RESERVATION CHECK OUT DATE, amongst other information. I would make the
form look something like this:

Date: July 09, 2005

Name: Sally Jones Room Number: 11

RCID: July 11, 2005
RCOD: July 14,2005


I would have a button to the bottom of the form that says "Update". And I
would want the form to automatically create these records in the table:

NAME ROOM DATE
Sally Jones 11 July 11,2005
Sally Jones 11 July 12,2005
Sally Jones 11 July 13,2005
Sally Jones 11 July 14,2005

Can Access do that?
 
S

Steve Schapel

Mara-Khadija,

Just a hint for the future... If you really feel you want your post to
appear in more than one newsgroup (in practice, this is seldom
necessary), it is preferable to cross-post (i.e. address the same post
simultaneously to both groups), rather than multi-post (i.e. send a
separate copy of the post to each group). Thanks.
 

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

Creating a que 5
Using one form to create mulitple records 1
if statement 16
Min if Function? 4
Request for help with EXCEL 2003 2
Sickness dates 4
Date Ranges 1
#error in text box 3

Top