query not giving results but with no error?


G

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!!!
 
Ad

Advertisements

J

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top