<div>
That also assumes that Fiscal_Week is numeric. &nbsp;If it is text: 
 
Total_Wks: DCount(&quot;*&quot;, &quot;Q_Calc_New_FM_Store_Adjustment&quot;,&quot;Forecast_Amt&lt;&gt;0 And Fiscal_Period = &quot;&nbsp;&amp; CHR(34) &amp;&nbsp; T_Data_Forecast_Master_Temp]![Fiscal_Week] &amp;&nbsp;CHR(34)) 
 

</div>

That also assumes that Fiscal_Week is numeric.  If it is text:

Total_Wks: DCount("*", "Q_Calc_New_FM_Store_Adjustment","Forecast_Amt<>0 And Fiscal_Period = " & CHR(34) &  T_Data_Forecast_Master_Temp]![Fiscal_Week] & CHR(34))

<div>
<div class="content wysiwyg-content">
Hello, 
 
I have a query where I would like one field to return the count of records that have the same field value as the current record. &nbsp;For example, my query contains 9 records, 5 of those records have one fiscalwk value and the other four have a different fiscalwk value. &nbsp;I would like to return a 4 or a 5 depending on the fiscalwk value. &nbsp;Currently, I'm using the following dcount expression 
 
Total_Wks: DCount([Forecast_Amt],&quot;Q_Calc_New_FM_Store_Adjustment&quot;,[Forecast_Amt]&lt;&gt;0 And [T_Data_Forecast_Master_Temp]![Fiscal_Period]=[T_Data_Forecast_Master_Temp]![Fiscal_Week]) 
 
The value is returning all 9 weeks for each record instead of the 4 or 5 depending on the actual recrods with that fiscal week. 
 
Any assistance would be greatly appreciated. 
 
Thanks, 
 
Tbyrd
</div>
</div>

Hello,

I have a query where I would like one field to return the count of records that have the same field value as the current record. For example, my query contains 9 records, 5 of those records have one fiscalwk value and the other four have a different fiscalwk value. I would like to return a 4 or a 5 depending on the fiscalwk value. Currently, I'm using the following dcount expression

Total_Wks: DCount([Forecast_Amt],"Q_Calc_New_FM_Store_Adjustment",[Forecast_Amt]<>0 And [T_Data_Forecast_Master_Temp]![Fiscal_Period]=[T_Data_Forecast_Master_Temp]![Fiscal_Week])

The value is returning all 9 weeks for each record instead of the 4 or 5 depending on the actual recrods with that fiscal week.

Any assistance would be greatly appreciated.

Thanks,

Tbyrd

MS Access, Dcount, Multiple Criteria

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.