Recent content by carlton123

Hi thanks for your reply but there is no Pos in any table that is the result of the Dcount inside the query

I have a Query that returns it only shows Velocity when PB = true Pos is an expression: Pos: DCount("[Velocity]","[TABLE]","[Velocity]<=" & [Velocity]) Velocity Pos 100 1 130 4 150 6 From a Table Velocity Velocity PB 100 true 110 120 130...

thanks that's great it works, thank you everyone that helped also

Owner Race Position RJC 1 1 RJC 1 2 GWA 1 3 RJC 1 4 TGR 1 5 TGR 2 1 GWA 2 2 GWA 2 3 RJC 2 4 Results required Owner Race Min...

yes its very relevant as that's what my query is trying to do, I can get the first position of each owner in each race but I want to rank the owners against each other, that's the bit i am struggling with.

The trainer or owner can have more than one horse in a race

its pigeon racing you can enter as many as you want similar to horse racing

Thats what it looked like when i pressed submit

Will it be possible? If i group on member and race then i just need to have a custom field that then puts a position next to member that's what I'm struggling with

Sorry i find it hard to explain myself a member can have more than one position in each race so one member could come 1,2,3,4 so the member who cam position 5 would need to be member number 2

table structure problem? im not sure what you mean its not exactly as it is i just simplified it when i pasted it it was in columns and its showing in a line now. basically its a results database the table holds RACE,MEMBER,POSITION other things that are not required for query I want the top...

I'm looking to get the top four Members in each race from this Data Race Member Position 1 GWA 1 1 GWA 2 1 RJC 3 1 GWA 4 1 TE 5 1 IW 6 1 PY 7 1 RJC 8 1 PJ 9 1 GT 10 2 RJC 1...

= " & Cdate([TB_CAL_Date]) & " this works!

tried suggestions struggling with this!

I have a SELECT stament which works "SELECT Bookings_Table.Booking_Time, Bookings_Table.Num_Slots, Bookings_Table.Booking_Date FROM Bookings_Table ORDER BY Bookings_Table.Booking_Time;"but when i add the WHERE "SELECT Bookings_Table.Booking_Time, Bookings_Table.Num_Slots...