Search results

No fighting no fighting on the schoolyard boys. I don't know it the execute method would work or not since the Set warnings worked. I didn't look any farther. If the execute was the first on the list i might not have gotten to Set Warnings.

Witch footer Should the Counter go in the Page Footer or the Report Footer and Ialready have a Count in the report shouldn't I be using a Sum of the count? :confused: The Sub report has 3 fields: Time off Booked (list box(LOA, TOA, TOD, LOW)) Count of Time off Booked Date of time off booked...

Thank you The set warnings action worked like a charm

I have an Append and Delete querry to run every day I know how to set this up, the question is how to I keep the data base from asking to confirm all the Appends and deletes. as it does when those are the only items in the macro. Thanks

I need to program a Rolling Append and Delete Querry that removes information that is 4 months old and Archives it. The Problem is that every time I try to set the Criteria I get errors. How can I use the Date() function to set this up I've tried to use "Date()<=" but I don't know how to code...

Ok mow a new problem Ok the repeating data problem is no more. But I have a new Problem. in my Sub-report I have the following Field 1 Time off History Field 2 Count of Time off History Field 3 Date Booked So far so good the problem is Time off History is a list box and i need to total each...

Ok I see So the Layout would be Main Report - Employee Info(from Table) Sub Report1 - Time off history Sub report 2 - Time off current Should i use the Tables for the subreports and then do the Counts and other calulations on the subreports or use Queries to form the subreports? It seems to...

This might help I think that the best way to do it is with 2 Queries on to Display the only the Checked records on one to display all. The other way is to force user entry. Like:[yes/no] that will give you either or with one query i'm not sure how to use that to give you all of the records...

Well here it is The SQL of the Query SELECT [Employee List].Department, [Employee List].[Last Name], [Employee List].[First Name], [Time Off History].[Time Off History], Count([Time Off History].[Time Off History]) AS [CountOfTime Off History], [Time Off History].[Date Booked], [Time off...

SQL Posting Here's a stupid Question, How does one post their SQL :confused:

Here is more Info The Tables are Employee Info - Employee #, Last name, First Name, Department, Date of Hire. Terminated (Y\N) Time Off History - Fields Employee #(one to many with Employee info), Type Of Time (Vac, Leave of Absence app, LOA Denied. and LOW)(List) and Date of Time off) Time...

This may seem strange but i've got a two tables with similar Data one is for History Dates the other is for Future dates. I am trying to get the report to Show the totals or each. But in my report i keep getting both the History and Currents multiple times. And i can't for the life of me...