Here Goes - New Access User with silly Q

[seftonbarn]

I have read as much as I can about using access and have decided it's time to have a play - so please forgive me if this is a silly question. Here goes.

I have a single table - it lists staff by name and staff number and shows 3 qualifications that they may or may not need (yes/no columns).

I have managed to produce queries/reports that show, for each of the 3 qualifications whcih personnel that require that qualification have not achieved it.

I now want to produce a query/report that lists any personnel that are outstanding any of their required qualifications and if so which qualification they are outstanding.

Any hints or tips would be very much appreciated.

 

[gemma-the-husky]

to start, make a new query, and put this table in it. drag the columns you want to see into the design grid. open the query, and you should see all your data - you can add new items in the botom row, or edit existing data.

return to the design grid. at the bottom there is a row called criteria. in the column you want to test put a value equal to some data you know is in there. now open the query, and you will only see certain rows.

return to the design grid. to get blanks, you need to put the criteria to be something like

0 if its a number
"" if its text
that will find blanks

however there is another form of blank different from either of these called a NULL (no data) which is different from a ""

so you may need to try isnull,

or even
isnull or "" - which tests for both null and ""

you can then use other comparison operators than = also

------------------------
bascially the whole of access is built on queries.

but if this is all new to you, you really need to read some books first

 

[seftonbarn]

Thanks. Happy with all that query stuff. However I do not want people that have completed all their required training to appear in the list. Am I missing something?

 

[gemma-the-husky]

you can set criteria in multiple columns - you can also test the value of a columns with respect to another column (this actually tests each row individually)

as I say, you really need to work through a strating access book, to get this basic understanding