hi,

i have a table that consists of certain newspaper and the days they are required, and a linked table with the people who want them, but i need to some how link the costs of the papers, so i can create bills for the customer, how can i go about this, plz.

thanks

Build a separate newspapers table with the price of each newspaper as a field.

Link that to the newspaper field in your transaction table.

Pull the price of the papers through in a query including both(or more) tables in a query.

Base your report on this query.

thanks alot man

some of the prices of the papers are the same, it wont let me create duplicate field names.

I don't mean to be rude but because you are way of track I think you need to do some reading up on basic normalisation principles.

The price should not be the field name, you should have a NewsPaper field and a Price field with a record for each NewsPaper type.

You can then pull the price of the newspaper when you require it by querying the table.

Also take a look as the Orders example installed with access, that will put you on right track.