Search results

Problem solved ! I realised that the reason for the control not working was that the query it was referring to had stopped running. Opening the report runs the query but the control appears in the report footer. I changed the query to a make-table query then based the report and control on the...

Thanks Harry, I've tried creating a new query as you suggest which just selects the results of Query 3 and the control still doesnt work. Query 3 is not complex, it selects records between two dates which have results of a survey returned. I then want to be able to count how many records...

Thanks Pat. I have tried this and it still doesn't work. I have checked the field references again and they appear to be correct.

I am trying to use the DCOUNT function in a report. I want to display the number of contracts selected by a query, Query 3, which have a value for the field 'Pre-tender' of 4. I have entered the Control Source for a textbox as follows : =DCOUNT("[Contract Name]","Query 3","[Pre-tender]='4'")...

I have added a hidden textbox and revised the criterion in the query as you have suggested. It now works a required. Many thanks.

I have tried to enter the suggested code in the SQL for the query but I can't get the syntax correct. I have tried the following : GROUP BY [CCDT].[CUSNAM]Part: Left([CCDT].[CUSNAM],5) and I get an error message 'Syntax error (missing operator) in query expression' and it highlights the...

Thanks, I'll try this tomorrow. Regards the Primary key, this would not be easy as the data already exists in another database from which it is imported and the customer names are used for addresses eg McAlpine Construction, McAlpine Pipelines, etc. but for the present purposes I wish to group...

I have a query which takes information from an input form. On the form is a combo box based on a table with 3 fields - ID, Division, Criterion. To select records for a particular division, the 'Division' is selected in the combo box but I want the 'Criteron' field to be used in the query. The...

I am trying to design a query to total income from a number of contracts grouped by customer name. I am working in Design View as I am not able to code in SQL. I have set the the 'total' row to count numbers of contracts and total income grouped by Customer Name but the name may be slightly...