Search results

Hi, I have a user input form for project records. It contains a few different subforms. Two are working fine, display data and allow data entry. The third, Grants and Agreements, does neither. It will display all fields within the form, as long as there is data entered in at least one of the...

This thread is related to another I posted earlier. I am trying to query for projects that have gone idle. Users input data into a long text field, "UpdateText" for project reports. This is a method of communicating with the team. They need to be able to enter this information freeform. If there...

This post got buried in another very long thread, so I have cleaned it up and am giving it another go. I am trying to populate a junction table, but have run into some trouble. I created a subform with a field of interest (PolicyReviewID) from a junction table and fields of interest (staff...

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...

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 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...

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...

Hi, before reading on, know that I have since deleted the lookup fields from all tables. I have been overhauling the relationships between tables in my database (thanks to some very helpful advice from this forum). When initially creating the tables, I populated them with data directly in...

I created a query to help me generate a quarterly report for projects with (long text) updates from October to January. It seemed fairly straightforward, but there were apparently catastrophic flaws--the data was imported from Excel spreadsheets and though it looked ok, the formatting was a...

Hi--I created a little query, which work beautifully to display all of the publications produced by authors who work in my organization. It looks like this. (Note, I used lookup fields (data is housed in a separate table) to ensure consistency when names are entered. Yes, I--the...

Hello all--not a programmer, just a lowly scientist trying to track data. Access seemed like a good idea at the time?