Recent content by shanice

Here's what I'm entering into the control source of a text box: =IIf([PM]=True,"Project Manager; ","") & IIf([TL]=True,"Technical Lead; ","") & IIf([Task]=True,"Tasking; ","") & IIf([Understand]=True,"Understanding; ","") & IIf([Staffing]=True,"Staffing; ","") & IIf([Manage]=True,"Management...

Thanks for this post. I got text to display for multiple checkboxes; however, I cannot figure out how to make commas appear between each value. The only way I've been able to do it is to add the comma at the end of the text, but it looks tacky because it always shows. Does anyone know how I can...

Hello! I have a query that lists the roles that staff play on each project. In many cases staff played more than one role on a project, so staff names appear multiple times. I.e.: Row 1 - Name: Sue Smith - Role: Editor - Project: CC1 Row 2 - Name: Sue Smith - Role: Analyst - Project CC1 Row 3 -...

Thanks! This works but it's counting the duplicates. I tried using SELECT DISTINCT coding in the criteria field but it keeps saying there's an error.

Thanks! Do you know how I can count the number of projects each staff person works on? Some staff play more than one role on each project, so I wouldn't want it to count the duplicates.

This is great!!! Thanks!

Hello! I have two tables that I want to link together. One table lists staff and the trainings that they've taken. The other lists projects and the roles that each staff person played. I want to be able to query a person's name and see their trainings, projects, and roles. The only problem is...

Is there a way to have each name show the number of times that they are listed in parathesis: +Bill Smith (3) +John Johnson (8) +Richard Lewis (2)

Yes that was the desired output. Right now my I have 7 columns but here's 3 just for example: Column 1: Project Name (unique) Row 1: Project Name 1 Row 2: Project Name 2 Row 3: Project Name 3 Project Manger Row 1: Sue Davis Row 2: Bill Smith Row 3:John Johnson Senior Analyst Row 1...

Hello Everyone! I have an excel spreadsheet that I have imported in access. The spreadsheet has a column that lists project title and then 6 staff titles (project manager, admin asst, etc). I'm trying to create a query (or maybe it should be a report) that shows the projects and titles that...

You are the greatest!!! It worked!!! Thanks! :)

I see what you're saying. I'm generating reports for 30 states. For each state there are 13 professions that we inquired about. For most of these professions there won't be a name (meaning no one worked in that field), but we still want all of the professions to show on each report. So I'm...

Somewhat, but here's the problem. The professions are listed in a drop down menu. The template is already set to list the professions as such: a. accountant Name: (textbox206) b. doctor Name: (textbox207) c. lawyer Name: (textbox208)...

I have a drop down field on a form that lists staff positions. For this position I also lists the persons name in another field. On a report I've listed the staff positions (i.e.): a. accountant Name: b. doctor Name: c. lawyer Name: I'm trying to write an if statement that pulls the...

Thank you so much! It worked! 1. I'm exporting the report to Word, do you know how I can get the footer to show up correctly? Right now it's all of over the place. 2. Isn't there a way that I can type in the state name and have only that report pop-up? It seems like I've done this before, but...