Recent content by TrunksSenkawa

Thanks Sorry I haven't posted recently but it now works. Thank you!

Week good Week works perfectly, thanks! But, the month does not seem to total. I'm getting sums for the month values that are signifigantly less that the week values.

Sql TRANSFORM Count([Call Log Table].Department) AS CountOfDepartment SELECT [Call Log Table].Department FROM [Call Log Table] GROUP BY [Call Log Table].Department ORDER BY [Call Log Table].Department, [Call Log Table].txtDate PIVOT [Call Log Table].txtDate;

I have a query that sums the number of instances of a field [Department] for every day. I need to create 2 queries; one creates the sums for a week and one for a month. The left column is the departments and the top row is the weeks. So in the week, it would display along the row as: 10/20/02...

Can't find it there.

What query? How do I get it to count the # of instances of a certain department name for a set date interval? Sorry, I'm a novice :).

What is the code to synchronize with replicas? Thx!

I have a call log database that stores among other things, the date and the department the call was for. I need to create 2 reports that total the number of calls to each department for a set week and set month. I want to be able to add weeks and months as time goes by, of course. How would I go...

I got it! Thanks to all who helped!

Didn't work I put the code in the BeforeUpdate of both the time and date fields and started a new record at 2:35. I waited until 2:37 and entered the record. The table displayed 2:35 for that record.

Ok thanks! But... How do I store info in a field using code? Where would I place the assignment in the code?

How do you enter the code? This isn't working. I set the form timer to 1000 and the timer event to the above code. Then, I created a text box with the default value as Time() and the control source as txtTime (which is where I want the time stored). I went to the form view and the text box...

My problem is that I am creating a call log. I have a time field on the form set to automatically display the current time and store it in a field. Only problem is, the Time() function only recieves the current time when a new record is created. So if a new record is created and it sits there...