Search results

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 can upload the database, but it seems the attach files function below is not recognizing Excel files?

Thank you! Working on this now.

Hi--if I understand correctly, with your suggested design, this table could capture monthly project updates for all years (MonthName could instead be a date?)? That configuration seems like it would release some of the input control--updates are expected on a monthly basis, but not required. 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...

This is great information. Thank you so much for this thoughtful response. I had to generate a couple of queries with other messy (now tidied) tables for a meeting in the AM, but will spend more time with this issue in the morning. I'm so grateful for the time and thought you put into this...

This is incredibly helpful, well-written, and easy to understand. Thank you so much! I'm thinking about how/whether to proceed with a new author's table. I only need to track the products of about ~10 people who work in our org. The rest of the co-authors (crammed into that single field you...

Ok--I started down a new path... removing the lookup option from the original table to see if I could start from scratch. Changing that field to text box caused all the entered names to revert to the StaffID number. But it also made the associated form go bonkers and sent me down a rabbithole...

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?