URGENT PROBLEM WITH MULTIPLE RECORDS

[Dimitri]

PLEASE HELP,I HAVE A DATABSE WITH MULTIPLE RECORDS AS OUTLINED BELOW

EMP NO LEVEL NEXTINCREASE WAGETYPE UNIT
1000 1 0 1000
1000 1 0 1002 1
I WANT TO BE TO HAVE THIS IN ONE RECORD IE REPEAT THE COULUMNS WAGETYPE
AND UNIT(APPEND THEM TO THE END OF UNIT)

HOW CAN I DO THAT PLEASE HELP THIS IS URGENT.

ANDY

[Tim Marshall]

Dimitri wrote:

PLEASE HELP,I HAVE A DATABSE WITH MULTIPLE RECORDS AS OUTLINED BELOW

EMP NO LEVEL NEXTINCREASE WAGETYPE UNIT
1000 1 0 1000
1000 1 0 1002 1
I WANT TO BE TO HAVE THIS IN ONE RECORD IE REPEAT THE COULUMNS WAGETYPE
AND UNIT(APPEND THEM TO THE END OF UNIT)

HOW CAN I DO THAT PLEASE HELP THIS IS URGENT.

ANDY

Andy, it might be urgent, but you are doing something _completely_ the
wrong way. The above looks like it should be two tables. perhaps
something like:

TBL_EMPLOYEE

EMP_PK (use the Access autonumber feature for this)
EMP_NO (use your EMP NO field)
EMP_NAME_FIRST (perhaps employee name?)
EMP_NAME_LAST (etc)

TBL_WAGES

WAG_EMP_FK (this would be the pointer to the employee, ie, the EMP_PK)
WAG_LEVEL
WAG_NEXT_INCREASE
WAG_TYPE
WAG_UNIT

You set up a select query or even a cross tab query to relate TBL_WAGES
to TBL_EMPLOYEE. This way, the employee number, info is entered ONLY
ONCE, plus, you will have the flexibility to have unlimited numbers of
wage types and increases.

Please don't do what you asked to do. You'll be learning a bad database
design lesson. If you insist, a spread sheet is a far better tool.

--
Tim - http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

[Pieter Linden]

Dimitri <pe*******@hotmail.com> wrote in message news:<cj**********@canard.ulcc.ac.uk>...

PLEASE HELP,I HAVE A DATABSE WITH MULTIPLE RECORDS AS OUTLINED BELOW

EMP NO LEVEL NEXTINCREASE WAGETYPE UNIT
1000 1 0 1000
1000 1 0 1002 1
I WANT TO BE TO HAVE THIS IN ONE RECORD IE REPEAT THE COULUMNS WAGETYPE
AND UNIT(APPEND THEM TO THE END OF UNIT)

HOW CAN I DO THAT PLEASE HELP THIS IS URGENT.

ANDY

urgent to YOU, maybe... and shouting is no way to get people to help.
see fConcatChild at mvps.org/access