Hi,
I m having one table Leave_Mstr...Le ave Mstr is having fields
Leave_Code Primary Key number
leave_Name text
Days number
I can insert data to the tbale successfully.Bu t during the updation time...The follwing Error s coming:
Query:
Dim SelQueryText...
hygeena
Last Activity: Mar 10 '07, 06:05 AM
Joined: Feb 24 '07
Location:
-
Want to display odd values from a table field
Hi,
I m havin one table history contains the field funcCode.FuncCo de stores all the event as in,out,lunch in,lunch out using diff code(10,20,30,0 )....I want ot to get the odd punch..For that I stored the In/Out frequecy (Count(FuncCode )) as one expression...No w this field Contains values as
IN/Out Frequency
1
2
4
3
5
2
2
4
4
I want... -
Thnks for Reply..But when I gave this query Its came like this
ShiftIn IN ShiftOut OUT
9:00AM 9:10 AM 6:00 PM 9;10 AM
same shift IN time is coming uder both IN and OUT....
But I got the Answer...The query S like below
SELECT DISTINCT h.UserID, h.UserName, h.EventDate, Shift_Mstr.Shif t_InTime, h.EventTime AS InTime, Shift_Mstr.Shif t_OutTime,... -
To display IN time and OUT time in seperate fields
Hi,
I m working with access.we hav a table history stores the employee IN/OUT time details...The IN/OUT time details s stored in the same field as event time....I want to get the IN time and OUT time in seperate columns..
like below
IN OUT
9:00AM 6:00 PM
the 9:00AM nd 6:00 PM s stored in the same field as event....
... -
Want to get unmatched query
Hi,
I m having one table history stores the Employee In Out Details using punch card.Now i want to get the absence persons report..we are assigning a function code for IN as "30".hw can I get the absence person s details...With my query I m getting the presence persons details.
Query:
SELECT DISTINCT History.UserID, History.UserNam e, History.Dept
FROM History
WHERE (((History.Func Code)<>"30"...
No activity results to display
Leave a comment: