Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. souladventurer

    dateadd not working

    Hello, I have the following SQL in the where statement, I do not receive an error but the query does not return any data. DATABASE.[DATE BILLED SS] BETWEEN DATEADD("d",-90,DATE()) AND DATEADD("d",-300,DATE()) any suggestions on how to make this work? Thanks!
  2. souladventurer

    Determine date field that is 90 to 180 days ago

    Hello, I have a date field. I need to generate a query that only picks up dates that are between 90-180 days old. I tried the following in the criteria but it did not work: (date()-[tablename.date field]) between 90-180 Thanks in advance for any help!
  3. souladventurer

    Supress zero values based on value of other fields

    Hi, My original question was answered, thanks! New Question. I have 3 currency fields, ex.fields a,b,c. I need the query to hide rows under the following conditions: when a,b,c all have zero values when a has a value but b and c are zero when b has a value but a and c are zero etc. Thanks...
  4. souladventurer

    Supress values = $0.00

    I have a currency field in a table. The default value is $0.00 I need the query to hide values where the field equals $0.00. I tried placing <>&quot;0.00&quot; in the criteria but recieved a datatype mismatch error. Thoughts? Thanks!

Part and Inventory Search

Back
Top