Search results for query: *

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.

How can I make the Combo box item selectable? Is there a property for making the Combo box item selectable? Help np3il

ZmrAbdulla & abaldwin Thanks for the suggestions. I used the On Timer event and set the TimerInterval to 1. On Timer comand: Forms!fsumParking.txtTime = Str(Time()) Thanks Np3il

Is there a function in Access to display the Time at run-time or to view the system time including seconds? Ex. hh:mm:ss and displaying every second like a clock. Is there a function to do this in Access? Thanks Np3il

Hello All The requery method did not work but I found another way. In the Subform (using multiple subforms): 'Close Subform Form!fsumParkSub.SourceObject = "" 'refresh DoCmd.RunSQL "SELECT AllEmp.* INTO tmasEmployee FROM [SELECT * FROM Employee0405 UNION SELECT * FROM Employee0506]. AS...

I agree but it is not the case that I am having. Ex. A SubForm has a query for the source and I add a new record to on of the tables. Maybe the question should be: How can I run an existing query from code (that create a working table that is composed of two other tables)??? I hope I have...