item list on report

[Annabelle]

I have a report on which I need a list of items to print. The report is similar to a window sticker on a car and gives details about a unit in our inventory. The list I need to print is a list of standard features for the unit. The list comes from a table. Of course, there are multiple standard features for each unit in the table.

My problem is when I add the Standard Feature field to the report only one of the features appears. How do I get multiple features to pull from the table.

I assume the features it is starting to pull (by pulling the one) are the features for a particular unit but really cannot tell until I can get all features to appear.

Please help. Your assistance will be appreciated.

 

[mark curtis]

I may have this wrong but here goes?

It looks like you have a unit name and a standard feature for that unit therefore a one to one relationship. It may be better to have a table of standard features and a table of units.

Anyway create a query which returns all the standard features for the unit and you can either group on unit and put the standard features in the detail or you could just plonk the lot in and on the unit field hide repeats.

If this makes no sense zip up the db and it will be looked at.

 

[Annabelle]

Sometimes I am not too good at explaining. I would be glad however to attach the db but it is too big.

Any suggestions.

 

[mark curtis]

Annabelle,

Can you attach a screen shot of the query grid?

or table structure?

 

[Annabelle]

I would be more than happy to send a screen shot if this was possible. But I cannot seem to get my computer to do a screen shot. I don't know if its me or the fact this is such a new computer I cannot figure it out. Can you tell me how I can accomplish this task?

I have a Pentium 4 Gateway system with Windows XP Professional operating.

I've not sent screen shots of pages from Access before, so there is a large possibility I simply don't know how.

Again, thanks for trying to help me. Maybe we will succeed soon.

 

[mark curtis]

We must succeed!!!

Ok then 1st open the query that creates the report. 2nd press the Print Scrn button next to F12. 3rd open word or paint and then paste in. 4th zip the file and attach it.


If you compact the database and then zip it how large is it?

It would be easier to work with the database if you could strip out any confidential data. I'll leave it to you?

 

[Annabelle]

Thanks again.

I did screen shots of the window sticker design, the tables in the database, the query design, and tblModelStandardFeatures design and attached it to the reply.

It was too big to send, even after zipping them into one file.

My database size after compacting and zipping is 254 KB. That does not sound too large. What do you think?

 

[mark curtis]

Please send the database to mark_curtis_69@yahoo.com