Eeekaccess
Technical User
I realize my last posting sounded quite desperate...sorry! Perhaps I need to be a little more specific:
I'm using Access 2000, and have created a database to track a number of projects or programs with deadline dates. Each program can have up to 4 deadlines; but most have only 2. The same deadline can be related to many programs. I've created a separte field for each deadline (2001 deadline, deadline 2, deadline 3, deadline 4). On the first report (2001 Report) I want all the 2001 deadlines to appear in the first column. This is fairly easy, as they are in the one field. In the 2nd column, however, I want to combine all the other deadlines for each program on l line. To read something like: June 1/02, July 15/02, Dec 1/02. (or lined up underneath each other). I can't get it to work. I've tried using & and "" between each field name in the Control Source Box in the criteria box for the control; I get an #error message in each line. What am I doing wrong?
Also, for the 2nd report (2002 Report), I want all the 2002 deadline dates to appear in the 1st column (don't need the 2001 dates), so that each record is shown chronologically on the page. Each program would be listed for each deadline it had. But how do I do this if the deadlines are in separate fields?
I have created two tables: T_Orgs (containing organization name, address, contact, etc) and T_Programs (containing program name (primary key), orgID, deadlines, etc.) And have joined them by a 1 to many (orgs to programs) relationship. Can I/do I have to create a many to many relationship as well specifically for the program/deadline relationship?
As someone else mentioned in another posting, I think I too have just enough knowledge to be dangerous, but not enough to get unstuck! That's why I wondered if anyone could take a look at my database....it contains sample data. An Access expert may have simple solutions to my questions, but without seeing the database, it may be difficult to understand where I've gone wrong.
Can anyone offer some advice? Or refer me to an Access Expert in Toronto, who could help me this afternoon? I really have to get these reports out.....ANY help would be greatly appreciated! THANK YOU!
I'm using Access 2000, and have created a database to track a number of projects or programs with deadline dates. Each program can have up to 4 deadlines; but most have only 2. The same deadline can be related to many programs. I've created a separte field for each deadline (2001 deadline, deadline 2, deadline 3, deadline 4). On the first report (2001 Report) I want all the 2001 deadlines to appear in the first column. This is fairly easy, as they are in the one field. In the 2nd column, however, I want to combine all the other deadlines for each program on l line. To read something like: June 1/02, July 15/02, Dec 1/02. (or lined up underneath each other). I can't get it to work. I've tried using & and "" between each field name in the Control Source Box in the criteria box for the control; I get an #error message in each line. What am I doing wrong?
Also, for the 2nd report (2002 Report), I want all the 2002 deadline dates to appear in the 1st column (don't need the 2001 dates), so that each record is shown chronologically on the page. Each program would be listed for each deadline it had. But how do I do this if the deadlines are in separate fields?
I have created two tables: T_Orgs (containing organization name, address, contact, etc) and T_Programs (containing program name (primary key), orgID, deadlines, etc.) And have joined them by a 1 to many (orgs to programs) relationship. Can I/do I have to create a many to many relationship as well specifically for the program/deadline relationship?
As someone else mentioned in another posting, I think I too have just enough knowledge to be dangerous, but not enough to get unstuck! That's why I wondered if anyone could take a look at my database....it contains sample data. An Access expert may have simple solutions to my questions, but without seeing the database, it may be difficult to understand where I've gone wrong.
Can anyone offer some advice? Or refer me to an Access Expert in Toronto, who could help me this afternoon? I really have to get these reports out.....ANY help would be greatly appreciated! THANK YOU!
