Search results

I looked for some information about doing that on the web, but I couldn't find anything. Do you care to explain?

So I'm at work and one of my co-workers needs like 1000 accounts entered into a web user interface manually. Sure, I could just knock it out, but the mouse clicks are always the same. I've used macro's for games back in my script kiddie games, however I can't install these programs on my work...

yeah, I wondered about that...I would like to each row to compare to eachother, and then filter the results...but I guess this is impossible. What if I used just 1 table, created an expression with that table which would be the first word in that column. I then want to compare each row to that...

Here is my sql: SELECT Distinct [Profiles in Engine].NAME, Left([profiles in engine].[name],InStr([profiles in engine].[name]," ")) AS Left1, [Profiles in Engine_1].NAME FROM [Profiles in Engine] AS [Profiles in Engine_1], [Profiles in Engine] INNER JOIN Sender_SRTs ON [Profiles in Engine].NAME...

SELECT [Table1].NAME, [CopyTable1].NAME FROM [Table1], [CopyTable1] AS [Copy] GROUP BY [Table1].CUSTOMERNAME, [Copy].CUSTOMERNAME; This gives me two columns, however the length of the rows in the query becomes however many entries there are squared, meaning that a large table would become very...

I tried something like this before, all I get is the first three letters of every field... Then I tried left(namefield,3) = left(expr1,3) but with no avail.

I have a list of accounts that I want to compare to itself and find similiar names. For example, you have a list of words: Angle Angel Orange Banana Bananna Banana1 Blue I want to produce a query that would compare this list to itself, and Give an ouput like so if the first three letters...

This is kind of weird, but I tried this: SELECT DISTINCT SNDR_TC FROM MTRC_MSG_DTL UNION SELECT DISTINCT RCVR_TC FROM MTRC_MSG_DTL I got a list back, like I wanted, however it seems like some of the information on it isn't in the table. For example, I have ID #ACU2402, but I can't find it in...

SELECT DISTINCT SNDR_TC, RCVR_TC FROM MTRC_MSG_DTL GROUP BY SNDR_TC, RCVR_TC I want the result to be 1 column. Like I said, imagine I have two lists. I want to combine the two lists, and remove the duplicates from the list.

I was toying around with those, but I am unable to get the information into 1 list form. Also, it doesn't seem to work correctly

Hi, First I would like to say that I know that SQL is very powerful, so this operation should be possible. I have a table containing two ID fields: Sender, Receiver. How can I view the unique values of both fields? The fields have the following rules: 1. 1 sender can have multiple...

yeah...I knew I could use some vba code to do it, and I know it's not a good idea to have spaces in table names/field names...I didn't make the table :)... Thanks for your help though. I'm pretty good with VB, so I should be able to handle it. Btw, you're code looks pretty good.

I know how I could do it in excel, however I know you should be able to do it in access, and I don't want have to import to excel and back to access every time I do this. The number's are not unique, and I can't simply go back and change it to an auto number. They are used in a heiarchy that...

I might just end up writting some vba code that will increment it for me...however I've never used VB along with access.

Is there a reason there is 15 views and no replies?

So I have a table, and I want to add some information from it to the bottom of another table. I'm using the append function, and I want one of the fields to be incremented for the additional rows. IE, my current table ends at 12000, and I want to append 147 rows to this table. For the first...

It's nothing I want you to lose sleep over. I just assumed there was a quick way to doing this, and as of now I have to do it on a monthly basis. Our database is full of bad data, and it really is a shame, but it's not a top priority for us right now. We're trying to set up conventional...

This is what I have: Customer Name, Customer ID. The problem is I generated this list from active customer transactions, which use different systems where the customer name can be slightly different. Because of this, I have instances like this: Triplell89 xx4sx43 Tripplell89 xx4sx43 I...

Ok, now I want it to only display 1 instance of the duplicates, and also be able to update the customer id's to a new table. I have a table that has all the customers and all their id's, which is used as a reference table. There have been about 900 new customer id's added this, and adding...

Hi, I'm trying to create a query that will search through my table and return any rows that have matching fields in a different row of that same table. (or partial matching fields is my final goal, however obtaining the query is my first objective) Here is an example Table John Smith...