Simplified Data Entry

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Hi everyone

I'm hoping the forum will be able to help with this problem for me.

The aim is to try and automate repetitive data entry; check for
duplicated entries and try to prevent operator entry errors.

A sample of Data input is shown below as follows:

entrydate cli acc val
04/03/2006 1008 L566 30.00
04/03/2006 3298 L100 10.00
04/03/2006 3605 L057 15.00
04/03/2006 3605 L406 15.00
04/03/2006 4357 L597 35.00
11/03/2006 1008 L566 30.00
11/03/2006 3605 L057 15.00
11/03/2006 3605 L406 15.00
11/03/2006 3605 L789 15.00
11/03/2006 8797 L100 1.00
11/03/2006 8797 L101 5.00
11/03/2006 8797 L102 50.00
11/03/2006 8797 L103 5.00
18/03/2006 1008 L566 15.00
18/03/2006 3605 L406 15.00
18/03/2006 4357 L597 35.00
18/03/2006 3298 L100 20.00
18/03/2006 8797 L101 5.00
18/03/2006 8797 L102 50.00

This data is entered weekly at the moment to avoid duplication but I
would prefer to enter the data as and when it becomes available but
this opens the door to duplicate entries.

The date will always reflect the end of the week in which it is
entered, so this would be constant for every entry for that week.
However, since the data may not be entered until Sunday; using the
system date could produce incorrect results.

Clients may have more than one a/c but the weekly amount may change but
I estimate that about 60% of the data entered each week is the same as
the previous week. The data is then manipulated by a Pivot Table to
produce results/figures in other worksheets.

To reduce data input there is no need to enter a/c's which have a Zero
amount for that week; provided the a/c is already present in a previous
week.

Sorry if this seems a long post but I thought it best to try and
outline the current situation as best possible.

Thanks in advance again!


--
Spellbound
------------------------------------------------------------------------
Spellbound's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32697
View this thread: http://www.excelforum.com/showthread.php?threadid=526059

.

Relevant Pages

  • f0dders fabulous folly.
    ... its target audience that the mistakes being sold by f0dder are not ... Following is the test program that proves this very clearly. ... proof that prototype duplication of an API ... IAT Entry ...
    (alt.lang.asm)
  • Re: Inserting multiple rows in one entry
    ... I believe I understand "what" you are trying to do (insert multiple rows in ... solve by having all the duplication of values your post implies? ... > Once the 1st entry is recorded in the table, I compute the next 7 rows ... > cause unnecessary problems because the Registration_ID is the most key ...
    (microsoft.public.access.formscoding)
  • Re: Query to duplicate last entry
    ... If you look at the results you want, you are duplication names, IDs ... Applications ... Your table looks to be incorrect. ... I need to duplicate the last entry in a table. ...
    (microsoft.public.access.queries)
  • Re: Inserting multiple rows in one entry
    ... It sounds like there is a duplication involved but actually there is not. ... just went back and checked the database table how the data is stored. ... >> Access Gurus, ... >> Compute for 2nd entry: ...
    (microsoft.public.access.formscoding)