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 - 06 May 2008 18:19 GMT
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
> can anyone help with this query example, write down a qeury statement
> as if following WHERE in an SQL statement to report this
[quoted text clipped - 10 lines]
>
> michael