Access 2000 query - Repost

We have an Access 2000 database that has a table called "1996 - CURRENT AGREEMENTS & CONTRACTS" and Form called the same "1996 - CURRENT AGREEMENTS & CONTRACTS" the Table contains a field called "Full Year" (YYYY) format and a field called "Con#" (001, 002 etc...) Format. When a new record is created using our form the user must select from a drop down box between Current Year or Upcoming Year. If they select Current year we need it to lookup in the Table all the current year entries i.e. 2002 and then look at the LAST "Con#" for the "Full Year" and then return the Next Con# (Con# stands for Consecutive number) so if the Last 2002 entry has a con# of 025 the next Con# should be 026. If they select Upcoming Year then it will do the same but for the NEXT year i.e. 2003 lookup the Con# and add 1 to it. We have the event started however we neen it to retreive the Con#.

## Deliverables

Deliverables: Please see the Attached file as this has the Code we have so far and where we need the NEW code placed. The First coder with the solution will receive the bid. All that we need is the "ConsNum" see in the code to retrieve the NEXT Con# based on the Year chosen. We have a message box to test this. The Test database if you select the current year (2002) should REturn 027 however the current query is returning 2. 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 (VB)

## Deadline information

We need this code ASAP the coder with the completed WORKING code will receive the award. Please this must be completed FAST FAST FAST!

Taidot: Tietokannan hallinto, tekniikka, MySQL, PHP, tietojärjestelmäarkkitehtuuri, Ohjelmistojen testaus, SQL, Visual Basic

Näytä lisää: n query, event run down, query table, access 2000 database, access query table, visual basic entry form, access table query, access table query form, consecutive add, access form record, access event database, record lookup, lookup table php, event solution, access solution, test software repost, database entry visual basic, return query database php, package access distribution, access package distribution

Tietoa työnantajasta:
( 31 arvostelua ) United States

Projektin tunnus: #2872094

Myönnetty käyttäjälle:


See private message.

$7 USD 14 päivässä
(76 Arvostelua)

3 freelanceria on tarjonnut keskimäärin 11$ tähän työhön


See private message.

$17 USD 14 päivässä
(22 arvostelua)

See private message.

$8.5 USD 14 päivässä
(5 arvostelua)