report and drop down lists?

  • Thread starter Thread starter Geoff Cox
  • Start date Start date
G

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
 
answered in newsgroup microsoft.public.access, under Subject line "report
and drop down list?"
 
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)
 
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)
Click to expand...

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
 
Geoff said:
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?!
Click to expand...


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.
 
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.
Click to expand...

OK - will do.

Thanks

Geoff
 
Back
Top