469,267 Members | 971 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,267 developers. It's quick & easy.

URGENT PROBLEM WITH MULTIPLE RECORDS

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

Nov 13 '05 #1
2 1411
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
Nov 13 '05 #2
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
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Björn Bengtsson | last post: by
16 posts views Thread by | last post: by
reply views Thread by georges the man | last post: by
18 posts views Thread by Robert Jacobs | last post: by
5 posts views Thread by laurajayne.cozens | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.