Search results

Data type mismatch Ok i tried that but now i'm getting a Data Type Mismatch, would that be because of the bad field name or the fromat of the feild?

I did use that I did use that my paste somhow excluded that. the criteria should read "<=DateAdd("m",-4,Date())" DCX would the <= work with that date Serial?

Here is the code for the query INSERT INTO [Data Archive] ( [Employee number], Type, [Date], Comment ) SELECT [Absent Data].[Employee number], [Absent Data].Type, [Absent Data].Date, [Absent Data].Comment FROM [Absent Data] WHERE ((([Absent Data].Date)<=DateAdd("m",-4,Date()))); Mile I need...

This has probably been answered but I need to do a Rolling Append and Delete to the Month and Day. I've got the month allright but how do i modify it to account for the Day. Criteria - "=DateAdd("m",-4,Date())" Example as of today anything Nov 12, 03 or before shou;d be removed but i've...

Thank you I'll try that if putting everything on one table dosen't work. I'm trying that now. it solves all of my problems. Thank you for sugesting it. it made me think.:rolleyes:

I looked at the help files and as is usuanly the case the convyed information without illumination. The fields that contain the information i need are TimeoffBooked and Timeoffhistory. I need to count these in each and add them together but only for the Critera "Vacation". This is where the...

the list The row source type is Value List the row source contains: LOA Approved, LOA Denied, LOW, and Vacation. This is done as the users want to list what dates have already Happened seperatly from the ones that have not yet happened. It makes my life difficult but i'm not the end user.

I know this has probably been asked before but when it comes to hard coding i'm lost. I've got Three tables Table Fields Employee List : Employee #, lastname, firstname, vacation_days Time off history : Employee #, Timeoffbooked, Date_booked Time off booked : Employee...

Ok I get that But.... How do i find that calculation? The Query has the Fields Lastname, FirstName, Time Off Booked (Vacation as the Criteria)and then a count of the Time Off Booked. The second Query is the same but Time Off History replaces Time off Booked. Could the Join bettween the...

I have 3 tables linked through the same Employee Id. two of the tables are for time off booked and time off history. the Time off data is in a list box one of the items on that list is "Vacation" is it possable to do a count of these entries on both tables and add them together on a report...

tried I've tried that the problem is i'm trying to avoid a 3rd subreport i've already got 2.

"At the moment I have all contacts including clients, suppliers, Employees, banks, IR etc., all in one table Might it be better to split this table?" I think so, especialy employees they should be on one seperate table.

I'll try my best I'll be glad to help in any way I can but accounting practices vary from Country to country. I might be of some help since Canadas GST is basily a VAT but some other things might be wildly Different. TheCherub

By location I think that if you are going to assign leads it should be by location but ability and background should be a factors as well. You would not want somone who has never worked with payroll designing a Payroll DB just as an example. TheCherub

As soon as it's up This fourm has been such a big help to me that as soon as my web site is up and running your links will be on it. I could not survive without this fourm as a resource. Please keep up the good work and anywhere i see that i can help someone else i will endvour to do so...

How about the great white north Hey Pat do you know if they will be doing any of those Seminars in Canada?

Oh my lord That must be one fantastic Data base my hat is off to you i would not even attempt to design something like that. I'm pretty good at the whole access thing but for accounting of that magnitude i'd just buy an accounting package. it would do all you wish without the design headaches.

Use the Vertical ruler Click and drag allong the ruler and you will select everything that lines up with your selected area. this works for on the horizontal as well. At least it doe's in 2000 i'm not sure about 97

Arrgh This report is driving me nuts I've got most of it but these last two items are giving me headaches. I've got a report with sub reports for Time off. Time off current (TOC)is one sub report with attendant query Time off History (TOH)is the other sub report with it's attendant query...

Ok a new Problem I've got my Report and the Sub reports The main report Collums are Department, Last Name, First Name Vacation Elegibility The Sub Reports are Record of time off History and Record of Time off Booked I need to add 2 colums to the Main one that will add the Total Vacation...