Go Back   Access World Forums > Search Forums

 
Showing results 1 to 13 of 13
Search took 0.00 seconds.
Search: Posts Made By: Arvive
Forum: Reports 09-28-2019, 04:13 PM
Replies: 7
Views: 276
Posted By Arvive
Re: Please help with this report

Thank you all for the support. Dlookup did the job.
Forum: Reports 09-28-2019, 02:29 PM
Replies: 7
Views: 276
Posted By Arvive
Re: 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...
Forum: Reports 09-28-2019, 01:55 AM
Replies: 7
Views: 276
Posted By Arvive
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...
Forum: Forms 09-10-2019, 04:41 AM
Replies: 3
Views: 106
Posted By Arvive
Re: 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
Forum: Forms 09-10-2019, 03:21 AM
Replies: 3
Views: 106
Posted By Arvive
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...
Forum: Modules & VBA 08-21-2019, 03:35 AM
Replies: 3
Views: 95
Posted By Arvive
Re: Insert Query

Thanks @MajP
Forum: Modules & VBA 08-19-2019, 03:45 PM
Replies: 3
Views: 95
Posted By Arvive
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 ...
Forum: Queries 08-18-2019, 04:06 PM
Replies: 12
Views: 295
Posted By Arvive
Re: 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
Forum: Queries 08-14-2019, 12:45 AM
Replies: 12
Views: 295
Posted By Arvive
Re: Query to Transform Data

Thanks alot. I erred at that area DESIGNCODE1, DESIGNCODE2, DESIGNCODE3, etc is how I want to present the data
Forum: Queries 08-14-2019, 12:36 AM
Replies: 12
Views: 295
Posted By Arvive
Re: 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
Forum: Queries 08-13-2019, 05:21 PM
Replies: 12
Views: 295
Posted By Arvive
Re: Query to Transform Data

Maybe not. But any advice to go around it please. Even if it involves creating additional table.
Forum: Queries 08-13-2019, 05:06 PM
Replies: 12
Views: 295
Posted By Arvive
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...
Forum: Introduce Yourself 08-13-2019, 04:51 PM
Replies: 3
Views: 105
Posted By Arvive
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.
Showing results 1 to 13 of 13

 
Forum Jump



All times are GMT -8. The time now is 05:11 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World