query not giving results but with no error?

[Guest]

Hello, I have a query that gets information from a tbl_AttendanceData which
has 3 fields. (Field 1) Employees Name "Text" (Field 2) Attendance Code
"Text" (Field 3) Attendance Date "Date/Time".

In my Query the fields are as follows: (Field 1) Employees
Name/Table=tbl_AtendanceCode/Show/Criteria=[Enter Employees Name] (Field 2)
Attendance Code/ Table=tbl_AttendanceData/Show (Field 3) Attendance Year:
Year([Attendance Date])=[Choose a year]/
Sort=Ascending/Show/Criteria=Year(Now()) (Field 4) Attendance Date/
Table=tbl_AttendanceData.

I just wanted all the information for the year for that perticular employee.
I run the query and it gives me no information with no errors? I also wnated
to know what an expression would be if I only wanted perticular codes like
"Worked,Excused Tardy, Vacation ect" Instead of all the codes I have. What am
I doing wrong? Thanks!!!

 

[John W. Vinson]

Hello, I have a query that gets information from a tbl_AttendanceData which
has 3 fields. (Field 1) Employees Name "Text" (Field 2) Attendance Code
"Text" (Field 3) Attendance Date "Date/Time".

In my Query the fields are as follows: (Field 1) Employees
Name/Table=tbl_AtendanceCode/Show/Criteria=[Enter Employees Name] (Field 2)
Attendance Code/ Table=tbl_AttendanceData/Show (Field 3) Attendance Year:
Year([Attendance Date])=[Choose a year]/
Sort=Ascending/Show/Criteria=Year(Now()) (Field 4) Attendance Date/
Table=tbl_AttendanceData.

I just wanted all the information for the year for that perticular employee.
I run the query and it gives me no information with no errors? I also wnated
to know what an expression would be if I only wanted perticular codes like
"Worked,Excused Tardy, Vacation ect" Instead of all the codes I have. What am
I doing wrong? Thanks!!!

Please open the Query in SQL view and post the SQL text here (use the
View menu option in query design).

Do you have any Lookup Fields in your table - in particular, is the
employee name a Lookup field? If so, you are searching on the "looked
up" employee name rather than on the actual contents of the field,
probably a numeric ID.

John W. Vinson [MVP]