Jump to content

tlj232

Members
  • Posts

    1
  • Joined

  • Last visited

tlj232's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. tlj232

    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...