Search results

It will be a range with a start date and end date even if the end date is today they will enter it. This database is used by our residential sales team so they will run this report to get a list of prospective buyers that have visited the site during a certain period as part of a follow-up...

Thanks Neileg for the suggestion. Tried it but it gave me and error when I tried to run the report. Something about an expression was too complicated - Sorry I didn't write it down. Any other ideas? Thanks

ThreeCrow I tested the selections with the scripts you provided and it seems that the problem is with the beginning and ending date range. If I run my report and select anything but leave the date range field blank it does not seem to work. If I fill in any criteria plus a date range it returns...

Thanks SuePowell and ThreeCrow I'm checking everything right now again and will let you know what I find. Thanks,

Thanks for the response. I tried your suggestions and I'm still having problems. What I'm looking for this query/form to do is return data based upon the selected items or combination of items selected on the form. I.E. If I select a community and nothing else it should return all entries in...

Working on a sales guest registration database and need a some assistance with a query for my report. I have the following fields in the table: Communities RepName Date1stVisit MoveTime I have created a query which works without a problem. I have also created a dialog form to use with a report...

That sounds like it would work. Let me give it a try and I'll let you know. Thanks,

I thought that would work but I couldn't figure it out. There would be about 8 compensation fields for each of our 120 or so employees. Using your suggestion wouldn't I keep repeating information in a single table? I'm assuming your talking about a structure like the one below. Employee Dept...

Basically what this database will be used for is year end reviews. What they want is the ability to print a form that give them the employee's compensation information for the last 3 years. Previously it was done with an Excel spreadsheet and an Access report but each year they would have to go...

Trying to setup a database to track employee compensation and need some advise on the setup. I was told in a previous post to normalize my tables which I think I've done. I would just like some other input on this to know if I've done it right. I created a table called Employees with the...

Employee Comp Database Thanks Doc - I've been reading up on normalization and now have some questions. The way it seems to me to work this correctly is to break out the employee data - ie. name, dept, hire date, etc. into one table and then break out each subsequent year's compensation in...

Employee Comp Database Thanks Pat - That makes sense but will a database structure like that allow me to go back show a history of employee compensation from when they were hired? What these guys are really looking for is something historical so that they can determine future compensation by...

Would like to hear from anyone that has designed a database that can be used to track employee compensation on a year to year basis. I am current designing a database to do just that but I'm having a hard time deciding on how to setup the tables. What they use this for is yearly reviews so I...

Thanks - I would have still been working on these without your help. I just need to tweak them a little bit and they should be perfect. These are the formulas that I ended up with: %Prior...

Thanks for the response. I think it's almost there but I'm trying to look for formula that's dynamic in that as the years change so do the percentages for each employee. Each year they want to look at this query and see how long each employee was here the year before as well as the current year...

I trying to figure out how to make this query work. I have a simple database that is being used to show employee employment information - name, hire date, salary, bonuses, etc. Everything is just about done but they want me to show what percentage of the prior year the employee was there. In...