Access 2003 SQL

[Stephy]

I am a student of University of applied Science in Berlin(Germany). I speak french and german very well and english moderate. I will try to be clear sothat everyone can understand me.


I am trying to change the structure of a table with access 2003. But still now i wasn't successfull. Could someone help me?

Table: Tracking
Projectnum_ Employeenum_ impt _iqcp
74097/ 22222 / 2 / 4
74097/ 45122 / 0 / 3
75089/ 22222 / 1 / 1

To this structure


Projectnum ___ Employeenum___Task___ Unit
74097 / 22222 / Impt/ 2
74097 / 22222 / Iqcp/ 4
74097 / 45122 / Impt/ 0
74097 / 45122 / Iqcp/ 3
75089 / 22222 / Impt/ 1
75089 / 22222 / Iqcp/ 1


Thanks
Stephanie

[kestrel]

I am a student of University of applied Science in Berlin(Germany). I speak french and german very well and english moderate. I will try to be clear sothat everyone can understand me.


I am trying to change the structure of a table with access 2003. But still now i wasn't successfull. Could someone help me?

Table: Tracking
Projectnum_ Employeenum_ impt _iqcp
74097/ 22222 / 2 / 4
74097/ 45122 / 0 / 3
75089/ 22222 / 1 / 1

To this structure


Projectnum ___ Employeenum___Task___ Unit
74097 / 22222 / Impt/ 2
74097 / 22222 / Iqcp/ 4
74097 / 45122 / Impt/ 0
74097 / 45122 / Iqcp/ 3
75089 / 22222 / Impt/ 1
75089 / 22222 / Iqcp/ 1


Thanks
Stephanie

Hey Stephanie, Welcome to The Scripts. Im going to move this thread to the Access forum. Have a nice day!

[Scott Price]

Good morning Stephanie,

Why do you want to change to a format that introduces so much more duplicate information in your table?

Remember that a relational database uses relations to join pieces of information so that one piece (ideally) is stored in only one location.

That said, generally speaking (i.e. 99.99% of time) only in linking tables is it acceptable to duplicate information found elsewhere, in order to link two tables that have a Many to Many relationship.

You'll need to explain a little more of why you want to do this, first. Then, second, what you have tried already to accomplish it. Also, does this table have a primary key, and if so, which field is it? Thanks!

Regards,
Scott