Search results

I have data in excel where 1 contact is known by many people such as: New2SQL - Access Forum - David Beckham New2SQL - Access Forum - Coby Jones New2SQL - Access Forum - Daniel Dichio I am trying to macro this so it appears as follows: New2SQL - Access Forum - David Beckham, Coby Jones...

Is there a way to edit the 'count' results in a pivot table? I have got a list of name down the left to show the person a. from my data i can see the count of people who know person a. he knows 2 people. is there a way to show me the names of these 2 people rather than just a number? thanks in...

I am looking for the best way to shortern a string. Basically the string has the set up like this: New2SQL/123/London I just want the name bit at the beginning. Everything before the first / any one have an idea the best way to get this? thanks

..I am trying to run a query that allows me to enter the name of an entry on my database for that entry only. So for example, when I run the query, I am looking for information on "New2SQL" only. Now I know I could just enter this in the 'Criteria' row BUT I am needing to run this query...

A guy i work with has a slight issue with his PC. He tried to connect a USB cable to his harddrive and now when he tries to start his PC gets the following error: "USB overcurrent device detected. Will close down in 15 seconds" Any suggestions?

I have got a set of information that has a mixed bag of names. Some have only a first name but some have a middle name also. I am looking to shortern the information just to the firstname (i.e. in stead of the results showing "Bill William" as the firstname, i want to just show "Bill"). i...

How do i trim a name in a string. I have 2 rows with firstname in one and the second has surname. if i wanted to view the results to have A Einstein rather than Albert Einstein, how would this be done? thanks.

having a prob with the above. not sure what is the best way to find out what comes after the @ in an e-mail address. For example, if i was to have the following e-mail address@ firstname.lastname@myemail.com is there an expression to use to shrink the above so that i can only see the...

I am trying to get a date range for my query. I need my query to be able to input 2 date sets and pick data between the dates. At the moment i can add on the date using the [date dd/mm/yy] and also using the >= to show info based after this date, but need to have the information between two...

..i am new to SQL/Access databases so am looking to create a query that finds the first space in a text box. For example, if i have "New2SQL 100", how would i write a query to find the space and shortern the text to just "New2SQL"? Any help would be much appreciated. Thanx.