I have a Motorola Internal Modem. It was working perfectly in Windows 98. Since I upgraded to Windows XP, it does not detect my modem. When I query for a modem, it shows that no modem found. But if I skip automatic detection of modem and install the modem manually, it allows me to install the...
My database looks some this like this
Name Arr_Time Dep_Time date
X 10.00 20.00 1/1/2004
X 11.00 20.00 2/1/2004
and so on till the end for all employees
I want to display records in this format.
Name day 1 day 2 day 3...
How do I count Records based on a certain crieteria
The following are the fields in my Table
Emp Name Emp Code Dept Prstatus Date
Sam 1001 AC Present 9/22/2003
Sam 1001 AC Absent 9/23/2003
Mary 1002 BC Half Day 9/22/2003
Mary 1002 BC Present 9/23/2003
I want to count the no of days...
The foll is the data in my table.
Emp Name code Dept PrStatus Date
Raj 1 Accounts P 10/1/2003
Raj 1 Accounts A 10/2/2003
Suresh 2 Administration A 10/1/2003
I require the prStatus of each employee on the last day of the report.I want this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.