appendquery

[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

 

[Hunter57]

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

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

Hunter57
http://churchmanagementsoftware.googlepages.com

 

[Arvin Meyer [MVP]]

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.