If you could explain what fields are in your table, and what you want
discounted, and in what context you want this, someone might be able
to help. The numeric value in the table field is COMPLETELY irrelevant
to the syntax of the query, of course.
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.