What am I doing wrong

[uwish7]

I created an expression from tables. in the formular, I referenced the tables. See below on DailyUsageForecast. I want to take the daily forecast below and multiply it by 7. Must I reference a table? I received an error when I did not. I am not sure what table to reference since it is the same query
DailyUsageForecast([c].[RM_Usage_Percentage])/100*IIf(IsNumeric(.[Forecast]),.[Forecast],0))/.[DaysInMonth]

 

[Joe4]

You would need to use the Table Reference if the particular field name exists in both Tables used in the query (so there would be ambiguity if you left it out).
Are both tables actually in the query?

If you are having trouble figuring it out, it may be helpful if you switch your query to SQL View, and copy and paste the code here for us to see it.

 

[uwish7]

You would need to use the Table Reference if the particular field name exists in both Tables used in the query (so there would be ambiguity if you left it out).
Are both tables actually in the query?

If you are having trouble figuring it out, it may be helpful if you switch your query to SQL View, and copy and paste the code here for us to see it.

didn't add a "

SELECT a.Day AS Week, b.Plant, b.Component, b.Description, b.WeeklyUsageForecast AS WeeklyUsageForecastFromMonthly, b.[HALB/KMAT Material], b.Month, b.DailyUsageForecast
FROM (daysWeeks AS a INNER JOIN ForecastCalculations AS b ON a.Month = b.Month) INNER JOIN UserInput ON (b.Plant = UserInput.Plant) AND (b.Component = UserInput.Matnr)
GROUP BY a.Day, b.Plant, b.Component, b.Description, b.WeeklyUsageForecast, b.[HALB/KMAT Material], b.Month, b.DailyUsageForecast, b.RM_Usage_Percentage, b.Forecast, b.DaysInMonth, b.WeeksInMonth, b.MonthlyUsageForecast;

 

[Joe4]

didn't add a "

Not sure what you are saying there.
Do you mean that you found the problem?