querys

[whitep2]

can anyone help with this query example, write down a qeury statement
as if following WHERE in an SQL statement to report this

all students who do not live within 10km of birmingham univeristy or
less then 19years old

all students who are not called jones or smith or less then 1.75m tall

i repeat this isnt homework, just a past paper which i cant for the
life of me do, as i have exams on this core subject in a few weeks

thanks in advance

michael

 

[Jeff Boyce]

Have you tried opening a new query in design view, adding the tables and
fields, adding the selection criteria, then clicking on the view to see the
SQL statement?

Regards

Jeff Boyce
Microsoft Office/Access MVP