Search results

I'm not sure if it is, Cosmos. But I've fixed it and it's all good now. I just had to re-do the relationship and data entry. I'll download it tonight, though, and peek at it tomorrow and see if it's helpful. Thanks --Sara

In case anyone was curious... I'm still not sure why it was giving me strange results - there were none of those weird NULL things gonig on, but I think that when I was doing the initial data entry, I goofed. I created this db from one that had been made by someone less experienced with...

The Doc Man, 1 - the two databases are pretty small. The first, which is almost complete, is right 734kb. The second, though it will be bigger, won't be too much bigger. 2 - Security issues are pretty much the same for both. The same people will be using both databases, and it will be...

Hi, all... I'd just like some simple advice. I'm nearly finished a db for Human resources that lists all employees and all of their information. It has six tables (hopefully created correctly and normalized...) Anyway, they also want something that will track applications for vacant...

I was just able to try this... and it returned the same result. All dates prior to the report date came up "no" and dates in the future came up "yes." Any other thoughts? Thanks again. --Sara

Thanks, Pat! That's helpful. But I have a brand new problem now. It's now returning a "No" for all results, except those whose date is after today. (ie they haven't started work at the new position yet.) Employees are on probation for one year after their ProbDate. Any further...

I am trying to create a query which will generate a report based on a date entered by the user. I can't, however, get the formatting right... When I create a prompt, the calculations in other fields return #ERROR. When I enter a date manually into the query, they return working fine. I'm...

to determine probation status, it needs to look at the year, but otherwise should only look at the month.

Okay, not quite sure how to do this, but I'll do what I can. If date() - ProbationDate < 12 months (or 1 year?) then ProbationStatus = yes. If ProbationStatus = yes and date() - ProbationDate = 3 months then EvaluationType = 3 Month If ProbationStatus = yes and date() - ProbationDate = 7...

Cosmos - I just found someone with Access 2000 and was able to open your sample. I don't know if it's quite what I want, although the ElapsedMonths section of the query I'm sure will be helpful. As I said, the probation month is not the only factor. It is only a factor if the employee is on...

Thanks, Cosmos. I finally just got a chance to try out what you posted, but it won't open. Are you using Access 2000? I should have said - I'm using Access97. Thanks, though. Anyway, still having trouble with this... so if anyone has any more thoughts, it'll be my major project for the...

Well, I'm not sure... Probation date is only the date used for the probationary evaluations. The hire date is used for the others (annual and semi-annual). I'd like the query to tell me which type of evaluation it is. (If the probation month is three months before the current month, it will...

Yes, we store whether the employee is on probation. When you say startdates, do you mean a date other than the probation date or the hire date? We store a ProbationDate and HireDate. StartDate is the initial hire of the individual. Probation date is the same date, unless they switch jobs...

Hi again! I want to create a query that will generate a monthly report. Problem is, I have NO idea how to do this, really. I was hoping to get some help. Okay, here's what's up: Each employee has a Hire Date and a Probation Date. The hire date is when they were hired into the agency, and...

Thanks, Hay. I checked that stuff, and it was all correct. And then I compacted the db, and it still happened. They are all the same results, too, so it's at least a consistent error. I also double-checked the table where the information is stored and it's all correct there. This is really...

Yes, that's it exactly, but only in some places. There are 41 results and five show the ClassCode (column1) instead of PositionTitle (column2). Thanks, Hay! :) --Sara

Hi, all. I just created a query out of three of my tables. When I run the query, I get all of the results I need. However, when I run the report I get these weird inconsistent results. The primary tabe (tblEmployees) uses a lookup to tblClassCode to retrieve job titles. The result shows the...

Excuse me, it's late in the day and late in the week, so if this is confusing, let me know and I'll try to clarify. I'm trying to figure out how to automatically fill in some data. Okay, so we have employees, and they each work in a job which is classified by it's title, Classification Code...

Okay, should there also be a separate table only if there are a few options that will never change? I havea field in the tblApplications table that asks for the application source. There are only three options: In-House, Outside, or From Register. These won't change. There's nothing else...

Thanks, Cos, that was a helpful article. And thanks, RichM and Graham. I think I get it now. :) I really appreciate everyone's help. --Sara