I have 2 problems in the reports I am creating:
1. I am using a calculated text box to work out summaries. here is my code:
=DCount(AppointmentOutcome","CUSTOMER","AppointmentOutcome='ACTING'")
This code works fine and returns the total number of customer we are acting on behalf of.
However I need to be able to specify dates aswell. I have tried to use a query to specify dates, then take results from this query and use it in my calculation (i.e. I swopped the table name CUSTOMER for the query name CALCULATION. But it does not recognise this query name.
I would either like it to recognise my query name (am i using wrong syntax?)
Or to add a condition to the end of my calculation stating 'and date = Like **/07/2000' - I actually need to specify the month of that date.
2. the other problem I am having is the report is not showing all the records. I suspect this is because of my relationships. I have 3 tables involved in this report, the main one being customer. From here I have a one to one relationship with the acting table and a one to one relationship with the not acting table.
However, I wish to print a report listing all customer details, then selected details from acting and not acting. the results I actually get are only the records which have both acting and not acting details, the rest of the customers are not there.
Can anyone help me with any of this please? i am getting very disheartened.
SARAH
1. I am using a calculated text box to work out summaries. here is my code:
=DCount(AppointmentOutcome","CUSTOMER","AppointmentOutcome='ACTING'")
This code works fine and returns the total number of customer we are acting on behalf of.
However I need to be able to specify dates aswell. I have tried to use a query to specify dates, then take results from this query and use it in my calculation (i.e. I swopped the table name CUSTOMER for the query name CALCULATION. But it does not recognise this query name.
I would either like it to recognise my query name (am i using wrong syntax?)
Or to add a condition to the end of my calculation stating 'and date = Like **/07/2000' - I actually need to specify the month of that date.
2. the other problem I am having is the report is not showing all the records. I suspect this is because of my relationships. I have 3 tables involved in this report, the main one being customer. From here I have a one to one relationship with the acting table and a one to one relationship with the not acting table.
However, I wish to print a report listing all customer details, then selected details from acting and not acting. the results I actually get are only the records which have both acting and not acting details, the rest of the customers are not there.
Can anyone help me with any of this please? i am getting very disheartened.
SARAH
