Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by tlj232

  1. tlj232


    I have a field in an Access database table that holds a decimal (9,2) - dollars and cents. I need to analyze only the records where the cents are greater than .00. I have tried splitting the data field but am unable to identify the correct SQL query commands to do this - any suggestions? I have tried the split() function, but no luck. Any advice will be greatly appreciated. Thank you
  • Create New...