Recent content by jotb

Hello GOL4: Thank you for the taking the time to help. Best regards, Joe

Hello Ginger: What can I say? You are the best! Thank you for helping me understand somewhat this difficult language. Horse racing is my gift but computers are another story. At least I'm done with my first step towards developing my own "speed figure ratings". The second step of...

Hello Ginger: I changed the DST COL by using &quot;where&quot; instead of &quot;group by&quot; and unchecked the DST COL as you requested. In the criteria, I typed in <=8 and ran query. The calculation was perfect. One small problem! How can I run the query at the same time for >=9 without...

Hello Ginger: You are a life-saver! I omitted the DIFFB and DIFFA1 from the query and yes, I retrieved the results that I was seeking. How could I group certain distances in the distance field? I ran the query but in the distance field, I typed in 6.0. The results were perfect. Then I...

Hello All: I created a query in design view. I used the following fields: Date,DST,DIFFB,DIFFA1 and [DIFFB]-[DIFFA1]. I typed in a specific date and DST in the criteria. I ran the query and the new field expr1 calculated the differences using that expression [DIFFB]-[DIFFA1]. There were 5...

Hello All: Please provide me with step by step instructions. Thank you in advance, Joe

Hello: I'm sorry but, is it possible for you to provide me with step by step instructions. My experience with query functions is limited. Please help me with this. Regards, Joe

Hello ALL: I was wondering if it's possible to query the following and if yes, what type of formula is needed? Here is an example of my database fields and type of data DATE (FROM 06-DEC-00 TO 20-APR-03) Each date has up to records. TRK Text AQU,BEL,SAR) SUR Text (M,ID) SEX...

Hello Dodge: I found another way. Using the wizard, I put in the 4 fields (track,distance,first fraction,surface)and clicked on summary options. Instead of using average, I clicked on sum and checked count records. In design view, I put in the criteria for track (aqueduct), surface (main)...

Hello: I'm losing my mind with this. Here is what I did exactly. I selected a query in design view. I added the table and closed out of the box. In design view in the first row, I dropped down to field and put in (track). I proceeded to the next row and dropped down to field and put in...

Hello Foolio and Dodge: This did not work for me. Within the (DST) field, I have other data types like 8.0, 8.5, 9.0, 10.0. I just want to use 6.0, 6.5. and 7.0. In order to perfom this query I need to use the following fields: (TRK), (Sur), (dst) and (1fr) In the criteria I use AQU for the...

Hello All: I need to find an average. Within one field I have data that is as follows: 6.0, 6.5 7.0 (FIELD NAME IS DST). Another field called 1FR has data like 2154, 2212, 2346. I previously ran a query using the field (1FR) and the fIELD (DST).When I averaged the datasheet view had an...

Hello Ginger: Happy Holiday! Thank you for all your help. I will be adding new data each week in the correct format. I entered the data previously in error. However, today I converted the data correctly. I performed the query from the instructions you gave me. I ran the query then cut the new...

Hello Ginger: After I send the above reply, I went back into access and tried once more. I made a new query and the first field was distance only for 5.5F and second field was final time. In the third column I put in that formula and clicked on datasheet view and the times changed. It worked...

Hello Ginger: I messed up again! The field type is named FINAL TIME but final times can range from 58.10 seconds to 154.75 or 114.75 seconds. If course this depends on the distance which is my other field. Distances will range from 5.0 Furlongs to 12.0 furlongs. If I want to change all the...