This article will go through the construction of a query for your PokerTracker database.
STEP 1: IF YOUR DATABASES ARE IN ACCESS FORMAT
Open Access. On the File menu, choose Open.
Go to the Poker Tracker directory. By default, c is: 'C:\Program Files\Poker Tracker V2\'.
You should see the above files. The file that interests us is 'ptrack.mdb'. If you have created d other database later, these will be called ptrack2.mdb, ptrack3.mdb, by default.
Open the file.
In the tabs on the left, select Queries. The image above contains already built queries. On your computer you will see that the first two icons.
Double click on "Create a query in design view.
You will then see the following window. C here is that your existing query construction would begin. On the other hand, as we already have the code, you can skip this step. Click on 'Close '.
You are now in the module for creating queries. Once again, c is here would you do your query the starting from scratch. We already have the code (see below). This code is code "SQL". To enter the code directly, click the SQL of the tool bar button. C is the first button on the left of the floppy disk. If "SQL" is invisible, click the arrow on the left of the vertical bar next to the disk and choose it from the list.
You will then see the following window.
Remove Select text, and paste the following text;
You will now be able to run the query. Or is found the "SQL" button, click the arrow and select the icon that looks like a grid Excel, or click the icon "run". You will then see the following window. Depending on the size of your database, this may take a few seconds.
Finally, click on the floppy disk to save the query. The next time you want to run the query, you n will have qu to click on it. And you will arrive directly at this last window.
This article will go through the construction of a query for your PokerTracker database.
Warning: Open your PokerTracker with Access database can cause unfortunate and irreversible effects. By opening the Access database, you have access to the heart of the PokerTracker database. If by mistake you erase something important d, PT could no longer work. It is therefore strongly suggested to make a backup of the database before l open with Access.
To use existing queries (such as those provided on PokerCollectif), n you not need special knowledge. The instructions below will suffice. On the other hand, if you want to build your own queries from scratch, it is strongly recommended that before practice with simple queries in one simple database other than PokerTracker.
Warning: Open your PokerTracker with Access database can cause unfortunate and irreversible effects. By opening the Access database, you have access to the heart of the PokerTracker database. If by mistake you erase something important d, PT could no longer work. It is therefore strongly suggested to make a backup of the database before l open with Access.
To use existing queries (such as those provided on PokerCollectif), n you not need special knowledge. The instructions below will suffice. On the other hand, if you want to build your own queries from scratch, it is strongly recommended that before practice with simple queries in one simple database other than PokerTracker.
STEP 1: IF YOUR DATABASES ARE IN ACCESS FORMAT
Open Access. On the File menu, choose Open.
Go to the Poker Tracker directory. By default, c is: 'C:\Program Files\Poker Tracker V2\'.
You should see the above files. The file that interests us is 'ptrack.mdb'. If you have created d other database later, these will be called ptrack2.mdb, ptrack3.mdb, by default.
Open the file.
Create a database in order to bind the data from Postgre by following the instructions here. Once complete, open the Access file that you just created.
In the tabs on the left, select Queries. The image above contains already built queries. On your computer you will see that the first two icons.
Double click on "Create a query in design view.
You will then see the following window. C here is that your existing query construction would begin. On the other hand, as we already have the code, you can skip this step. Click on 'Close '.
You are now in the module for creating queries. Once again, c is here would you do your query the starting from scratch. We already have the code (see below). This code is code "SQL". To enter the code directly, click the SQL of the tool bar button. C is the first button on the left of the floppy disk. If "SQL" is invisible, click the arrow on the left of the vertical bar next to the disk and choose it from the list.
You will then see the following window.
Remove Select text, and paste the following text;
You will now be able to run the query. Or is found the "SQL" button, click the arrow and select the icon that looks like a grid Excel, or click the icon "run". You will then see the following window. Depending on the size of your database, this may take a few seconds.
| SELECT gp.hole_cards AS Pair, count (*) AS Times, SUM) IIF (left(g.flop_1,1) = left(gp.hole_card_1,1), 1) IIF (left(g.flop_2,1) = left(gp.hole_card_1,1), 1) IIF (left(g.flop_3,1) = left(gp.hole_card_1,1), 1) 0))) AS [Flopped Set] FROM AS gp game AS g INNER JOIN game_players ON gp.game_id = g.game_id WHERE gp.player_id = (select pref_value from prefs where pref_key = 'RP') AND gp.pair_hand = 1 AND gp.saw_flop_n = 1 GROUP BY gp.hole_cards, gp.card_order1 ORDER BY gp.card_order1 DESC; |
Finally, click on the floppy disk to save the query. The next time you want to run the query, you n will have qu to click on it. And you will arrive directly at this last window.