Dcount or Similar

[carlton123]

I have a Query that returns it only shows Velocity when PB = true

Pos is an expression:
Pos: DCount("[Velocity]","

","[Velocity]<=" & [Velocity])

Velocity Pos
100 1
130 4
150 6

From a Table Velocity

Velocity PB
100 true
110
120
130 true
140
150 true
160

I want to use Dcount or something else to show

Velocity Pos
100 1
130 2
150 3

TIA any help would be hugely appreciated

 

[arnelgp]

select Velocity, Pos From yourTable1 Inner Join [Velocity table] On [yourTable1].Velocity = [Velocity Table].Velocity Where ([Velocity Table].PB = True)

 

[carlton123]

select Velocity, Pos From yourTable1 Inner Join [Velocity table] On [yourTable1].Velocity = [Velocity Table].Velocity Where ([Velocity Table].PB = True)

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

 

[James Deckert]

you're asking for a normal select query with TRUE in the criteria row of the PB field.

 

[arnelgp]

Pos: DCount("[Velocity]","

","[Velocity]<=" & [Velocity] & " And PB = True")