How can add multiple rows with one query?

  • Thread starter Thread starter ikarpouc
  • Start date Start date
I

ikarpouc

Hallo everyone,

I have one table with customers and i am making a query to make a new
table with customers and credit cards doses. For example one customer
has 6 doses for 100$ every month. I want to create a new table with
the customer name, the date that he must pay each dose and the money
for that dose. the problem is that i have to enter in one field the
numbers of doses and in the new table i must get 6 new entries for
that one query. If i have that table i can make a new query and ask
for example what money i should get in november.

Any ideas how i can do this?

maybe i am making wrong desing from the begining. Please help!
thanks in advance
john
 
Hallo everyone,

I have one table with customers and i am making a query to make a new
table with customers and credit cards doses. For example one customer
has 6 doses for 100$ every month. I want to create a new table with
the customer name, the date that he must pay each dose and the money
for that dose. the problem is that i have to enter in one field the
numbers of doses and in the new table i must get 6 new entries for
that one query. If i have that table i can make a new query and ask
for example what money i should get in november.

Any ideas how i can do this?

maybe i am making wrong desing from the begining. Please help!
thanks in advance
john
Click to expand...

This isn't an ideal design by any means. You certainly should NOT
create a new table for each customer! You have a one (customer) to
many (doses) relationship which should involve only two tables - a
table of customers and a table of doses. You can create an Append
query to append six (or two, or ten) records to a table. I'm not
certain what a "credit card dose" is but I'd assume you could have a
six-row template table and base an append query on it, appending the
customerID and a date field.
 
Back
Top