Search results

I have a query that returns results for long text monthly updates over the past three months. I wanted to find all instances where a project had not had an update during that time. I set the query up like this: As far as I can tell the query is returning every instance of any UpdateText...

Thank you so much! I have a very long thread on this elsewhere on the site but I think the information I need may be embedded within this thread/database, so I will take a look on my home computer later tonight (end of the workday here). Thank you again!

Side note: I created a subform from a query that will at least display information for records already entered. Then inspired I created a subform with PRID from the junction table and names from the staff table. I expected the query just to act as a report of all internal authors for each...

My org's computer won't let me open the above attachment. Anyway someone can describe in words (or screenshots) what happened here to make @daniel.winson so happy? I'm struggling with something similar.

Probably just easier to do a screen shot of the table design, rather than try to explain this one in words. This is the table with the AllALWRIAuthors field removed (moved into a new junction table connected to ALWRIStaff.). I am trying to figure out how to create an input form that will allow...

I think perhaps I've gotten myself into trouble by using multivalue fields in the tables instead of storing that info in junction tables? I've run into this with another table/report too and just split out a mvf from that table into a separate junction table. But I'm definitely in over me head...

Ok--I think there was some confusion because there are two fields in the PrimaryTablePolicyReviews table that draw information from the ListALWRIStaff table. The first is the ResearcherID field. That one is currently fine. It is serving its purpose in the table and it works fine in the...

@GPGeorge I did! Did you not see my response to you? I included a screenshot for you to see. I think mine is set up similarly.

Note: regarding my above comment, "But though there is a drop down list of ID numbers, they aren't associated with names, so I don't know which belongs to whom"--I sorted that out. It's working ok now. I also locked down the last name/first name fields so that names can't be typed in manually...

Hi @plog yes--I noticed the tasks table hanging out in there when I reopened the query design. It didn't make sense for my initial question--think I had added it in because when I started, I was trying to create a query that would list all the tasks for each project (so that I could present a...

@GPGeorge Here's a screenshot of the relationship--it's a bit different in that there is a junction table for the many possible authors to one policy review, and a direct relationship for the one point of contact per policy review.

Earlier, some of you helped me overhaul my table/relationships design. The solution you offered was very elegant (thank you again!). My queries are still working well. But I have been stymied by how to create an associated data entry field on the user input form. I tried creating a combo box...

I would like it to look more or less like this: but with a list of tasks below each project title. Currently that looks like: That's just two of the projects titles, with tasks listed. But there is a date listed with each task. I would like that date to display only once and in line with...

For what it's worth, here is a sample of the table data:

I have a table with multiple multivalue fields. I created a query to list active projects (those with no end date). The query appears to be working fine, but though the report will group by any other (and all other) field in the query, for some reason, it won't group by date. Instead, it's...

@arnelgp that worked beautifully! Thank you. @MajP that worked! It looks great!

@isladogs done.

Yes--good idea. I will tackle that after I get everything properly set up. Not sure righteousness is their path though...

Done!

Hello, I've created a query to return monthly updates for the past three months for a number of projects. It's working beautifully, but I would like the report to display only the month and year of the update. The day is superfluous. I found a number of threads that suggested using the following...