Search results

  1. 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.
  2. 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...
  3. 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...
  4. 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...
  5. 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