append query and delet query

  • Thread starter Thread starter lena_form
  • Start date Start date
L

lena_form

I created one append query and one delete query with a “Criteria†= Like
[PILOT CREW ID]â€. In such a way first asset append query, that it adds
`record' in the archive table, and later delete query, that it erases
`record' of the table of the pilots. But what I intended is to activate the
two of a time alone, introducing the number just once, even because I have
distrust to deceive me when active delete query. What I can make?
 
I am unable to visualize your situation because I am unable to visualize
your data structure.

"How" depends on "watch..."

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
sorry, my fingers are faster (and dumber) than my brain...

that should have been "how" depends on "what"...

Jeff

Jeff Boyce said:
I am unable to visualize your situation because I am unable to visualize
your data structure.

"How" depends on "watch..."

Regards

Jeff Boyce
Microsoft Office/Access MVP


lena_form said:
I created one append query and one delete query with a "Criteria" = Like
[PILOT CREW ID]". In such a way first asset append query, that it adds
`record' in the archive table, and later delete query, that it erases
`record' of the table of the pilots. But what I intended is to activate
the
two of a time alone, introducing the number just once, even because I
have
distrust to deceive me when active delete query. What I can make?
Click to expand...
Click to expand...
 
I have a table with a list of pilots who use to add records in another table.
After, I remove the registration of the first table.
--
HC


"Jeff Boyce" escreveu:
I am unable to visualize your situation because I am unable to visualize
your data structure.

"How" depends on "watch..."

Regards

Jeff Boyce
Microsoft Office/Access MVP


lena_form said:
I created one append query and one delete query with a "Criteria" = Like
[PILOT CREW ID]". In such a way first asset append query, that it adds
`record' in the archive table, and later delete query, that it erases
`record' of the table of the pilots. But what I intended is to activate
the
two of a time alone, introducing the number just once, even because I have
distrust to deceive me when active delete query. What I can make?
Click to expand...
Click to expand...
 
Sorry, I'm still having trouble understanding what you are trying to do...

Regards

Jeff Boyce
Microsoft Office/Access MVP

lena_form said:
I have a table with a list of pilots who use to add records in another
table.
After, I remove the registration of the first table.
--
HC


"Jeff Boyce" escreveu:
I am unable to visualize your situation because I am unable to visualize
your data structure.

"How" depends on "watch..."

Regards

Jeff Boyce
Microsoft Office/Access MVP


lena_form said:
I created one append query and one delete query with a "Criteria" = Like
[PILOT CREW ID]". In such a way first asset append query, that it adds
`record' in the archive table, and later delete query, that it erases
`record' of the table of the pilots. But what I intended is to activate
the
two of a time alone, introducing the number just once, even because I
have
distrust to deceive me when active delete query. What I can make?
Click to expand...
Click to expand...
Click to expand...
 
Hello!
I want do apend a record in a table and, at the same time, delete it from
the original table.

Thanks
--
HC


"Jeff Boyce" escreveu:
Sorry, I'm still having trouble understanding what you are trying to do...

Regards

Jeff Boyce
Microsoft Office/Access MVP

lena_form said:
I have a table with a list of pilots who use to add records in another
table.
After, I remove the registration of the first table.
--
HC


"Jeff Boyce" escreveu:
I am unable to visualize your situation because I am unable to visualize
your data structure.

"How" depends on "watch..."

Regards

Jeff Boyce
Microsoft Office/Access MVP


I created one append query and one delete query with a "Criteria" = Like
[PILOT CREW ID]". In such a way first asset append query, that it adds
`record' in the archive table, and later delete query, that it erases
`record' of the table of the pilots. But what I intended is to activate
the
two of a time alone, introducing the number just once, even because I
have
distrust to deceive me when active delete query. What I can make?
Click to expand...
Click to expand...
Click to expand...
 
Ah...

Why? You might use this approach if you were limited to working with a
spreadsheet, but it isn't (or only rarely) necessary when working with an
Access database.

You've come up with a solution, i.e., "moving" the record. What is that a
solution for? If you'll describe a bit more specifically what having a
moved record will allow you to do, folks here may be able to offer a
simpler, more specific suggestion.

Regards

Jeff Boyce
Microsoft Office/Access MVP


lena_form said:
Hello!
I want do apend a record in a table and, at the same time, delete it from
the original table.

Thanks
--
HC


"Jeff Boyce" escreveu:
Sorry, I'm still having trouble understanding what you are trying to
do...

Regards

Jeff Boyce
Microsoft Office/Access MVP

lena_form said:
I have a table with a list of pilots who use to add records in another
table.
After, I remove the registration of the first table.
--
HC


"Jeff Boyce" escreveu:

I am unable to visualize your situation because I am unable to
visualize
your data structure.

"How" depends on "watch..."

Regards

Jeff Boyce
Microsoft Office/Access MVP


I created one append query and one delete query with a "Criteria" =
Like
[PILOT CREW ID]". In such a way first asset append query, that it
adds
`record' in the archive table, and later delete query, that it
erases
`record' of the table of the pilots. But what I intended is to
activate
the
two of a time alone, introducing the number just once, even because
I
have
distrust to deceive me when active delete query. What I can make?
Click to expand...
Click to expand...
Click to expand...
 
Hello Jeff.
I got it resolved the doubt.
Thanks
--
HC


"Jeff Boyce" escreveu:
Ah...

Why? You might use this approach if you were limited to working with a
spreadsheet, but it isn't (or only rarely) necessary when working with an
Access database.

You've come up with a solution, i.e., "moving" the record. What is that a
solution for? If you'll describe a bit more specifically what having a
moved record will allow you to do, folks here may be able to offer a
simpler, more specific suggestion.

Regards

Jeff Boyce
Microsoft Office/Access MVP


lena_form said:
Hello!
I want do apend a record in a table and, at the same time, delete it from
the original table.

Thanks
--
HC


"Jeff Boyce" escreveu:
Sorry, I'm still having trouble understanding what you are trying to
do...

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a table with a list of pilots who use to add records in another
table.
After, I remove the registration of the first table.
--
HC


"Jeff Boyce" escreveu:

I am unable to visualize your situation because I am unable to
visualize
your data structure.

"How" depends on "watch..."

Regards

Jeff Boyce
Microsoft Office/Access MVP


I created one append query and one delete query with a "Criteria" =
Like
[PILOT CREW ID]". In such a way first asset append query, that it
adds
`record' in the archive table, and later delete query, that it
erases
`record' of the table of the pilots. But what I intended is to
activate
the
two of a time alone, introducing the number just once, even because
I
have
distrust to deceive me when active delete query. What I can make?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top