Recent content by jk42

I think that's what I meant! If it were in excel, i would literally just be trying to copy and paste column A into column B, so I could change a few things but still be able to access the original column and the manipulated information. Is that what you were saying above? Sorry, I'm not super...

Hi! I have a field that has a description of the project I'm working on, which has client information on it. I want to take all 600 of those records and copy them to fields in the same table, so that I can remove the client information, which will allow me to pull whichever of those two I need...

100.001, Finance, admin, USA, Internal, 6, 5 100.002, finance, admin, USA, External, 8,2

Apologies, I just used the wrong word, I was talking about the queries. TblProjectDetails ProjectId, Category, Category 2, Countries, Type, #Employees, #Buildings, 100.001, Finance, admin, USA, Internal, 6, 5 100.002, finance, admin, USA, External, 8,2 100.003, finance, accounting, Mexico...

Darn! I don't know how I missed your response! So sorry I'm so slow. Ok, so I now beautifully know which things are "finance and admin" but I forgot that I also needed all the relevant data that goes along with the "finance and admin" projects. Right now I have the Sub table that you helped me...

So sorry, one more question. If I wanted to add multiple things, like finance, admin, managerial, accounting, would I just need the category column to the original query for each item? And then would the >1 thing change as well? I just want to understand how to manipulate for other things...

Sorry-let me be more specific. in addition to wanting to know which are "finance" and "admin" categories, there will also be all sorts of other project specific details that are not in that tbljunctionproject_categories. The details will come from tblprojectdetails. I hope that provides more...

If i wanted to add all of the pertinent details to that project, in addition to it's category, would that be easy to do? Would I have to do anything special? I just tried to use clicking the things I wanted from tblProjectdetails in that query of "sub1' and it did NOT work! It returned...

WOW! That is EXACTLY what I needed!! Thanks so much!! Seriously, that just made my Friday afternoon a little bit better! Thanks again!!!!!

Hi All! So I have a form that has a sub form on it (based off of a junction table), indicating which category a particular project belongs to. It can belong to multiple categories: ProjectID 100 Category Admin Finance But I want to run a query to find all of the projects that are both admin...

I did not know that you could do that calculation in Excel. I ended up making a sheet that would work for my purposes. Thanks so much!

Just changed it, and it worked. Thanks, again!

Thanks, everyone. So if I go change all the relationships to cascade update, that will help? Thanks!

I use it in form view, but I will try what you mentioned. Thanks!

I'm sorry if I wasn't clear. I wasn't necessarily worried about the duplicates, per se. I wanted to make sure that the query was correct, which I believe you confirmed in an earlier post. (thanks!) I am just not educated enough in Access to know how to take that query, and turn it into a...