FP Query result

[Tony M]

Can anyone assist?

Here's what I like to do:

Have the results on a query generate a table (No Problem)

Have the same result generate a separate table based on a
field within the table, and have that result appear once.
(Problem).

Currently, I can't isolate the field and all the entries
show, not the one specific to the query. And secondly, I
can't make it SELECT DISTINCT.

Thanks,
Tony

 

[Kathleen Anderson [MVP - FP]]

Like this? http://www.spiderwebwoman.com/queries/picklist.asp
Here's how: http://www.spiderwebwoman.com/tutorials/picklist.htm

 

[Tony M]

Yes and No.

I've gotten that far, but I would also like to see
another set of results derived from the initial request
while in the same page. For exmple if the select contact
as the query and it's looking at a table called
personnel, where contact is just one field and is
populated with xxx,yyy,zzz; and state another field
populated with aaa,aaa,aaa; representing the 3 records. I
would like to see:

Contact: (As one result)This is okay

Result:
xxx
yyy
zzz

StateAs a singular distinct result, assuming all above
are in the same state, which they are.) PROBLEM GETTING
THIS

Result
aaa

See, when I run the query contact, two things go wrong,
1) all the states are shown and 2)The query does not
isolate the Distinct state even after filtering the DB.

Thanks,
Tony