Recent content by BillMcD37

Each column contains the addresses of the program's team members by Function. Y1 is always only one member who is the Primary Internal Technical Contact. Y2 always has secondary internal team members and so on. This is standard within the organization. The business rule that determines...

I have a table that has the following field names in each record. Field name Field value ProjectID 12345 Y1 address1 Y2 address2; address 3; address4 Y3 address6 I have a query that pulls data from this table plus pulls one field from another table that is the...

Thanks again for your help. I am not sure that my solution is very elegant, but it's working. I'll keep looking at these forums.

Once I removed the spaces from my field names, the function works perfectly. Thanks!

Thanks! I am using Allen Browne's ConcatRelated function successfully with an approach that uses crosstabs to build a record for each program with the stakeholder functions as columns in the crosstab. It's not elegant but it's working for me. Thanks for the help.

Thanks. I made your suggested changes. One error went away and one new one came up. Error 3131 Syntax error in FROM clause...:eek: Here's my SQL code: SELECT [test email table].[Project Definition], [test email table].Description, [test email table].[E-mail], ConcatRelated("E-mail","test...

I'm using Allan Browne's ConcatRelated module--well, trying to use it. I absolutely cannot get it to work without the following error" Error 3075: Syntax error (Missing Operator) in query expression 'Project ID = PD00000914'. Here's what I'm typing in the query: expr1...

The crosstab query will only allow me to see the first value or the last value in a category, how do I get at the values that are not the first or the last?:confused:

It sure is! Thanks! I'll play with this for a bit. I already got it to count the number of stockholders in each category by Project ID. Now I just need to get the emails into the columns...

I am building a database that collects stakeholder email addresses for projects with the goal of automating the distribution of monthly reports for each project to those stakeholders. I have three tables: Project Master (primary key=Project ID) description, project category, etc. Stakeholder...

Hi everyone, I'm Bill. A beginner user of Access 2007 but currently way over my head in a project to build an automatic report distribution system at work. I"m looking at all of the great ideas here and will definitely be posting some urgent HELP! messages. Great to be able to join and hope...