Query problem in Access 2010

[Lynn Cohen]

I have a query in Access 2010 that’s giving me trouble. Please bear with me; I’m not a programmer!

Background

• I work in a college. We use a database that holds course schedule records and the faculty who are assigned to teach them.
• The database I’m working with holds schedule records and assignments for 2015. There are separate databases for 2014, 2013, etc. – one database per year.
• Schedules and assignments for five academic divisions are stored in this database.
• Each academic division has their own query which returns a list of schedules and assignments for a year and semester. We call this the Alpha query. So we have:

Alpha query – P
Alpha query – D
Alpha query – J
Alpha query – N
Alpha query – T

Where P, D, J, N, and T identify the Dean who owns the division.

• The queries are identical , except for one field which identifies the Dean owns the division.

The Problem
In the 2015 database, the first four Alpha queries listed above work perfectly. Alpha query – T works for Fall semester, but not for Spring semester.

In the 2014 database, all Alpha queries, including Alpha query – T, work for both Spring and Fall semesters.

Parameters in the 2015 queries that work are:

Table Field name Parameter
SCHED Year [enter year]
SCHED Semester [enter semester]
FACULTY = x Field name is P or J or N or D.
FACULTY First name Is Not Null

Parameters in the 2015 query that doesn’t work are:

Table Field name Parameter
SCHED Year [enter year]
SCHED Semester [enter semester]


FACULTY T = x
FACULTY First name Is Not Null

I’ve tried and had no luck with:

1. Copying one of the 2015 Alpha querys that works and altering it so it returns records from the T division.
2. Importing one of the working queries from the 2014 version of the database. I tried this with Alpha query –T (which works in 2014) as well as Alpha query from other divisions.
3. In both (1) and (2), I’ve tried removing fields to see if I could get Alpha query – T to work with fewer fields, thinking it might be a specific field that’s giving the trouble. No such luck.

Any help is gratefully appreciated!

Lynn

[June7]

Already marked as solved. Is it?

[RuralGuy]

If it IS solved, do you care to share your solution with others that read these forums?