Hi
I have 2 queries where I calculated time elapsed. In the first I
calculated time spent by a employee in group meetings and in the second
query, I calculated time spent by an employee in personal meetings with
the clients. I wish to join the two queries to sum up the total time.
I have the following fields
Fields for Group hours query
CoID
CoFName
CoLName
Program Id
Session Number
Meeting Number
Date
Start Time
End Time
Minutes: DateDiff("n",[Start Time],[End Time])
where
CoID, CoFName, CoLName FROM COUNSELOR TABLE
Program Id, Session Number, Meeting Number,Date, Start Time, End Time
FROM GROUP PROGRAM SCHEDULE
Fields for the individual hours query
CoID
CoFName
CoLName
ClientID
PrgmID
Date
Meet Start Time
Meet End Time
Minutes: DateDiff("n",[Meet Start Time],[Meet End Time])
CoID, COFName, CoLName from COUNSELOR Table
ClientID, PrgmID, Date, Meet Start Time, Meet End Time FROM PERSONAL
MEETINGS Table
Following are the SQL views
SQL view of first query
SELECT [Personal Meetings].ClientID, Counselor.CoID, Counselor.CoFNa me,
Counselor.CoLNa me, [Personal Meetings].PrgmID, [Personal
Meetings].Date, [Personal Meetings].[Meet Start Time], [Personal
Meetings].[Meet End Time], DateDiff("n",[Meet Start Time],[Meet End
Time]) AS Minutes
FROM (Program INNER JOIN (Counselor INNER JOIN [Counselor Program
Administer] ON Counselor.CoID=[Counselor Program Administer].CoID) ON
Program.PrgmID=[Counselor Program Administer].PrgmID) INNER JOIN
[Personal Meetings] ON Program.PrgmID=[Personal Meetings].PrgmID;
SQL view of second query
SELECT Counselor.CoID, Counselor.CoFNa me, Counselor.CoLNa me, [Group
Program Schedule].[Meeting Number], [Group Program Schedule].[Program
Id], [Group Program Schedule].[Session Number], [Group Program
Schedule].Date, [Group Program Schedule].[Start Time], [Group Program
Schedule].[End Time], DateDiff("n",[Start Time],[End Time]) AS Minutes
FROM (Program INNER JOIN (Counselor INNER JOIN [Counselor Program
Administer] ON Counselor.CoID = [Counselor Program Administer].CoID) ON
Program.PrgmID = [Counselor Program Administer].PrgmID) INNER JOIN
[Group Program Schedule] ON Program.PrgmID = [Group Program
Schedule].[Program Id];
Now I wish to sum the minutes from two query since they refer to the
same counselor field.
Can anyone help me ?
Thanks
MaCh 0 1384 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Yaroslav Bulatov |
last post by:
I made an array of 10 million floats timed how long it takes to sum
the elements, here's what I got (millis):
gcc -O2: 21
Python with numarray: 104
Python with Numeric: 302
java: 325
gcc: 348
Python with Psyco: 1317
Pure Python using sum: 2312
|
by: BillG |
last post by:
I have a datagrid with a start and an end time. I subtract the start time
from the end time in each row and place the difference into a TimeSpan
variable. Now I want to total up the Timespans and get the total number of
hours taken.
Dim HourSum as Decimal = 0.0
Later in a method I call
HoursSum += Convert.ToDecimal(Hours) **error - doesn't like type cast.
|
by: SunMan |
last post by:
Hello!
I am trying to create a program that will ask for a user to enter a series of letters (codes) and then print out a table that shows the codes in decending frequency. Only letters will be read into the array.
I have created a struct and array like below.
struct record
{
char inputChar;
|
by: steveprevost |
last post by:
I have a text field that contains mostly numbers, but the rows without
a value have a blank in them. I need to sum on this row, but I get a
conversion error.
I've tried using various functions like
SELECT iif(iserror(cdbl(issuelist.)),
sum(0+0),sum(issuelist.)) from issuelist;
but then I get the error that the specified expression is not part of
|
by: Don Sealer |
last post by:
I have about 40 different defects I'm tracking. I'd like to have all of
these defects totaled individually, both by month and by year. I'd like to
show these results in a report. I know I could create 40 queries (one for
each defect) with just the two fields, count and defect, and sum the count
field but that sounds like a lot of work.
Is there a way I can do this much simpler and quicker?
My database has two fields, one is called...
| |
by: King |
last post by:
Hi
I have two queries where in I calculated number of hours worked by an
employee.
Fields for the first query
Meeting Id ( Auto Number )
Counselor ID ( text )
Date
|
by: Paul Wagstaff |
last post by:
Hi All
I have an aggregate query that groups by each user, then calculates
Sum(TimeInvested). I need to display the total time (per user) in hrs / mins
e.g. 45:30 (= 45 hrs 30 mins).
Can someone help me with the function to so this?
thanks
paul
|
by: ckpoll2 |
last post by:
Hello,
I have a report in which I'm trying to sum the numbers that appear in . The control source of is:
=IIf( Between And And Like "Overtime - *",,"0")
and 's control source is Hours from a table. In , the box where I want the sum to appear, I have:
=sum()
|
by: lethek39 |
last post by:
Hey
I have been trying to figure out how to sum rows and columns in a matrix square. I also have been trying to get the program to list the numbers of the diagonal in the matrix. So far this is the code I have (I am using Python):
def generate (rows, cols): # This just prints the coordinates and the number that goes in it, It also prints the matrix in a square
import random
m = {}
for r in range(rows):
for c in...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |