Search results

Dcount("[Team]","1743","[Type]='REG Compromised TFN' AND [Status]='Information Pending' AND [Priority]='3-Medium' AND [Cmplxty]='Low'")The name of the Table is - 'Holdings' The Field names within the table are - 'Team' - 'Type' - 'Status' - 'Priority' - 'Cmplxty'. The original report is imported...

This is the DCount I tried in the RecordSource of a Text box on the report # =Dcount("[Team_Id]","1743","[Acty_Cntct_Typ_Nm]='REG Compromised TFN' AND [Intractn_Sts]='Information Pending' AND [Acty_Priority]='3-Medium' AND [Acty_Cmplxty]='Low'") # I have obviously a lot to learn about Access but...

The report needs to show a number of counts on the one page. I originally had the report sourcing from a number of queries but there was just too many queries and I hadn't even completed all the criterion. The report is a daily listing of the work I have on hand, so the counts will change each...

I have a Table that contains Headings/Criteria such as Team * Type * Status * Priority* - The data could be 1753 - NEW - Medium - Low 1753 - ADD - Medium - High 1744 - NEW - Standard - ASAP - How can I count the records that match the required criteria (eg: 1753 - NEW - Medium - High) from a...

Is it possible to place the SQL I have for a query into a report? I have a query that counts the number of records within my table. The total is then needed to be placed in a report. There are quite a number of tese queries. So the end result is that a reoport will show the totals of each...

I have a report that shows the total number of entries for each criteria. I have based this upon numerous queries. Is there a formula I can enter into the report fields that will count the entries directly from the Table. The fields are Team Id, Status, Complexity & Priority. A sample of the...

They are all taken from the one table. EG: The fields are - Team Id, Activity, Status, Priority and Complexity. The only field that I need to change in each query is the Team Id (eg: 1744, 1746, 32477 etc.). The others stay the same. Thank you in advance for any guidance.

Hi I am using Access 2003. I have created 50 Select queries that have all the same fields except for one. I copied and pasted the query each time and changed the one field for each copy thus ending up with the 50 queries. I was wondering if there is a simpler way to do this. I have very limited...