adding a counter to a field

Completed Posted Apr 8, 2003 Paid on delivery
Completed Paid on delivery

Adding a counter to a field I have 5 fields... 1. Appraiser Number 2. Year 3. Client 4. Appraisal Number 5. Folio Number My problem is that the Appraisal number field has to do the following: - the Appraisal number field is the number of appraisals that we have done for that client for that specific year. How can I create this counter? Here is an example: Appraiser Number: 22 Year: 02 Client: 112 Appraisal Number: 317 Folio Number: 54093 This means that we have done 317 appraisals for client 112 in 2002. Note: As soon as we enter the client number, I want a message box stating "Would you like the Appraisal Number to be 317?" If yes, then it adds 317 to the Appraisal Number. Once the date changes to 03, the counter goes back to zero. Please keep in mind that this database has over 60000 records. I'm just adding a few fields to the database. The old counter isn't there since the old databe was done in VB.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.

## Platform

access 2000

Engineering Microsoft Access MySQL PHP Software Architecture Software Testing

Project ID: #2923572

About the project

7 proposals Remote project Active Apr 9, 2003

Awarded to:

sawamu

See private message.

$2 USD in 14 days
(215 Reviews)
5.9

7 freelancers are bidding on average $21 for this job

vw391686vw

See private message.

$34 USD in 14 days
(50 Reviews)
6.3
DeanMan

See private message.

$38.25 USD in 14 days
(68 Reviews)
5.2
timk98

See private message.

$12.75 USD in 14 days
(54 Reviews)
4.7
vw477251vw

See private message.

$10.2 USD in 14 days
(39 Reviews)
4.4
arcan08

See private message.

$8.5 USD in 14 days
(28 Reviews)
3.4
jfconsult

See private message.

$42.5 USD in 14 days
(0 Reviews)
0.0