appendquery

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an append query to add data to a table.
I would like that only the data gets added where in the clientnumberfield is
staying a clientnumber.
Something like: everything which is <0.
Can someone tell me how to write the Criteria?
Thanks
Klaus
 
I have an append query to add data to a table.
I would like that only the data gets added where in the clientnumberfield is
staying a clientnumber.
Something like: everything which is <0.
Can someone tell me how to write the Criteria?
Thanks
Klaus
Click to expand...

You can get better help if you post your query's SQL so we can see
it.

Hunter57
http://churchmanagementsoftware.googlepages.com
 
Just add <0 to the criteria box in the clientnumber column. That sounds too
easy. If the answer isn't what you need, try being a bit more descriptive in
your question.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

command code 5
Create "One" Record from the "Many" Table 5
need to delete records 1
Format a table field 2
Copy non-duplicates from new file to existing file 1
Queries 4
Append Queries 1
Append only new records with an append Query 1

Back
Top