report and drop down lists?

[Geoff Cox]

Hello,

A friend of mine has made an Access (2003) database for a video store,
three linked tables members, videos and bookings. The videos table
has various fields including two (rating and type) which have list
boxes to allow choice from a drop-down box.

A query was constructed from the videos table only and produces
expected results in tabular form. However using the wizard to make a
report of this query has a strange effect. The resulting report
shows all of the options for the two list box fields with the chosen
one blacked out.

How can he get the report to just show the chosen value? And not all
the possibilities with one blacked out?

Thanks

Geoff

 

[tina]

answered in newsgroup microsoft.public.access, under Subject line "report
and drop down list?"

 

[Geoff Cox]

answered in newsgroup microsoft.public.access, under Subject line "report
and drop down list?"

Yes, sorry about the cross posting.

Thanks Tina.

Cheers

Geoff

 

[Marshall Barton]

Cross posting is acceptable (but rarely useful). Cross
posting is when you put multiple newsgroups (separated by
commas) in one message's To: address

Unfortunately, you Multi posted, which is not. (posting the
same querstion multiple times to the same or different
newsgroups)

 

[Geoff Cox]

Cross posting is acceptable (but rarely useful). Cross
posting is when you put multiple newsgroups (separated by
commas) in one message's To: address

Unfortunately, you Multi posted, which is not. (posting the
same querstion multiple times to the same or different
newsgroups)

Marshall,

I know, but occasionally I post in one group and then think either I
ought to have posted in another one, or it might be worthwhile posting
in 2 groups ... and since it is not possible to remove an ealier
posting I'm stuck - am I not?!

Cheers,

Geoff

 

[Marshall Barton]

I know, but occasionally I post in one group and then think either I
ought to have posted in another one, or it might be worthwhile posting
in 2 groups ... and since it is not possible to remove an ealier
posting I'm stuck - am I not?!

Depends on the answer you get to your first post. If you
get a good answer, then the second post was detrimental to
the smooth operation of the newsgroups. If you don't get a
useful answer, then a second post to a more appropriate
newsgroup is in order. To avoid multi posting, give your
first post at least a day to see if a second post is needed.

 

[Geoff Cox]

Depends on the answer you get to your first post. If you
get a good answer, then the second post was detrimental to
the smooth operation of the newsgroups. If you don't get a
useful answer, then a second post to a more appropriate
newsgroup is in order. To avoid multi posting, give your
first post at least a day to see if a second post is needed.

OK - will do.

Thanks

Geoff