Yeah. the logic seems to be compromised here. Let's look at it for the sake of feasibility.
Can I put the EmployeeID of the report on which I just clicked, into a control in the form? I need to be on the ONCLICK module.
thank you
Yeah. You are right. I could make it bond to a Combobox list of EmployeeID. But I still will have to select the EmployeeID from the list manually.
I want it to load the EmployeeID, compatible with the EmployeeID onclick on the report.
I have a report of Employee’s jobs, named EmployeeReport. I would like to open a form named “Form1” when I click on an EmployeeID on the EmployeeReport. Form1 is not set on a table or a query. This form has some unbound controls. One of the controls is named “Employees”.
So far, I know I should...
I hope you understand a desperate buddy. The crossdiscussion helped me look at it in a different way and find the solution. Not to condone it. will only post in one location next time. your site, your rule.
Thank you very much
SELECT staffcost.ID, staffcost.sataffname, staffcost.itemname, staffcost.price, staffcost.Qnt, Sum(staffcost.[Qnt]*[price]) AS cost
FROM staffcost
GROUP BY staffcost.ID, staffcost.sataffname, staffcost.itemname, staffcost.price, staffcost.Qnt;
thank you man but it did not address what i was looking for. i need to group the "staff" and then add all the related number for each staff in one record for each staff.
Thank you. Sorry, I am not an expert and couldn't figure it. Can you please instruct me with more details? How should I do that? Is there a code in SQL I should put?
We have the following table:
ID
Staff
ItemName
Price
Qnt
Cost
1
John
Book
5
3
15
2
Mori
pencil
6
7
42
3
Tom
Book
7
4
28
4
Tom
paper
10
6
60
5
Mori
paper
10
3
30
6
John
pencil
6
2
12
7
John
Book
5
1
5
8
Mori
paper
10
8
80
9
Mori...
I opened the query in Datasheet view. In the Records group, I clicked Totals. In the Total row, I clicked the cell in the field that I want to sum, and then selected Sum from the list. Is this how we should get the Sum expression in the query? But I still do not see the sum in the report design...
I have made a report such as the following
Studentname yearlycost
John 21000
Steve 27000
Jack 22000
Amanda 20000
The yearlycost is the sum of monthly_cost of each student and is created by the SUM function of the report. How can I sort the report based on the yearlycost? Since...