(newbi help) Quary sort

  • Thread starter Thread starter EC300
  • Start date Start date
E

EC300

Hello,

trying to make a querie to sort a table into a few list
boxes.

Table Emp_Info

1 auto# (auto#)
2 Name (text)
3 HCA (yes/no)
4 RN (yes/no)
5 DR (yes/no)
6 Fellow (yes/no)
7-18 address, phone ect.


Quarie Emp_Info

would like it to look like

1 Names with HCA in Table Emp_Info = yes in a list box
2 Names with RN in Table Emp_Info = yes in a list box
3 Names with DR in Table Emp_Info = yes in a list box
4 Names with Fellow in Table Emp_Info = yes in a list box


I came up with this but it displays no data

"select [Emp_info]![Name] were [Emp_info]![HCA] = true"

it just displays an empty list box.
I also have sort set to acending if that would make a
differance some how.

thx
EC300
 
Hello, again,
well I was wrong. should have looked closer at the data
that was pulled. It pulled the hole list not just the ones
were HCA = yes do im still at a loss.

Thx
 
Are you wanting one query that shows you all of the names
with at least one of these boxes checked, along with the
boxes? Also, are you doing this with SQL, or in the design
view? In SQL, the above query I described would look
something like--


SELECT Name, HCA, RN, DR, Fellow
FROM (table)
WHERE (HCA=Yes OR RN=Yes or DR=Yes OR Fellow=Yes)
ORDER by Name asc

Hope this helps. Feel free to e-mail me for additional
help, or if this isn't quite what you want (just remove
the _no_spam part of my e-mail address).


-Dan.
 
Back
Top