Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 21st, 2004, 06:58 AM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default Need help from skilled programers!

Have a good data entry form that fills table 1 in access
like :

Dia Código Ocorrencia HE HI
1 7 p 0 1,5
2 7 p 0 1,5
3 7 a 0 1,5
1 14 p 1 0
2 14 p 2 0
3 14 p 0 0


Have a good lay-out report in access that needs source table 2
like :

Código Evento Campo1 Campo2 Campo3
7 Ocorrencia p p a
7 HE 0 0 0
7 HI 1,5 1,5 1,5
14 Ocorrencia p p p
14 HE 1 2 0
14 HI 0 0 0

Question:
How do I map the data from table 1 to table 2 in access
using programming?
I dont want to go to excel to use the transpose copy.
Comment:
For each same data under Field("Código") there will be
as many data under Field("Dia") as the days of the month.
For simplicity we have three days.

 
Old August 21st, 2004, 11:31 AM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This is my last SOS asking for help.Why do I have an icon to delete it?
How do I erase the delete icon?
Tks for any help!

 
Old August 25th, 2004, 08:56 AM
Authorized User
 
Join Date: Aug 2004
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

try to create a union query (SQL qry)

 
Old August 26th, 2004, 08:22 AM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank u Stanny,
I will study SQL before i try your approach.
Tks for the help.

 
Old August 27th, 2004, 01:52 AM
Authorized User
 
Join Date: Aug 2004
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default


try the something like this in the SQL query view

SELECT table1.* from table1
UNION Select table2.* from table2;

 
Old August 27th, 2004, 09:04 AM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

thanks again Stanny!
As soon as i have time to try your way i will let u know.Unfortunatelly that will mean at least a week.


 
Old September 7th, 2004, 05:26 AM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Have tried SQL query with no progress.I am trying arrays now and by the way need help too.
Tks for the help.










Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.