Recent content by ariansman

  1. A

    Put data from report into a form

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

    Put data from report into a form

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

    Put data from report into a form

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

    Put data from report into a form

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

    is there a sort and sum query?

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

    is there a sort and sum query?

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

    is there a sort and sum query?

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

    is there a sort and sum query?

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

    is there a sort and sum query?

    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?
  10. A

    is there a sort and sum query?

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

    How to sort by SUM result

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

    How to sort by SUM result

    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?
  13. A

    How to sort by SUM result

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

    how to get a summary querry

    Thank you very much :)
Top Bottom