Counting Records From Underlying Query With Unbounded Fields

[Chipcom]

Hi

I am trying to count records from underlying query with unbounded fields in the criteria and I get of course type mismatch.

[c] = DCount("[Dat]", "PTable", "[ShowMonth] = '" & Me.ShowMonth & "'" And "[ShowYear] = ' " & Me.ShowYear & " '" And [ENT] <> 0 And [EXT] <> 0)

When ShowMonth and ShowYear are unbounded fields .

Do you have any idea how to count records underlying query with underlying query ?

Thanks

 

[RuralGuy]

Maybe this link to ghudson's code will suggest some ideas.

 

[Chipcom]

Your post is not relevant

I am sorry but your post is not related to my question.

 

[RuralGuy]

Any RecordSet in Access has a RecordSet.RecordCount. Why do you feel you need to use DCount()?

 

[Chipcom]

Can you use RecordCount on my example above?

So

Can you use RecordCount on my example above?

 

[RuralGuy]

Is the query bound to the form you are working from? Does it have a filter as you have described in the DCount() line applied? What do you mean when you say

When ShowMonth and ShowYear are unbounded fields

since fields are not bound anyway, only controls are.

 

[Chipcom]

Any Idea?

Any Idea?

 

[RuralGuy]

Don't you want to answer my questions?

 

[Chipcom]

Any Idea

Any Idea??????