query criteria - function of "And"

[Guest]

Hello there

i am using Access 2003

I made a table with three fields: StudentNumber, Major and Marks.

The StundentNumber is a primary key.

Then, I used the query and inserted the three fields of the table in the
fields row.

I wanted to add a criteria to the "Marks" field so it displays the marks (75
and 80) only.

To do so, I typed the following in the criteria row, in the cell under the
"Mark" field:
"75" And "23".

However, it didn't work. When i ran the query, nothing showed in the table
at all

Could you please tell me what was wrong?

Can i do similar steps to show the majors like (math, science)?

I want to do this by entering the information in a single cell

Thank you

 

[Jeff Boyce]

Provided your table has only one "mark" per record, you told Access to find
a row/record that had two marks, "75" and "23". If your table holds more
than one "mark" per record, you'll need to spend some time normalizing the
structure, especially if you want to be able to use the features and
functions Access offers.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/