I have a database which contains 1 datatable which is imported from excel on a weekly basis. I have then used Access to seperate the data by using a number of queries and produce repots on these.
What I want to do is have a form which details the 'headline' data. which updates on form load.
One of the fields I want on the form is the number of records which match a certain criteria. Using the Help and looking through these hallowed forums Dcount would appear to be the function to use. But try as I might I can't get it to work.
I've created a text box on the form and put the following as its control source
=DCount(WorkingDataTable!STATUS_1,[WorkingDataTable],WorkingDataTable!STATUS_1="TO")
using the expression builder however the text box always shows #Name.
WorkingDataTable is a query
STATUS_1 is the field which has the data i want to query against. ie it contains TO
Any help would be appreciated, as it is now driving me mad.
What I want to do is have a form which details the 'headline' data. which updates on form load.
One of the fields I want on the form is the number of records which match a certain criteria. Using the Help and looking through these hallowed forums Dcount would appear to be the function to use. But try as I might I can't get it to work.
I've created a text box on the form and put the following as its control source
=DCount(WorkingDataTable!STATUS_1,[WorkingDataTable],WorkingDataTable!STATUS_1="TO")
using the expression builder however the text box always shows #Name.
WorkingDataTable is a query
STATUS_1 is the field which has the data i want to query against. ie it contains TO
Any help would be appreciated, as it is now driving me mad.
