Search results

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 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...