Search results

  1. A

    Please help with this report

    Thank you all for the support. Dlookup did the job.
  2. A

    Please help with this report

    @arnelgp Please, these are the two queries below. I need help merging them. Query 1 Brings multi rows---- SELECT tbldaywork.empno, tbldayworkdetails.datecompleted, DJoin("descode","(select tbldayworkdetails.datecompleted, tbldayworkdetails.descode, tbldaywork.empno from tbldaywork INNER JOIN...
  3. A

    Please help with this report

    I have this report using a Djoin query which brings out multiple rows. I need to bring to the report records from another query that brings only a single row which will populate the fields in the area marked yellow. Kindly assist. Please see the image of the report attached.
  4. A

    Form data

    Please, I already have a link. there is a link field. on WORKID and HEADID Not an expert though. I may be wrong
  5. A

    Form data

    Dear Kindly assist me here. I have the form in attachment used to assign designs to trainees to work on daily. They can be assigned with multiple designs in a day. When A trainee is selected and has designs for the same day already, I want the form to fetch those designs then the user can add...
  6. A

    Insert Query

    Thanks @MajP
  7. A

    Insert Query

    How to insert data into the second table horizontally. Kindly assist from ID EMPID HEADID Compcode Compname Amount datetim 44 120 3 3 Basic 300 17-Aug-19 45 120 3 2 Attendance 250 17-Aug-19 46 120 3...
  8. A

    Query to Transform Data

    Thank all. @arnelgp @MrHans @theDBguy and all team members. This link helped a lot. I'm able to present the data in the report. Much regards
  9. A

    Query to Transform Data

    Thanks alot. I erred at that area DESIGNCODE1, DESIGNCODE2, DESIGNCODE3, etc is how I want to present the data
  10. A

    Query to Transform Data

    Thanks all for the support. Sorry I made a mistake I rather want the columns like below; DATE TRAINEE DESIGNCODE1 DESIGNCODE2 01/08/2019 1001 D0D23 D0D24 02/08/2019 1002 D0123 100RT
  11. A

    Query to Transform Data

    Maybe not. But any advice to go around it please. Even if it involves creating additional table.
  12. A

    Query to Transform Data

    Dear all kindly assist me in doing this. I have data in a table which look like below DATE DESIGNCODE TRAINEE 01/08/2019 D0D23 1001 01/08/2019 D0D24 1001 02/08/2019 D0123 1002 02/08/2019 100RT 1002 I need a query to present it like below in a report. I have tried crosstab queries. Maybe my...
  13. A

    Hello from Accra

    Hello, I'm still a newbie in MS Access. I've worked as a ERP Implementer for sometime now. Im learning Access now to develop apps for some SME's.
Top Bottom