Your query may have columns that shouldn't be included.  If you need to aggregate the hours based on equipment, the aggregate query should essentially have only two columns: equipment and hours.  E.g.:

    SELECT Equipment, Sum(Hours) FROM MyTable GROUP BY Equipment;

An aggregate query should only have group-by field(s) and summation field(s).  Any other columns you put in would affect the result.

Thanks Kevin, the for the help, the SQL Code work perfectly. But I have "EmployeeID" and "CrewID" saved in the Table. I keep getting an #ERROR in the Continuous Form.

What are the control sources of the textboxes that get the error?  An #Error occurs when an expression cannot be evaluated correctly.

Is that SQL used for the form's recordsource?  If so, where does the column "# of Entries" get its data?  The SQL only has two columns.

Hey Kevin,  the Control Sources of the TextBox of "Employee" is coming for the "EmployeeNameQ": =Nz(DLookUp("EmployeeFullName","EmployeeNameQ","EmployeeID=" & [EmployeeID]),0). The Control Sources of the TextBox of "# of Entries" is coming for: =DCount("HoursLogID","HoursLogT","EmployeeID"), but I got that Corrected.

Hi James,

The #Error under CrewID is likely due to DLookup returning an error.  Could [EmployeeID] be Null?  That would cause an error, because a Null in [EmployeeID] would cause a syntax error in the criteria: DLookUp("EmployeeFullName","EmployeeNameQ","EmployeeID=")

What is the control source of the textbox for the "Total Hrs. Used" column?

Besides fixing these #Error, you many need to consider design changes.  Ideally, the textboxes' control sources should just be the column names of the form's recordsource's query.  All the aggregations can be done in that query alone, and they don't need to be done a second time in the textboxes' control sources with DLookup, DCount, etc.

Hey Kevin, I find out what I did wrong. Thanks for the help on this Problem. Thanks again for helping me through it.