Running & Setting Up Queries - Page 1113

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
Date by antonov Hello everybody, I have this query based on a table in which I have 2 fields. One of them is a medium date one. In a form I need to input the date and the...	November 16th, 2006 05:22 AM by tina	8	130
Criteria using part date by CurtainMary We have a client ordering numbering system like A nnnn/yy where yy denotes the last two digits of the year. I want to be able to retrieve this year's orders....	November 16th, 2006 04:21 AM by CurtainMary	4	86
Split the names by space by [email protected] Hi, I need your help. I'm trying to break three words in one columns by space into three different columns. example: Address - 45 Waterfront Road (one...	November 16th, 2006 04:03 AM by John Vinson	1	75
Query imported into MS-Excel gives empty result by mogens I have a number of queries that I integrate into MS-Excel. Normally importing queries goes fine, but now I have a problem where a query displays as empty...	November 16th, 2006 03:56 AM by mogens	0	98
macro transfer text by Pamela Creighton I have a macro I created to transfer text Transfer Type Export Word for Windows Merge qryname file name has field names no the problem is the qry has a date...	November 16th, 2006 02:51 AM by Pamela Creighton	2	82
Split the names by space by [email protected] Hi, I need your help. I'm trying to break three words in one columns by space into three different columns. example: Address - 45 Waterfront Road (one...	November 16th, 2006 02:32 AM by [email protected]	0	80
Split the names by space by [email protected] Hi, I need your help. I'm trying to break three words in one columns by space into three different columns. example: Address - 45 Waterfront Road (one...	November 16th, 2006 02:32 AM by [email protected]	0	64
Split the names by space by [email protected] Hi, I need your help. I'm trying to break three words in one columns by space into three different columns. example: Address - 45 Waterfront Road (one...	November 16th, 2006 02:32 AM by [email protected]	0	48
Split the names by space by [email protected] Hi, I need your help. I'm trying to break three words in one columns by space into three different columns. example: Address - 45 Waterfront Road (one...	November 16th, 2006 02:32 AM by [email protected]	0	56
Split the names by space by [email protected] Hi, I need your help. I'm trying to break three words in one columns by space into three different columns. example: Address - 45 Waterfront Road (one...	November 16th, 2006 02:32 AM by [email protected]	0	64
Transform and concatenation of column data by Bettergains Hello; I have a tranform query which shows: Row: Col1 Col2 Col3 Col4 Fail: Rpt1 Rpt60 RptA Etc. Fail: Rpt1, Rpt60, RptA, Is...	November 16th, 2006 02:17 AM by Bettergains	2	83
Query for string within an embedded OLE object by TD We have a database which contains records with data for various legal filings. One of the fields for each record is an actual embedded Word document of the...	November 15th, 2006 11:09 PM by KARL DEWEY	6	96
copying results of query to excel by jomara via AccessMonster.com I have a query that collects sales information that includes dates I am copying this to an excel spreadsheet for another dept. I have the date set to short...	November 15th, 2006 09:58 PM by John Vinson	1	63
Automatic Databases Link (Link Tables) by BluesPhone via AccessMonster.com I need help creating a script to automatically link 2 databases from 2 servers. I have successfully connected 2 databases manually under Get External Data --...	November 15th, 2006 09:53 PM by BluesPhone via AccessMonster.com	1	63
INSTR by chris Hi, I have a table of approximately 1400 rows of text. I am trying to break the text into a few fields. The substring that I am trying to break by...	November 15th, 2006 09:30 PM by John Spencer	4	106
'Must be an updatable query' problem by mscertified Can someone explain why this query wont run? I get 'Must be updatable query'. I clicked on Help but nothing made sense. UPDATE tblActivityQuestions SET...	November 15th, 2006 09:25 PM by John Spencer	3	80
IE7 still sux - Firefox 2 RuLeZ by Soundchaser IE7 still sux - Firefox 2 RuLeZ I actually called Microsoft about IE7 and disabling tabs. They ****ed me off and finally admitted there is no way to remove...	November 15th, 2006 09:13 PM by John Vinson	5	89
Months by Dan @BCBS I'm trying to create a value called Months then call the results Jan, Feb, Mar... based on the Closed Date. But I don't want to include the year so that it...	November 15th, 2006 09:05 PM by Ken Snell \(MVP\)	6	94
Nested parameter query by Dale Fye Is there a limit to the number of nested queries that can reference a parameter? I have a series of 5 queries that I use for various levels of analytic...	November 15th, 2006 08:08 PM by Amy Blankenship	6	109
Mact query from a list by M Hernandez I have a table of 1800 names on a master table that I am trying to match to a table of 70,000 vendor names. I want to see a match if the name on the master...	November 15th, 2006 08:02 PM by John Vinson	3	68

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed