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

System generated combined number from existing fields

P: n/a
I have searched high and low for a sample for this, and I just can't
find any. Sorry for the length!

Background Information

The issue revolves around setting up a system-generated increase in
two of a three-part field - one numeric the other text. The Org
Number, Incremental Number, and Subcontractor Designation make up the
Audit Identification number(7) for queries and reports. There is a
hyphen between Org Number and Incremental Number. I've had to number
the columns as I can't fit the names on them - sorry.

1. Autonumbering showing repeated sequences

1 - Audits Table - PK=tblAuditsID - covers 1, 2 and 3 Is 1:M
tblContractor

2. Org Number field (text) This is chosen from a combo box from a
lookup table, there are 27 different Org Numbers

3. Incremental Number field (numeric)

4. Contractor Name field
Contractor Table PK=tblContractorID, FK is tblAudit IDTable

5. SubContractor Designation field

SubContractor Table - PK=tblSubcontractorID, FK=tblContractorID -
covers 5 & 6

6. SubContractor Name

7. Audit Identification Number - Final needed results

1 2 3 4 5 6 7
1 P1100 100 OASIS Co P1100-0100
2 P1200 2173 XYZ Co P1200-2173
3 P1300 569 123 Co
P1300-0569
3 A 56 Co
P1300-0569A
4 P1400 1952 WEX Co P1400-1952
4 A KELP Co.
P1400-1952A
5 P1500 2173 ABC Co P1500-2173
5 A DEF Co.
P1500-2173A
5 B Peter Paul
P1500-2173B
5 C Mary Smith
P1500-2173C
6 P1550 59 Boxer
P1550-0059
7 P1600 961 Davis Max P1600-0961
8 P1700 1 Charlie's
P1700-0001
9 P1800 5 Mary Lamb P1800-0005
10 P1900 590 Nemo P1900-0950
11 P2000 232 Harry
P2000-0232

Numeric Autonumber
The value in the Increment field (third column) represents the last
number used in the old system. In the new database it would have to
start at the last number shown in that field plus an increment of one
for each of the Org Numbers (2),in which there is a new assignment.

The user would also have to have the ability to:

* Open up an existing record and be able to add additional
subcontractors and/or amendments that reside in other tables.
* Be able to pull up an exiting record to add additional information
from another input form.

The last four fields (4-7) in the table above are in different tables
and are shown here for illustration purposes. I repeated the Primary
Key Autonumber (1) to show you when we are on the same record. The
real database would not have the primary key repeated.

Text Autonumber
When the user gets to the part of the record to enter the
SubContractor names (6)in the Subcontractor Table (6) he/she will use
a combo box to add those subcontractors who are working for a
particular prime contractor (4) into the SubContractor Name (6)
field. The contract identifies all the applicable subcontractors.

After the first subcontractor is added to the Subcontractor Table, a
value of A-ZZ (5) needs to be placed in the SubDesignation (5) field
in the Subcontractor Table. (5) It represents the designation for
that subcontractor. As each additional subcontractor is added in the
SubContractor Name field the system needs to use the next available
letter up to and including ZZ if there are that many subcontractors
included in the contract.

Clear as mud? From the Audit table, I need to choose the Org number
(P1100), add a dash, add the Incremental number (4 byte, so leading
zero's) to it plus 1, and if there is a subcontractor add an A (A-ZZ),
another subcontractor add a B & so on.

Thank you for even reading this. If my chart didn't come in clearly
and you are interested in helping, let me know and I'll send you
another one. I am just not a programmer and really need help with
this. All of the tables have been normalized, and if you need to see
the data model just let me know. Thank You.

Elfae
Dec 13 '07 #1
Share this Question
Share on Google+
8 Replies


P: n/a
On Dec 12, 11:13 pm, Elfae <nanc...@efn.orgwrote:
I have searched high and low for a sample for this, and I just can't
find any. Sorry for the length!

Background Information

The issue revolves around setting up a system-generated increase in
two of a three-part field - one numeric the other text. The Org
Number, Incremental Number, and Subcontractor Designation make up the
Audit Identification number(7) for queries and reports. There is a
hyphen between Org Number and Incremental Number. I've had to number
the columns as I can't fit the names on them - sorry.

1. Autonumbering showing repeated sequences

1 - Audits Table - PK=tblAuditsID - covers 1, 2 and 3 Is 1:M
tblContractor

2. Org Number field (text) This is chosen from a combo box from a
lookup table, there are 27 different Org Numbers

3. Incremental Number field (numeric)

4. Contractor Name field
Contractor Table PK=tblContractorID, FK is tblAudit IDTable

5. SubContractor Designation field

SubContractor Table - PK=tblSubcontractorID, FK=tblContractorID -
covers 5 & 6

6. SubContractor Name

7. Audit Identification Number - Final needed results

1 2 3 4 5 6 7
1 P1100 100 OASIS Co P1100-0100
2 P1200 2173 XYZ Co P1200-2173
3 P1300 569 123 Co P1300-0569
3 A 56 Co P1300-0569A
4 P1400 1952 WEX Co P1400-1952
4 A KELP Co. P1400-1952A
5 P1500 2173 ABC Co P1500-2173
5 A DEF Co. P1500-2173A
5 B Peter Paul P1500-2173B
5 C Mary Smith P1500-2173C
6 P1550 59 Boxer P1550-0059
7 P1600 961 Davis Max P1600-0961
8 P1700 1 Charlie's P1700-0001
9 P1800 5 Mary Lamb P1800-0005
10 P1900 590 Nemo P1900-0950
11 P2000 232 Harry P2000-0232

Numeric Autonumber
The value in the Increment field (third column) represents the last
number used in the old system. In the new database it would have to
start at the last number shown in that field plus an increment of one
for each of the Org Numbers (2),in which there is a new assignment.

The user would also have to have the ability to:

* Open up an existing record and be able to add additional
subcontractors and/or amendments that reside in other tables.
* Be able to pull up an exiting record to add additional information
from another input form.

The last four fields (4-7) in the table above are in different tables
and are shown here for illustration purposes. I repeated the Primary
Key Autonumber (1) to show you when we are on the same record. The
real database would not have the primary key repeated.

Text Autonumber
When the user gets to the part of the record to enter the
SubContractor names (6)in the Subcontractor Table (6) he/she will use
a combo box to add those subcontractors who are working for a
particular prime contractor (4) into the SubContractor Name (6)
field. The contract identifies all the applicable subcontractors.

After the first subcontractor is added to the Subcontractor Table, a
value of A-ZZ (5) needs to be placed in the SubDesignation (5) field
in the Subcontractor Table. (5) It represents the designation for
that subcontractor. As each additional subcontractor is added in the
SubContractor Name field the system needs to use the next available
letter up to and including ZZ if there are that many subcontractors
included in the contract.

Clear as mud? From the Audit table, I need to choose the Org number
(P1100), add a dash, add the Incremental number (4 byte, so leading
zero's) to it plus 1, and if there is a subcontractor add an A (A-ZZ),
another subcontractor add a B & so on.

Thank you for even reading this. If my chart didn't come in clearly
and you are interested in helping, let me know and I'll send you
another one. I am just not a programmer and really need help with
this. All of the tables have been normalized, and if you need to see
the data model just let me know. Thank You.

Elfae
I corrected the chart. Elfae
Dec 14 '07 #2

P: n/a
On Dec 12, 11:13 pm, Elfae <nanc...@efn.orgwrote:
I have searched high and low for a sample for this, and I just can't
find any. Sorry for the length!

Background Information

The issue revolves around setting up a system-generated increase in
two of a three-part field - one numeric the other text. The Org
Number, Incremental Number, and Subcontractor Designation make up the
Audit Identification number(7) for queries and reports. There is a
hyphen between Org Number and Incremental Number. I've had to number
the columns as I can't fit the names on them - sorry.

1. Autonumbering showing repeated sequences

1 - Audits Table - PK=tblAuditsID - covers 1, 2 and 3 Is 1:M
tblContractor

2. Org Number field (text) This is chosen from a combo box from a
lookup table, there are 27 different Org Numbers

3. Incremental Number field (numeric)

4. Contractor Name field
Contractor Table PK=tblContractorID, FK is tblAudit IDTable

5. SubContractor Designation field

SubContractor Table - PK=tblSubcontractorID, FK=tblContractorID -
covers 5 & 6

6. SubContractor Name

7. Audit Identification Number - Final needed results

1 2 3 4 5 6 7
1 P1100 100 OASIS Co P1100-0100
2 P1200 2173 XYZ Co P1200-2173
3 P1300 569 123 Co P1300-0569
3 A 56 Co P1300-0569A
4 P1400 1952 WEX Co P1400-1952
4 A KELP Co.P1400-1952A
5 P1500 2173 ABC Co P1500-2173
5 A DEF Co. P1500-2173A
5 B Peter Paul P1500-2173B
5 C Mary Smith P1500-2173C
6 P1550 59 Boxer P1550-0059
7 P1600 961 Davis Max P1600-0961
8 P1700 1 Charlie's P1700-0001
9 P1800 5 Mary Lamb P1800-0005
10 P1900 590 Nemo P1900-0950
11 P2000 232 Harry P2000-0232

Numeric Autonumber
The value in the Increment field (third column) represents the last
number used in the old system. In the new database it would have to
start at the last number shown in that field plus an increment of one
for each of the Org Numbers (2),in which there is a new assignment.

The user would also have to have the ability to:

* Open up an existing record and be able to add additional
subcontractors and/or amendments that reside in other tables.
* Be able to pull up an exiting record to add additional information
from another input form.

The last four fields (4-7) in the table above are in different tables
and are shown here for illustration purposes. I repeated the Primary
Key Autonumber (1) to show you when we are on the same record. The
real database would not have the primary key repeated.

Text Autonumber
When the user gets to the part of the record to enter the
SubContractor names (6)in the Subcontractor Table (6) he/she will use
a combo box to add those subcontractors who are working for a
particular prime contractor (4) into the SubContractor Name (6)
field. The contract identifies all the applicable subcontractors.

After the first subcontractor is added to the Subcontractor Table, a
value of A-ZZ (5) needs to be placed in the SubDesignation (5) field
in the Subcontractor Table. (5) It represents the designation for
that subcontractor. As each additional subcontractor is added in the
SubContractor Name field the system needs to use the next available
letter up to and including ZZ if there are that many subcontractors
included in the contract.

Clear as mud? From the Audit table, I need to choose the Org number
(P1100), add a dash, add the Incremental number (4 byte, so leading
zero's) to it plus 1, and if there is a subcontractor add an A (A-ZZ),
another subcontractor add a B & so on.

Thank you for even reading this. If my chart didn't come in clearly
and you are interested in helping, let me know and I'll send you
another one. I am just not a programmer and really need help with
this. All of the tables have been normalized, and if you need to see
the data model just let me know. Thank You.

Elfae
Dec 14 '07 #3

P: n/a
Elfae <na*****@efn.orgwrote in news:dc34b98b-d20e-45b9-89c7-
a8**********@d21g2000prf.googlegroups.com:
I have searched high and low for a sample for this, and I just can't
find any. Sorry for the length!

Background Information

The issue revolves around setting up a system-generated increase in
two of a three-part field - one numeric the other text. The Org
Number, Incremental Number, and Subcontractor Designation make up the
Audit Identification number(7) for queries and reports. There is a
hyphen between Org Number and Incremental Number. I've had to number
the columns as I can't fit the names on them - sorry.

1. Autonumbering showing repeated sequences

1 - Audits Table - PK=tblAuditsID - covers 1, 2 and 3 Is 1:M
tblContractor

2. Org Number field (text) This is chosen from a combo box from a
lookup table, there are 27 different Org Numbers

3. Incremental Number field (numeric)

4. Contractor Name field
Contractor Table PK=tblContractorID, FK is tblAudit IDTable

5. SubContractor Designation field

SubContractor Table - PK=tblSubcontractorID, FK=tblContractorID -
covers 5 & 6

6. SubContractor Name

7. Audit Identification Number - Final needed results

1 2 3 4 5 6 7
1 P1100 100 OASIS Co P1100-0100
2 P1200 2173 XYZ Co P1200-2173
3 P1300 569 123 Co
P1300-0569
3 A 56 Co
P1300-0569A
4 P1400 1952 WEX Co P1400-1952
4 A KELP Co.
P1400-1952A
5 P1500 2173 ABC Co P1500-2173
5 A DEF Co.
P1500-2173A
5 B Peter Paul
P1500-2173B
5 C Mary Smith
P1500-2173C
6 P1550 59 Boxer
P1550-0059
7 P1600 961 Davis Max P1600-0961
8 P1700 1 Charlie's
P1700-0001
9 P1800 5 Mary Lamb P1800-0005
10 P1900 590 Nemo P1900-0950
11 P2000 232 Harry
P2000-0232

Numeric Autonumber
The value in the Increment field (third column) represents the last
number used in the old system. In the new database it would have to
start at the last number shown in that field plus an increment of one
for each of the Org Numbers (2),in which there is a new assignment.

The user would also have to have the ability to:

* Open up an existing record and be able to add additional
subcontractors and/or amendments that reside in other tables.
* Be able to pull up an exiting record to add additional information
from another input form.

The last four fields (4-7) in the table above are in different tables
and are shown here for illustration purposes. I repeated the Primary
Key Autonumber (1) to show you when we are on the same record. The
real database would not have the primary key repeated.

Text Autonumber
When the user gets to the part of the record to enter the
SubContractor names (6)in the Subcontractor Table (6) he/she will use
a combo box to add those subcontractors who are working for a
particular prime contractor (4) into the SubContractor Name (6)
field. The contract identifies all the applicable subcontractors.

After the first subcontractor is added to the Subcontractor Table, a
value of A-ZZ (5) needs to be placed in the SubDesignation (5) field
in the Subcontractor Table. (5) It represents the designation for
that subcontractor. As each additional subcontractor is added in the
SubContractor Name field the system needs to use the next available
letter up to and including ZZ if there are that many subcontractors
included in the contract.

Clear as mud? From the Audit table, I need to choose the Org number
(P1100), add a dash, add the Incremental number (4 byte, so leading
zero's) to it plus 1, and if there is a subcontractor add an A (A-ZZ),
another subcontractor add a B & so on.

Thank you for even reading this. If my chart didn't come in clearly
and you are interested in helping, let me know and I'll send you
another one. I am just not a programmer and really need help with
this. All of the tables have been normalized, and if you need to see
the data model just let me know. Thank You.

Elfae
But what's your question?

Column Seven? It contains informtation from three other columns. It's
redundant and most developers would remove it (not create it in the
first place). It is always available as
[Column2] & "-" & Format([Column3], "0000") & [Column5]
(using the real names for the columns).

A - ZZ for the subcontractors? We could invent some wonderfuly clever
procedure for assigning these designations. But we have a max of 52
subcontractors? Then it shouldn't be inefficient to have the
subcontractors and their designations stored in a separate table and its
data, including the A-ZZ designation to be entered interactively. It
would, of course, be the basis for the listbox you mention.

You've said you are not a programmer. For people who are not programmers,
keeping things as simple as possible is a great idea. I think you
haven't.

Experienced programmers, of course, keep things simple as as habit.

Wannabe programmers display their long and complicated code. And they
remain wannabes.

--
lyle fairfield
Dec 14 '07 #4

P: n/a
On Dec 14, 5:09 am, lyle fairfield <lylef...@yahoo.cawrote:
Elfae <nanc...@efn.orgwrote in news:dc34b98b-d20e-45b9-89c7-
a8fabbe70...@d21g2000prf.googlegroups.com:
I have searched high and low for a sample for this, and I just can't
find any. Sorry for the length!
Background Information
The issue revolves around setting up asystem-generatedincrease in
two of a three-part field - one numeric the other text. The Org
Number, IncrementalNumber, and Subcontractor Designation make up the
Audit Identificationnumber(7) for queries and reports. There is a
hyphen between OrgNumberand IncrementalNumber. I've had tonumber
the columns as I can't fit the names on them - sorry.
1. Autonumbering showing repeated sequences
1 - Audits Table - PK=tblAuditsID - covers 1, 2 and 3 Is 1:M
tblContractor
2. OrgNumberfield (text) This is chosen from a combo box from a
lookup table, there are 27 different Org Numbers
3. IncrementalNumberfield (numeric)
4. Contractor Name field
Contractor Table PK=tblContractorID, FK is tblAudit IDTable
5. SubContractor Designation field
SubContractor Table - PK=tblSubcontractorID, FK=tblContractorID -
covers 5 & 6
6. SubContractor Name
7. Audit IdentificationNumber- Final needed results
1 2 3 4 5 6 7
1 P1100 100 OASIS Co P1100-0100
2 P1200 2173 XYZ Co P1200-2173
3 P1300 569 123 Co
P1300-0569
3 A 56 Co
P1300-0569A
4 P1400 1952 WEX Co P1400-1952
4 A KELP Co.
P1400-1952A
5 P1500 2173 ABC Co P1500-2173
5 A DEF Co.
P1500-2173A
5 B Peter Paul
P1500-2173B
5 C Mary Smith
P1500-2173C
6 P1550 59 Boxer
P1550-0059
7 P1600 961 Davis Max P1600-0961
8 P1700 1 Charlie's
P1700-0001
9 P1800 5 Mary Lamb P1800-0005
10 P1900 590 Nemo P1900-0950
11 P2000 232 Harry
P2000-0232
Numeric Autonumber
The value in the Increment field (third column) represents the last
numberused in the oldsystem. In the new database it would have to
start at the lastnumbershown in that field plus an increment of one
for each of the Org Numbers (2),in which there is a new assignment.
The user would also have to have the ability to:
* Open up anexistingrecord and be able to add additional
subcontractors and/or amendments that reside in other tables.
* Be able to pull up an exiting record to add additional information
from another input form.
The last fourfields(4-7) in the table above are in different tables
and are shown here for illustration purposes. I repeated the Primary
Key Autonumber (1) to show you when we are on the same record. The
real database would not have the primary key repeated.
Text Autonumber
When the user gets to the part of the record to enter the
SubContractor names (6)in the Subcontractor Table (6) he/she will use
a combo box to add those subcontractors who are working for a
particular prime contractor (4) into the SubContractor Name (6)
field. The contract identifies all the applicable subcontractors.
After the first subcontractor is added to the Subcontractor Table, a
value of A-ZZ (5) needs to be placed in the SubDesignation (5) field
in the Subcontractor Table. (5) It represents the designation for
that subcontractor. As each additional subcontractor is added in the
SubContractor Name field thesystemneeds to use the next available
letter up to and including ZZ if there are that many subcontractors
included in the contract.
Clear as mud? From the Audit table, I need to choose the Orgnumber
(P1100), add a dash, add the Incrementalnumber(4 byte, so leading
zero's) to it plus 1, and if there is a subcontractor add an A (A-ZZ),
another subcontractor add a B & so on.
Thank you for even reading this. If my chart didn't come in clearly
and you are interested in helping, let me know and I'll send you
another one. I am just not a programmer and really need help with
this. All of the tables have been normalized, and if you need to see
the data model just let me know. Thank You.
Elfae

But what's your question?

Column Seven? It contains informtation from three other columns. It's
redundant and most developers would remove it (not create it in the
first place). It is always available as
[Column2] & "-" & Format([Column3], "0000") & [Column5]
(using the real names for the columns).

A - ZZ for the subcontractors? We could invent some wonderfuly clever
procedure for assigning these designations. But we have a max of 52
subcontractors? Then it shouldn't be inefficient to have the
subcontractors and their designations stored in a separate table and its
data, including the A-ZZ designation to be entered interactively. It
would, of course, be the basis for the listbox you mention.

You've said you are not a programmer. For people who are not programmers,
keeping things as simple as possible is a great idea. I think you
haven't.

Experienced programmers, of course, keep things simple as as habit.

Wannabe programmers display their long and complicated code. And they
remain wannabes.

--
lyle fairfield
Well, aren't you just the person I needed to run me down. Nice going,
gosh, you should be quite proud of yourself. I am a very experienced
developer, I guess I should ask how many commercial systems you have?
But, I only have 7. I also see you don't comprehend what you read.
I'll state it again. The last four fields(4-7) in the table above
are in different tables and are shown here for illustration purposes
only.

My question? I'll that again also: From the Audit table, I need
to choose the Orgnumber
(P1100), add a dash, add the Incrementalnumber(4 byte, so leading
zero's) to it plus 1, and if there is a subcontractor add an A (A-ZZ),
another subcontractor add a B & so on.
I said nothing about a listbox. And there are not only 52
subcontractors. Subcontractors are interchangeable with Contractors
and are in a lookup table.

Perhaps is you actually studied my question, you could give an answer
that actually becomes a programmer.
Dec 15 '07 #5

P: n/a
On Dec 14, 7:45 pm, Elfae <nanc...@efn.orgwrote:
On Dec 14, 5:09 am, lyle fairfield <lylef...@yahoo.cawrote:
Elfae <nanc...@efn.orgwrote in news:dc34b98b-d20e-45b9-89c7-
a8fabbe70...@d21g2000prf.googlegroups.com:
I have searched high and low for a sample for this, and I just can't
find any. Sorry for the length!
Background Information
The issue revolves around setting up asystem-generatedincrease in
two of a three-part field - one numeric the other text. The Org
>Number, IncrementalNumber, and Subcontractor Designation make up the
Audit Identificationnumber(7) for queries and reports. There is a
hyphen between OrgNumberand IncrementalNumber. I've had tonumber
the columns as I can't fit the names on them - sorry.
1. Autonumbering showing repeated sequences
1 - Audits Table - PK=tblAuditsID - covers 1, 2 and 3 Is 1:M
tblContractor
2. OrgNumberfield (text) This is chosen from a combo box from a
lookup table, there are 27 different Org Numbers
3. IncrementalNumberfield (numeric)
4. Contractor Name field
Contractor Table PK=tblContractorID, FK is tblAudit IDTable
5. SubContractor Designation field
SubContractor Table - PK=tblSubcontractorID, FK=tblContractorID -
covers 5 & 6
6. SubContractor Name
7. Audit IdentificationNumber- Final needed results
1 2 3 4 5 6 7
1 P1100 100 OASIS Co P1100-0100
2 P1200 2173 XYZ Co P1200-2173
3 P1300 569 123 Co
P1300-0569
3 A 56 Co
P1300-0569A
4 P1400 1952 WEX Co P1400-1952
4 A KELP Co.
P1400-1952A
5 P1500 2173 ABC Co P1500-2173
5 A DEF Co.
P1500-2173A
5 B Peter Paul
P1500-2173B
5 C Mary Smith
P1500-2173C
6 P1550 59 Boxer
P1550-0059
7 P1600 961 Davis Max P1600-0961
8 P1700 1 Charlie's
P1700-0001
9 P1800 5 Mary Lamb P1800-0005
10 P1900 590 Nemo P1900-0950
11 P2000 232 Harry
P2000-0232
Numeric Autonumber
The value in the Increment field (third column) represents the last
>numberused in the oldsystem. In the new database it would have to
start at the lastnumbershown in that field plus an increment of one
for each of the Org Numbers (2),in which there is a new assignment.
The user would also have to have the ability to:
* Open up anexistingrecord and be able to add additional
subcontractors and/or amendments that reside in other tables.
* Be able to pull up an exiting record to add additional information
from another input form.
The last fourfields(4-7) in the table above are in different tables
and are shown here for illustration purposes. I repeated the Primary
Key Autonumber (1) to show you when we are on the same record. The
real database would not have the primary key repeated.
Text Autonumber
When the user gets to the part of the record to enter the
SubContractor names (6)in the Subcontractor Table (6) he/she will use
a combo box to add those subcontractors who are working for a
particular prime contractor (4) into the SubContractor Name (6)
field. The contract identifies all the applicable subcontractors.
After the first subcontractor is added to the Subcontractor Table, a
value of A-ZZ (5) needs to be placed in the SubDesignation (5) field
in the Subcontractor Table. (5) It represents the designation for
that subcontractor. As each additional subcontractor is added in the
SubContractor Name field thesystemneeds to use the next available
letter up to and including ZZ if there are that many subcontractors
included in the contract.
Clear as mud? From the Audit table, I need to choose the Orgnumber
(P1100), add a dash, add the Incrementalnumber(4 byte, so leading
zero's) to it plus 1, and if there is a subcontractor add an A (A-ZZ),
another subcontractor add a B & so on.
Thank you for even reading this. If my chart didn't come in clearly
and you are interested in helping, let me know and I'll send you
another one. I am just not a programmer and really need help with
this. All of the tables have been normalized, and if you need to see
the data model just let me know. Thank You.
Elfae
But what's your question?
Column Seven? It contains informtation from three other columns. It's
redundant and most developers would remove it (not create it in the
first place). It is always available as
[Column2] & "-" & Format([Column3], "0000") & [Column5]
(using the real names for the columns).
A - ZZ for the subcontractors? We could invent some wonderfuly clever
procedure for assigning these designations. But we have a max of 52
subcontractors? Then it shouldn't be inefficient to have the
subcontractors and their designations stored in a separate table and its
data, including the A-ZZ designation to be entered interactively. It
would, of course, be the basis for the listbox you mention.
You've said you are not a programmer. For people who are not programmers,
keeping things as simple as possible is a great idea. I think you
haven't.
Experienced programmers, of course, keep things simple as as habit.
Wannabe programmers display their long and complicated code. And they
remain wannabes.
--
lyle fairfield

Well, aren't you just the person I needed to run me down. Nice going,
gosh, you should be quite proud of yourself. I am a very experienced
developer, I guess I should ask how many commercial systems you have?
But, I only have 7. I also see you don't comprehend what you read.
I'll state it again. The last four fields(4-7) in the table above
are in different tables and are shown here for illustration purposes
only.

My question? I'll that again also: From the Audit table, I need
to choose the Orgnumber
(P1100), add a dash, add the Incrementalnumber(4 byte, so leading
zero's) to it plus 1, and if there is a subcontractor add an A (A-ZZ),
another subcontractor add a B & so on.

I said nothing about a listbox. And there are not only 52
subcontractors. Subcontractors are interchangeable with Contractors
and are in a lookup table.

Perhaps is you actually studied my question, you could give an answer
that actually becomes a programmer.
There are many kind people who post here regularly and I hope that one
or more of them will help you.
Dec 15 '07 #6

P: n/a
rkc
Elfae wrote:
Thank you for even reading this. If my chart didn't come in clearly
and you are interested in helping, let me know and I'll send you
another one. I am just not a programmer and really need help with
this. All of the tables have been normalized, and if you need to see
the data model just let me know. Thank You.
Post the data model. I think the help you need starts there.
Dec 15 '07 #7

P: n/a
lyle fairfield <ly******@yahoo.cawrote in
news:Uf*******************@read1.cgocable.net:
A - ZZ for the subcontractors? We could invent some wonderfuly
clever procedure for assigning these designations. But we have a
max of 52 subcontractors?
26 * 26 will give the total number of subcontractors. 52 is 26 + 26.

It's not too difficult to convert a number to a string of letters for
display, but it is a *royal* pain to convert a string into a number for
incrementing.
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Dec 15 '07 #8

P: n/a
Elfae <na*****@efn.orgwrote in
news:1ffb3fa9-8215-4ff5-934b-
6d**********@a35g2000prf.googlegroups.co
m:

[egocentric rant snipped]
If you want to extend a helping hand, do so, if you don't, please
just don't answer at all.

I did extend a helping hand. Read what I said about how to handle
your incrementing string... store it as a number and just display it
as a string... You said you searched high and low and didn't find
anything, guess why. It's not worth the pain to do it the way you
originally envisaged.
>Your letter suffix is going to bite you eventually, you will be
better off to use a numeric suffix in your tables, there are many
code examples on how to programatically increment anumberon the
web and in books. You can also use a little function to convert
thenumberto a letter for display purposes, but, as Lyle said,
"Keep it simple"
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Dec 16 '07 #9

This discussion thread is closed

Replies have been disabled for this discussion.