Search results

Ok but why is the query showing me nothing?

Thanks for your help Scott. My database is to collect information about book check outs. In addition to the other fields tracking information I have a date1 and a date2 field. Date1 is checked out and Date2 is date of return. I have a List box and a calender control on the form. A textbox is...

Didn't work. Here is my SQL. Where did I go wrong? SELECT CheckOutTbl.checkId, CheckOutTbl.checkDate, CheckOutTbl.checkDateRet, teacherTbl.teacherFirst, teacherTbl.teacherLast, bookTbl.bookName FROM teacherTbl INNER JOIN (bookTbl INNER JOIN CheckOutTbl ON bookTbl.bookId = CheckOutTbl.bookID)...

Scott, The date1 and date2 are not on the form. On the form is a listbox which will contain the results (the rows that are within the selected date) and the calendar control. I do have a text box that displays the selected date so I can use that. To rePhrase: Get all rows that CalenderDate is...

I have a backwards date between query. I have a table with Date1 and Date2 fields. On the form I have a calender control. I want the user to click a date on the calender control and then look at the rows in the table to see if that date is between the Date1 and Date2 fields. So the query will...

Sorry but I was looking for the percent of the individual groups like Corporate Functions, Customer Issues, Hardware Repair and Maint. Like on Page 1 on the Current Month I want to calculate the percent of time spent doing Corporate Functions or the calulation 3.92/244 and display that...

I tried that. Ok. Here is a access file that has the report and a small snap shot of the data from the table. Looking at this would proabably help you in my dilema. I took out my attempts to calculate the percentage. Thank you for all of your help.

[SumOfT_RegularHours] is a a sum of hours worked on a specific job type such as Service Calls, Inventory,or Sales Support... The [TotalRegHours] is the total sum of the hours for the individual person over all the job types. The percent is the % of time spent on any specific job type when...

The value in TotalRegHours is correct when the report is displayed. [TotalRegHours] is in the group footer. My thought is that the value of [TotalRegHours] isn't completely finished computing when Im trying to get the percentage of [TotalRegHours] with the formula =[SumOfT_RegularHours] /...

When I do the calculation it only works if I add in the correct # for the total. If I use the formula =[SumOfT_RegularHours]/[TotalRegHours] the number is wrong. If I use =[SumOfT_RegularHours]/244, with 244 being the number that should be in the TotalRegHours it works.

How do I calculate a "percent of" in a report on a line in the group header when the total sum of what I need to do the "percent of" isn't totally figured out until the group footer?

Rich - U da man! Thanks everyone who helped me on this

Rich - That worked great for grand totals for all employees but for the individual user totals are doing a running sum also. If i do the property over group the field is blank. Any Ideas

I have a Access Program and associated reports I have inherited from another developer. The report/app is a time sheet. On this report I have the following sections: Report Header(Blank) Page Header (has the reports header) LastName Header (has the last name of employee) Detail DateWorked...

I will post my SQL Statement. Please help. The error i get is in the message above SELECT dbo_SCCalls.CallNumber, dbo_SCCalls.Date, dbo_SCCalls.Status, Min(dbo_TimeHistory.T_DateWorked), Min(dbo_TimeHistory.T_StartTime) AS FirstOfTimeWork FROM dbo_SCCalls INNER JOIN dbo_TimeHistory ON...

Now i get a error "You Tried to execute a query that doesn't include the specified expression 'CallNumber' as part of a aggregate function"

I get a error in the select statement for First.

Thanks but... If I do that then I get multiple entries for the same call in the result set if that ticket was worked on multiple times throughout the day. Example - Say I worked on SVC#1001 on 9/15/04 at 8AM, 9:45AM, and 11:30AM. Each time i worked on the call would be a new entry in the time...

I have a service call application which in one table records the service call number and the time the call was placed. In another table I have the service call details and time a technician worked on it. In the details table there can be multiple entries for one service call because a tech might...