Search results for query: *

Hello. I am making some progress but there's still something missing. Apparently there are records in tblMaterialChanges.Drawing that aren't in the tblRequesters table, and I do need those records to be displayed as well. I could do that with a left join but I'm not sure how to integrate that...

When I try that new code I get the 8 records where the data matches exactly. And I just realized that there are 3 records in both tables where the data is exactly six characters. And if I take out the OR and everything after it (see below), those 3 records are all that I get. SELECT...

Actually I spoke too soon. I no longer get syntax errors but if I expand my query and add another column (Originators) from tblRequesters, it only shows those Originators in the records without hyphens, when there should be an Originator in almost every record. SELECT...

Thanks, PH! I made that change and changed the join to a left join and got all the records I expected to see. (With the inner join I only saw those records without the hyphen; not sure why that is but I'll take it...) Here's what worked: SELECT tblMaterialChanges.Drawing FROM...

I am using Access to organize data from various spreadsheets and generate some information. I'm running into issues with a multi-table query where some of the data in one table is entered as 123456-7890 and in another it is 123456. Those same columns also have data that matches exactly, i.e...

Thanks Skip & Gavona. Skip is right, this is a one-time cleanup. And I have already wasted a couple of hours today trying to figure out the VBA. I guess one problem I had was with my sort, as I was trying it with "Sort A to Z" and running into the array error. Sorting through the "Sort"...

Hello. I have been tasked with cleaning up an old spreadsheet with over 14,000 rows of data. Essentially the spreadsheet was designed to track when something was done, and the initials of the person who performed the action. When the spreadsheet was first used both the initials and the date...