By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,544 Members | 2,021 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,544 IT Pros & Developers. It's quick & easy.

URGENT PROBLEM WITH MULTIPLE RECORDS

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.