If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
query not giving results but with no error?
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!!! |
#2
|
|||
|
|||
query not giving results but with no error?
On Sun, 25 Feb 2007 08:51:03 -0800, oxicottin
wrote: 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] |
Thread Tools | |
Display Modes | |
|
|