User Profile

Collapse

Profile Sidebar

Collapse
cococrunch89
cococrunch89
Last Activity: Jan 3 '14, 02:10 AM
Joined: Dec 17 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • cococrunch89
    replied to Obtain unique data sets (rows)
    in Access
    Here's how my data looks like now
    Code:
    [SP].Series, [SP].Time, [SP].BidorAsk, [SP].Price, len[series]
[SPJ14][11:23:20][Bid][200][5]
[SPJ14][11:23:20][Ask][205][5]
[SPK14][11:23:20][Bid][200][5]
[SPK14][11:23:20][Ask][205][5]
[SPJ14-SPK14][11:23:20][Bid][10][11]
    so when the time is the same such as in the sample data above, I want to hide/delete the series-SPJ14 and SPK14 and just show...
    See more | Go to post

      Leave a comment:

    • cococrunch89
      started a topic Obtain unique data sets (rows)
      in Access

      Obtain unique data sets (rows)

      hi,

      Can anyone help with this? Something seems to be wrong except I cant figure out what it is.

      I am trying to sort my data such that if [SP].time has appeared when [SP].series = "SPJ14-SPK14" then the data for the other 2 series will not show up. i.e. SPJ14 and SPK14. In other words, the time is unique.



      Code:
      SELECT DISTINCT Last([SP].Series) AS LastOfSeries, [SP].Time, [SP].BidOrAsk,
      ...
      See more | Go to post
      No activity results to display
      Show More
      Working...