Search results

Wow, I feel so dumb, thanks bud, that works great.

Good Monring all, trying to get something working on a form. When creating a new client, due to privacy, we have to create a Unique ID for each one. The ID consists of their initials, the year, a serial number and the location. I have it mostly working except for the year. Let me show you...

Tying to export data to an Excel spreadsheet and it's works with no problem. But what I would like to add is a specific name in the .xlsx file name. I have a table with a single field and a single record with a name in it. I use this for other functions when running the DB. I would also like...

nona87, in the query, in the criteria line for each check-box column, type YES. This will cause only those records where the field is Yes (a checked box) to be displayed.

I have data from three sources that is not similar. Each is an Excel spreadsheet that I have imported into Access. Each has a field called LOCATION. The tables are Site1, Site2 and MasterList. The MasterList is the correct format. Here is an example of the data I have in the LOCATION field...

DOH! I think you got it. Go from right to left, size is always the exact same size and code is either 4 or 5 characters, So if I go 5 characters, I might capture an extra space but I can remove that later. Thanks! Let me try it.

Sorry no, otherwise I could just use the text to columns in excel before I imported. The location code and size are always the same and unique, but the first part of the data, the location varies. Sometimes with a '-' sometimes without. Several of the names are foriegn sites that use "-" in the...

I know what you are saying, and that is the problem, the answer is no. For example I could have Miami - M0123 - Size 1 and Miami-Airport - M0123 - Size 1 Both Miami and Miami Airport are Names. So if I did as you suggest, in this case Airport would be seperated out and it shouldn't be.

I hope the day finds everbody well. I am working on a project that just has me mind blocked and I'm sure it's a simple little thing, but I just can't get it. I have about 700 seperate Excel spreadsheets that I need to incorporate into a single database. Each spreadsheet has about 15,000...