Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Not displaying some fields in a certain period

Status
Not open for further replies.

rnc110

MIS
May 31, 2001
16
US
I have a question concerning a previous question I had posted a couple weeks ago and I thought the problem was corrected but a few days before the report is needed I found out that it still has one minor problem that I can not for the life of me figure out. Heres the problem.

This particular report is focusing on 2 tables. tblEmployee and tblIdea. The fields for tblEmployee we are using are: EmpID, EmpLName,EmpFName and for tblIdea I am using IdeaId, Idea Description, Date Assigned(when the idea was submitted).

All this simple report is to do is display all the employess and the total number of ideas they have submitted in a particular time frame. Then it has a drill down to see the idea. Well the problem we had before when I posted it was to display in addition to employees with ideass also the employees that had a count of 0 ideas. The code we used the code for the record selection was

isnull({tblIdea.DateAssigned}) or ({tblIdea.DateAssigned} in {?Beginning Date} to {?Ending Date})

Well I just relized that this does not display an employee's name who has an idea but not in this period. (Does not show for example if I John Doe has submitted 4 ideas but all 4 of those ideas were not in the time period it does not display my name with a count of 0) I believe this is because Date assigned is never null unlike the ones that it displays now for the test data. Right now it is displaying only counts of zero only if the employee has never submitted an idea before at any time. As soon as an employee submits an idea his name will not show up if he has a zero count.

I have been working on this for a while now and can not write the right code for the record selection. Any Ideas?
 
I don't think the problem is with your Record Selection. It may be the way your tables are joined. Right now you are probably only getting Employee records that have a matching record(s) in the Ideas table. You may need to change the join properties so that all records from the employee table are selected and then those records from the idea table that match.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top