Check out this thread:

You will need a Postgres database to be able to use these queries

Yes. If you DB is in postgres, there is a "query" you can easily run. I can post it. However, if you're just in Access, I don't have the query.

Yep, I have postgres database.

I'm at my work computer, so I don't have the tools here, but is it pretty self explainitory on running the query? Do I do this in PokerTracker?

Also, I want to see these stats:

Total Number of Pocket Pairs:
Pocket Pairs that saw a flop:
Flopped Sets:

Will the query in the above link do this for me?

Thanks

I sure miss AP10 those queries are great. All of the one's in the ptracker forums need access to work. Although there is a workaround to get the access queries to work in an SQL database, using this method is far superior. This took me a little to figure out so I might as well break it down here.

To run the queries in postgresql:

1) You need to open up pgAdminIII it's a program, most likely found in the start menu under "postgresql 8.0".

2) Then you have to double click the line that says "postgresql Databse server 8.0" it will initally have an "X" on the icon. A little dialog pops up prompting you for the password you used when installed postgre.

3) Then after you login to the database just click the icon that looks sorta of like a pencil and says "sqL" located on the upper row about 1/2 wa over. This will open another window. Just copy paste the query directly from the forum into that window.

4) You might want to change the date, but if you are simply looking for a running total then you can run it as it is. To do that click the little triangle icon, hit F5, or goto the query menu and click execute.

5) Depending on the size of your database it might take awhile. Another thing that might lead to confusion is the player ID it's looking at. There might be a way in the SQL itself to set the player ID, but i haven't figured it out. The way I get around this is simply changing my player ID in pokertracker itself. For example if I wanted to run queries on my account "TheMoose" I would go into pokertracker---> preferences ----> and then change automatically display my stats, my player id is: ---> TheMoose.

Anyways hopes that helped.

-Moose