Jump to content

tlj232

Members
  • Content Count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About tlj232

  • Rank
    Newbie
  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...