Search results

  1. N

    DCount to add sequential numbers by group only works in some instances

    Well, I went in and grabbed a sampling of the data that was producing the correct results, and also some that wasn't, but when I re-ran the query the behavior was as I desired on all of the records. Then i went back to my full data source, and it's working there, now, as well. I didn't change...
  2. N

    DCount to add sequential numbers by group only works in some instances

    Banging my head against the wall. I have a large table (>1M rows), and I have searched various forums for a way to add sequential numbers by Group. The query I have works, but since it's a large table, I broke it up, and did everything what starts with A-E, the F-Q, etc, and appended to a new...
Top Bottom