Search results for query: *

Never mind. Guess I was just looking in the wrong place. http://www.tek-tips.com/faqs.cfm?fid=855

I tried that an it only let me select one Table to pull values from and I need it to pull values from three tables.

Ok, so I have three tables: CURRENT, Employees(linked), and School(Linked). Currently all three have an address but because of disputes the addresses vary. I was hoping to setup some kind of form were a user can select one of the address and that choice will be written into the CURRENT table...

Oh, right sorry about that. I just noticed in my first post I put cell instead of column. Ok, well I fixed it and it works now. Thanks so much for the help.

Wow, thanks. I appreciate that. The line: a2 = Split(a1(1), ")") is returning a run-time error '9', subscript out of range. I'm not really sure what my subscript is so I have no idea on which value to change. I'm guessing it deals with the value a1, not too sure though. Any idea which part of...

Hello, I have an excel workbook with some messed up values. I am trying to replace the number in the parenthesis with a value, starting at one and continuing until the data stops. The data is as follows from Cells B, C, and D on Rows 3, 4, 5, and 6: A1A'SP (311)'!I1 A1A'SP (311)'!C49...

Hello, I currently have a table that is full of copier information. What I am trying to do is figure out if there is a ten percent difference in BW copies over a months time. Currently the table looks like this. CopiersID Month Year BWCount 5 9 2008 7871155 5 10...

Ok, turns out all I needed to do was add OR (([Employees].Preferred_Name)<>([CURRENT].Preffered_Name)) to the end of my WHERE statement and all seems fine now.

I tried editing the ((Trim([Employees].PREFERRED_NAME & ""))<>"")) line, but no luck there. I also tried adding (Employees.Preferred_Name <> CURRENT.Preffered_Name) I realize that may not be the best or correct line to add but SQL isn't my native language so I'm slowly learning it as I go...

Alright, after doing some other things and testing this it doesn't want to change a preferred name if one already exists in both fields. Is there anyway to fix this? Thanks

Awesome. Thanks so much PHV. Problem solved.

Oh wow. That made things look much better. Is there any way to modify that so that it will ignore display equal blank cells in both Employees and in CURRENT. -Quick reference- CURRENT = Preffered Employees = Preferred Like, when I do Datasheet view for the select query, which is almost...

GingerR, I agree with you on the two databases part but that's how my boss wanted it so I can't really argue it. I'm sorry it was hard to understand but it's kind of hard to explain without seeing it all in person so I tried to explain as best I could. But, I think you are right in finding the...

I need some help on a query. What I am trying to do is have the query look at Employees and find all the preferred names that are not in the CURRENT table and update the CURRENT table. My problem right now is that all of the fields that need to be updated in CURRENT are just blank so the query...

I appreciate it though. I have never used a delete query so the syntax is very foreign to me, especially the WHERE and FROM parts of it. Does my correction work fine or would your code be a more proper method of doing it? Thanks.

Ok, I think I just figured it out. All I did was change INNER JOIN to LEFT JOIN and it removed the 200ish employees I needed. Thanks anyways though.

I didn't see an edit button anywhere and I thought I would mention that a TechID consists of something like R01234567. They will always start with R and have eight numbers after that R. The TechID is also the primary key. Thanks.

Ok, I have an Access table that is updated with changes from a linked Excel document. This table contains employment information so if there is a change in the system I will have a new employee table emailed and I will overwrite the old one. Now, what I need help with is the delete query. If an...

Ok, something very wierd happens with Access query editor. I was working in the Design view and it has the base table as Employees and then updates the CURRENT table, which is what I wanted. So, I looked at the SQL view and it has Employees table set to equal the CURRENT table, which PHV says...

Ok, tried out what you said and I'm still getting that error. Whenever I swap to Datasheet view it has quite a bit of info in there. It looks like everything in there should be updated so I think it's going to update correctly I just don't understand why it gives me that error. I am using "_"...