Placing Data In Datasheet

  • Thread starter Thread starter lucky33
  • Start date Start date
L

lucky33

I am working on a project and I need help getting the data into the
table

The data I am working with is a piece of equipment that cost different
prices for if you rent it by the day, week or month.

Tractor -- day $50, Week $250, Month $1000

I know that I can use an option group to get the price information
into the datasheet but that does not place the equipment name in the
datasheet.

My question is: How can I get both pieces of information in two
seperate columns on the datasheet? I need to have both the equipment
name and price to print a report later with the same information.

Any help is greatly appreciated.
 
Actually, since you are using a relational database, you DON'T need to put
all the information (redundantly) into a table for later reporting purposes.

It will be sufficient to put the rowID in your table and use a query to
"look up" the related info for inclusion in your report.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top