sqlbraindead
Last Activity: Mar 20 '08, 08:28 AM
Joined: Dec 31 '07
Location:
-
They won't be on the Work Hour Table because they will automatically recorded as 7 hrs if it is not holiday.... -
Any idea of how to put the codings?
(CASE WHEN PRSRG < 'B' THEN (CASE WHEN APINC = 'HOLIDAY' THEN APHRS ELSE 7 END)
ELSE APHRS END) END) AS Workhrs
This is part of the logic that I use in view to get the daily working hours. However, can I use a looping to get round the problem of the incomplete database for multiple day grouping. Or another attempt that I failed is to create a new tempoary...Leave a comment:
-
2 is the id and A is the given grade hence 19 = 8 + 4 + 7. 8 is the holiday hour on 11/01/2008. 4 is the holiday hour on 13/01/2008 and the remaining day 12/01/2008. It doesn't get recorded because he is grade A, so 7 hours are given.
for id3, 21 = 7 * 3 since it is not recorded at all in the Work Hour Table and he is grade B, so 7 hours is given for each day. For 3 days, it is 21....Leave a comment:
-
Grouping with two Criterion and time point structure
The problem is if I want to group my database on the time basis, how can reconcile the grouping of two different criteria structure?
This is an example.
Two table I want to use these to get a table with each staff and calculate their total working hours.
Master Table (2 Columns)
StaffID Grade
1 A
2 A
3 B
4 C
5 D
6 E
Work Hour Table (5 Columns)... -
Thanks a lot! deepuv! This is really helpful!...Leave a comment:
-
Thanks a lot deepuv, however, there is still some issues on my database, since one of the table is like this:
TableName: Animal
ID Name
A Cat
B Dog
TableName: Sales
ID Jan Feb Mar Apr May Jun ....
A 1 2 1 4 4 3 ....
B 2 4 3 2 3 1 .......Leave a comment:
-
Find Columns
I want to do a search on the column, if the month is Jan in the specified date, then it will return the data in the Jan column, when the specified month is Feb, then it will return the data in the Feb column and so forth for the 12 months of the year. How to code the TSQL for this problem? I wonder if it would do with ARRAY of columns. -
Where I have problem is the creation part of the MS pop-up form to link with the sql server....Leave a comment:
-
Access Open Form Criteria
I am new to MS Access and database. What I want to achieve is to get a form pop out every time I open a database file in Access, that the user can select the report generation date range, type of levels of the reports, etc. then the criteria will be sent to the sql server that the access tables/database are linked with to generate the specified report in access.
No activity results to display
Leave a comment: