Use dcount in a query

[tagteam]

I am trying to use a totals query with a count of records as the field value in another query.

I tried to do it like this

RecordCountcount("myfield", 'myquery")



However that doesnt work. What is the best way to do this?

[ranman256]

you dont use Dcount in a query, the query does the counting.

but if you want to use Dcount in a form:
Dcount ("*", "queryname")

[tagteam]

Sorry, typos

RecordCountcount("myfield","myquery")

The query will run fine but it does not update the RecordCount field in the table

[tagteam]

Ok, I don't need it in a form.
I am updating a table that has two rows. I update some customer information but then I need to update the RecordCount, Total Labor and Total Materials from a different totals query.

How can I pull the vaules from that query into this query?

[tagteam]

Silly emoji thing, have to put it in code

RecordCount:Dcount("myfield","myquery")