Query and List Box

G

Gary McQuigg

I've been given an Access Database with a table.

It appears someone tried to do a calculated field within the table
(redundant data and didn't work).

My quick? solution was to:

query the table,

replace the field with a calculation, in the query, that does work

print a report.



Problem with various list boxes.

I get a report with the selection highlighted and the rest of the choices
from the list boxs.

Is there anyway to return only the selected items, from the list box, in the
query?



MyTable

Field Name = Text

Display Control = List Box

Row Source Type = Value List

Row Source = "Name1";"Name2"
 
L

Lord Kelvan

this post would be better put in the formscoding group

microsoft.public.access.formscoding

you are more likly to get a responce there.

Regards
Kelvan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List Boxes 1
Crosstab query 1
use field list from form to specify query fields 2
Query a table's particular column and return the field name. 3
Query in a subform field 1
Need description instead of code to show 3
Like operator and wildcards, compare fields 2
Using combo box in a form -- how to make drop-down work? 3

Top