Recent content by np3il

Thanks lameid for the clarifications. But I need the Day Shift Average Totals displayed separate from the Night Shift Average Totals and the Entire Day/Night (All) Shift Average Totals. If you observe the above SQL statements are the actual SQL I have for the individual queries. I tried the...

Thanks, I was able to UNION the SQL Queries except that Access is not allowing me to run the third SQL statement in the newly created Query. I need to combine 9 Queries together in 1 report. Been testing the UNION of 2 SQL Queries and works great, but when I add the third SQL ... BOOM ...

The SQL for "All Shift Avg" SELECT Sum([Driver-Data].GrossProfit)/16 AS SumOfGrossProfit, Avg([Driver-Data].GrossProfit) AS AvgOfGrossProfit, Sum([Driver-Data].[Shift Time])/16 AS [SumOfShift Time], Avg([Driver-Data].[Shift Time]) AS [AvgOfShift Time], Sum([Driver-Data].Mileage)/16 AS...

Hello I am trying to create a report from multiple queries. The queries are already created and working. How can I combine these queries into One Report? Queries: 1. Day Shift Avg Totals 2. Night Shift Avg Totals 3. All Shift Avg Totals 4. Location1 Totals 5. Location2 Totals 6. Location1 Day...

I implemented your suggestion and re-created the report. It worked ... :) Thnaks !!!

The query is orking fine. Where in the Report can I modify the SQL statement?

SQL View: SELECT Drivers.DriverID, [Driver-Data].DriverName, Drivers.Shift, Drivers.LocationID, Count(Drivers.NickName) AS CountOfNickName, Sum([Driver-Data].GrossProfit) AS SumOfGrossProfit, Avg([Driver-Data].GrossProfit) AS AvgOfGrossProfit, Sum([Driver-Data].[Shift Time]) AS [SumOfShift...

The Report was created from the Query. The query was created using Query Wizard. I did not use any SQL statement. Report Sections Detail ----- SumOfGrossProfit ------- Should I add additional Criteria in the Query Wizard? Should I replace the Report Detail of the SumOfGrossProfit to...

1. Created the Query and it is running fine. Created with Query Design. 2. After creating the Report for the query, some fields are asking to enter data, when that data is gathered by the query. 2a. The report was created by using the Report Wizard from the Access 2010. 2b. The file that was...

I have created many Queries in Access 2010. When I create the report of the query, some fields are asking me to enter data when the data is Sum and Avg by the query. what am I doing wrong?

PHV & Remou Thanks for the suggestions

What property is the one to figure out if the check-box is cheked or not?

ZmrAbdulla The AllowEdits=Yes took care of the problem. Thanks np3il HarleyQuin There was no code here, yet.

The combo-box is the only control in this form. the record-source of the form is empty.

I also looked at that one. The Locked Property is set to "No". I run the Form and when I try to select an Item from the combo box list, the item is not being selected.