You should be able to connect to mdb files from SQL Server using Jet 4.0 and then query those, including creating new tables based on the data in the tables...

Oh wait... if you have a version working in SQL Server, why not just upgrade that or move it to the 2014 or whatever instance... backup on 2008, move file...

Is it accdb format or mdb?

MDB uses Jet, and that seems to work. you haven't provided enough information to help you though.

Maybe try utteracces.com  - that's an Access site and...

"Living with Broken Software"... Sounds like every day using PowerBI. They've been working on it for like 10 years and it's STILL broken. when I start creating a measure the...

LOL.

No, the point of that is so that people trying to help can have some data to work with. That's just template code... doesn't actually insert any records.

Care to explain? What do you get when you run it? Works for me.

Be specific. Show what you get.

Can't fix code we can't see.  Can you post the CREATE TABLE and then CREATE INDEX scripts?

have you read Itzik Ben-Gan's "T-SQL Querying" yet? (And it's not a book you just read. You read, and write and run queries on the sample database). Then once you...

Nerd topics are an interesting "place" to learn to write better.  I remember several years ago revisiting a question that I first came upon when I was using Access (before...

Oh, like that! I was going to say this question reminded me of the "Which pilots can fly all the planes in the hangar?" question from SQL for Smarties (I...

CREATE TABLE and INSERT scripts?

Wouldn't you have to "explode" the kits so that they return their component parts and union that with the non-kit records, and finally sum that? Or...

DATEFROMPARTS?

I'd think this is such a bread and butter kind of thing that HR has to do that someone has already written an application that does this. And since they...

0 PRECEDING?

isn't that CURRENT ROW?  Doesn't matter to me, but if you can write the query in a standard way, it's easier for people to understand what your code is...

• This reply was modified 2 years, 9 months ago by pietlinden.

Maybe I'm just not seeing it. Are you just trying to create a running total?

You need a windowing function to do that...

SELECT trID,
DiffAmt,
rt = SUM(DiffAmt) OVER (ORDER...