Search results

I have an employee table in which one is date of hire. I made a query which contains all the employees date of hire in one column. I now need a new column to which I can add 6 months (PERM DATE) to thier date of hire for perm status. I tried the date add function but could only get it to work...

Overflow Thanks, Mikk for the response. The date is in the ADV E4 TBL so I put this: ([ADV E4 TBL.DOR]+0/6/0) and get an overflow error. That's new to me.

I'm importing a text file into Access from a SQL program. There are three sets of dates (DATE_HIRED, DATE_PROBATION and DATE_PROMOTION). They are all three formated in SQL to read the same format (ex. 01-NOV-95). The first two import into my table but the third date has a conversion type error...

I have a date in the format of 01-NOV-05. In the criteria how can I get it to add 6 months to that date. Maybe I need to go back to school but can't figure it out for the life of me. Please help.

My employee report is one employee w/info per page. How can I get the whole page to be yellow if, let's say, the guy works for Billing Department. So when I put his employee number in and it brings his record up it will be yellow because he is in Billing. Can I make it so each department has a...

How do I keep repeated data from showing in a report. For example I have: 102 02 Report 02231970 102 02 Reprt2 02231971 102 02 Resend 02231972 How do I get it to look like this: 102 02 Report 02231970 Reprt2 02231971 Resend 02231972 Basically not have the...

Our inventory is based on a number system for example: 101 01 101 02 101 03 102 01 102 02 102 03 102 04 etc What do I have to put in the query to make it skip a space after each group set. For example after 101 and after 102 etc. thanks.