Make table query results

[Bob]

How do I create a table without zerro (0.00) amounts.
I have tried setting up a not 0 requirement in the query but the zerro
amounts still come through.
I hope this is enough info for a solution, if not let me know.
Thanks for any help on this subject
Bob

 

[Rick B]

What are you using to create the table? We need a lot more details. If
your query does not pull records with a zero value, then the new table can't
contain them.

In general (though not always) you should rarely need to use a "make table"
query. If you are scaling down the items fro a table in your query, then
you can normally use that query as the record source for your forms and
reports. It is rare that you would need to store the results in a new
table.

Post more details and we can give you specific guidance.

 

[Bob]

I have a data input table that is partially cleared on a monthly basis.
Customer invoices are hand entered into this table during the month. This
data is used for billing purposes at month end.
The new table being created w/the query brings fwd the previous months left
over(billed amounts that were not paid in full).
It is in this table that I would rather not have zerro customer amounts
brought forward.
The data in this new table is held untill the removable data is cleared, it
is then abended to the origional customer invoice table for the next months
billing cycle.
Bob

 

[Rick B]

If it were me, I'd keep all the data in one table. My queries and reports
would decide who had balances and who did not.

Not sure why you'd want to move records around and delete data like this.
Maybe one of the other members of the group will have some suggestions for
you though.

 

[Bob]

Thanks rick
Those are interesting thoughts, I do follow that proceedure with other
access operations but am not sure I can rearange this one w/o a lot of extra
hassel.

I appreciate the help I have gotten on this site.
Bob