duplicate 20 records

[Alan Oats]

I want to duplicate 20 records with the same date. except the date field
which should not be duplicated but rather be incremented by one day. The
process could be called by a button on the main form

It is a record of the occupancies in a homeless center. It is the simplest
method that I can think of to create a record of occupied or unoccupied
beds. I need to be able to control the order of the records on the form so
that the beds can retain their room order and be easy to interpret by the
worker who books in the guests.

Alan

[Bob Quintal]

"Alan Oats" <ch*****@gmail.com> wrote in
news:43**********@news.bluewin.ch:

I want to duplicate 20 records with the same date. except the
date field which should not be duplicated but rather be
incremented by one day. The process could be called by a
button on the main form

It is a record of the occupancies in a homeless center. It is
the simplest method that I can think of to create a record of
occupied or unoccupied beds. I need to be able to control the
order of the records on the form so that the beds can retain
their room order and be easy to interpret by the worker who
books in the guests.

Alan

Your design is flawed. Create a static table containing room+bed
information and a separate table containing the guestID , the
date, and the bedID number. You add a record when assigning a
bed to a person.

Set the query to show all the records from the static table, and
the rows from the second table which have been created. Those
which have not been assigned will appear blank.

--
Bob Quintal

PA is y I've altered my email address.

[Alan Oats]

Bob Quintal wrote:

"Alan Oats" <ch*****@gmail.com> wrote in
news:43**********@news.bluewin.ch:

I want to duplicate 20 records with the same date. except the
date field which should not be duplicated but rather be
incremented by one day. The process could be called by a
button on the main form

It is a record of the occupancies in a homeless center. It is
the simplest method that I can think of to create a record of
occupied or unoccupied beds. I need to be able to control the
order of the records on the form so that the beds can retain
their room order and be easy to interpret by the worker who
books in the guests.

Alan

Your design is flawed. Create a static table containing room+bed
information and a separate table containing the guestID , the
date, and the bedID number. You add a record when assigning a
bed to a person.

Set the query to show all the records from the static table, and
the rows from the second table which have been created. Those
which have not been assigned will appear blank.

Thanks for the tip although I only had 15 minutes at work to test your
suggestion it seems to me to be a much better starting point for my
database. I have a couple of questions but I will have to wait untill I
get chance to use access again.

Gratefully Yours

Alan

[Bob Quintal]

Alan Oats <ch*****@gmail.com> wrote in
news:43**********************@news.sunrise.ch:

Bob Quintal wrote:

"Alan Oats" <ch*****@gmail.com> wrote in
news:43**********@news.bluewin.ch:

I want to duplicate 20 records with the same date. except
the date field which should not be duplicated but rather be
incremented by one day. The process could be called by a
button on the main form

It is a record of the occupancies in a homeless center. It
is the simplest method that I can think of to create a record
of occupied or unoccupied beds. I need to be able to control
the order of the records on the form so that the beds can
retain their room order and be easy to interpret by the
worker who books in the guests.

Alan

Your design is flawed. Create a static table containing
room+bed information and a separate table containing the
guestID , the date, and the bedID number. You add a record
when assigning a bed to a person.

Set the query to show all the records from the static table,
and the rows from the second table which have been created.
Those which have not been assigned will appear blank.

Thanks for the tip although I only had 15 minutes at work to
test your suggestion it seems to me to be a much better
starting point for my database. I have a couple of questions
but I will have to wait untill I get chance to use access
again.

Gratefully Yours

Alan

Whenever you are ready, we'll be here.
--
Bob Quintal

PA is y I've altered my email address.