Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
copy help
0 views
Skip to first unread message
janbok
Jan 29, 2000, 3:00:00 AM1/29/00
to
how can you make the append query work ?
i have a auto number in field 1 if you make a remove query it works
i you want that data to a other dbase no way i even try to put the
number 1 field to
number instead of autonumber but nope
i select the data by query one a date if that is filled copy to dbase
xxxx
than remove that data from the orginal dbase as stated the remove works
why not the copy ????? i tryed with a copy renamed of the old dbase but
nope
i have a auto number in field 1 if you make a remove query it works
i you want that data to a other dbase no way i even try to put the
number 1 field to
number instead of autonumber but nope
i select the data by query one a date if that is filled copy to dbase
xxxx
than remove that data from the orginal dbase as stated the remove works
why not the copy ????? i tryed with a copy renamed of the old dbase but
nope
Access This
Jan 29, 2000, 3:00:00 AM1/29/00
to
I'm gonna take a wild guess here...
Test your append query without any number fields to see if that is really
where the problem lies.
If it runs okay, then:
Do not include an autonumber field from the second table (the table you are
appending to) in your append query.
If you want to append the Autonumber field from your first table, make sure
the field you are appending to is set to Long Integer data type
Good Luck!
@
0 new messages