Search results

Thank you. I could use a VBA code. it worked :)

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;

i did it. it groups the staff but shows all the record for everybody and does not sum the cost. i should have missed something.

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...

Sum does not show up in the droplist for sorting. Do I have to get the sum in the query and then sort it in the report?

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...

Thank you very much :)

very simple and instructive for me as a beginner. :) Thank you. How would it be if we have a number as OrderID instead of the date? I mean the original table is like ID Date item cost OrdeID 1 01/01/2021 milk 2 47 2 01/01/2021 apple 3...

I have the following table: John's daily expenses: ID Date item cost 1 01/01/2021 milk 2 2 01/01/2021 apple 3 3 01/01/2021 cheese 7 4 05/01/2021 milk 4 5 05/01/2021 bread 2 6 05/01/2021 butter 12 7 08/01/2021 milk 2 8 08/01/2021 apple 5 9...

yeah. seems a tad complicated for a non-professional access worker like myself. as you said TheDBguy had a nice and smooth solution. the second one worked for me. thank you for your reply :)

thank you very much it works :)

Thank you, i copied and pate both of them, separately, but received the following errors. i made the screen shot attached. I tried to change he code in someway, with no success.:( and advice?