Running & Setting Up Queries - Page 999

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
Imediate IF problem by Andi Lee Davis Hi either of these Formulas still results in a null value in column Description2 against the value "TEXT" in column Descripton Description2:...	February 2nd, 2005 04:37 PM by Andi Lee Davis	4	142
Immediate If Function by Nancy Can someone explain what this is? I have tried to find answers to my questions first by reading through other people's questions. I keep seeing this and have...	June 1st, 2005 01:40 PM by Nancy	2	70
Immediate IIF() problem by Marc Miller I have a string field with 'numeric' values (abbas) and another string field (abbas_sign) that contains the indicator for the value's sign. It contains a 'D'...	May 19th, 2007 03:33 PM by Douglas J. Steele	1	230
Implementing a Hierarchy in MS Access by Flavelle Ballem Given a table with the following: ID : int (autonumber) ParentID: int (nullable) Information: string .... and a self-join, where if a record has a Parent,...	May 9th, 2008 08:59 AM by Peter Yang[MSFT]	5	136
Implementing Oracle's MINUS set operator in T-SQL by DeadManWalking Hi, Does T-SQL provide an operator that similar to minus in Oracle? Or What is the sytax to retrive the result set between the 5th record to 10th record? For...	April 7th, 2005 02:50 AM by '69 Camaro	1	83
Implementing the "keyword search" feature in ACcess by geetha Dear all, I have a Microsft Access database with all the research capabilities of professors of a university. I need to implement a "keyword search" feature...	November 3rd, 2006 04:07 PM by Rick B	1	52
implicit call to a control in a form??? by Jim Tanis I have three tables, tbl1, tbl2, tbl3 tbl1 has three fields, one is autonumber primary key. tbl2, tbl3 have one field each that relates to tbl1,ID field I...	April 19th, 2005 02:29 PM by JohnFol	3	105
Implicit JOIN to Explicit with 3 non-nested tables by TheMath This query with implicit JOIN works fine. select * FROM A, B, C WHERE C.ID = A.CID AND B.ID = A.BID table A ID BID CID	May 23rd, 2007 03:00 PM by Michel Walsh	4	85
Implied Decimal Point by The Dow Is there an easy way to handle implied decimal points? I have a field with 10 places, 8 before the decimal, 2 after. (e.g 123456890 = 12,345,678.90). I...	December 8th, 2007 04:35 PM by Duane Hookom	3	117
Import by Richard via AccessMonster.com Hi all, How can I append or import one spreadsheet into two related tables? I have an empty database that has two tablesâ€™ 1:M. Part of the spreadsheet goes...	August 18th, 2009 08:32 PM by John W. Vinson	3	101
Import a Query by Dwight Can a query be programatically imported from 1 database to another? If so, please let me know how. Thanks in advance! Dwight	April 1st, 2009 10:00 PM by Marshall Barton	1	64
Import Access Choose function into Excel spreadsheet - issues! by George Good Afternoon, This is my first post and I hope that I came to the right place. I have scoured the web for answers, but it seems to no avail. I have an...	August 13th, 2009 05:47 PM by George	0	105
import and append excel file to main table and sub table by socasteel21 via AccessMonster.com I have a table called "tblClaim" that stores information such as customer and machine information. There are 2 sub tables, one for parts replaced and one for...	June 26th, 2006 03:32 PM by socasteel21 via AccessMonster.com	9	125
Import data by Renetta I have a weekly excel spreadsheet that I need to import. One of the columns reflect SSN's, however those SSN's reflecting a leading zero(s) drop off during...	February 14th, 2007 05:51 PM by Jerry Whittle	1	136
IMPORT DATA by angie i want to create a query that deletes all data from a table and then imports new data from a text file. can i achieve that? i want to avoid running the table...	December 29th, 2005 05:55 PM by John Nurick	2	119
Import Data - Column names in one column in Excel by Major via AccessMonster.com Is there a way to import data from excel into Access when the column names are in one column? Everything is in one column. For instance, column A as Column...	March 24th, 2006 12:52 AM by Jeff Boyce	1	96
Import data directly from Word forms to Access 2003 tables by CZ I'm trying to automatically transfer a word doc that has shaded fields to a database table. I found a proceedure from Access 2000 but is doesn't work with...	April 6th, 2007 03:28 PM by CZ	0	81
Import data from "; delimited txt file" by Richard I need to import several txt files(; delimited) into tables on a daily basis. from these tables I require only parts of the inforamtion in the tables. What is...	February 4th, 2009 11:50 AM by Stefan Hoffmann	1	80
Import data from Excel by Boon Hello, I have a big excel file that contains 80 columns and 35000 rows. I have about 20 of this files. I would like to import all of them into Access. What...	October 21st, 2008 01:14 AM by Lord Kelvan	2	77
Import Data from Oracle - Microsoft Query Working by Wags Hi, I'm Having trouble getting my data to import into excel. I have got my query working fine in Microsoft Query. When I run it in excel it sits...	March 30th, 2005 07:23 AM by Wags	0	83

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