S
skc
Hi,
I have two .asp pages, the second .asp page saves values
from the first .asp page into my access2000 table.
The table basically accepts names, e.g. John, George etc
and I have defaulted a field called occurences to 1, so my
table takes the field headings of: ID (autonumber), Name,
Occurences, Timestamp.
When another name (that already exists) e.g. John, enters
the table then I want to increase the occurence by 1 and
delete the already existing John, as I now know that there
are 2 Johns anyway.
Please help on the custom SQL I need to put into DRW.
Thanks.
I have two .asp pages, the second .asp page saves values
from the first .asp page into my access2000 table.
The table basically accepts names, e.g. John, George etc
and I have defaulted a field called occurences to 1, so my
table takes the field headings of: ID (autonumber), Name,
Occurences, Timestamp.
When another name (that already exists) e.g. John, enters
the table then I want to increase the occurence by 1 and
delete the already existing John, as I now know that there
are 2 Johns anyway.
Please help on the custom SQL I need to put into DRW.
Thanks.