Running & Setting Up Queries - Page 108

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
Urgent - problem exporting over 500000 records by x-rays Hello All, I come back with the problem I face, cause no solution suggested, this also happened cause I did not provide clear info. I'm using Access 2003 but...	July 25th, 2006 03:11 PM by Charles E. Vopicka	1	79
URGENT - Need to match debits and credits by toukey I have a query 'pos' that extracts all the positive amounts from a table called client_os and another query 'neg' that extracts all the negative amounts from...	October 31st, 2006 07:25 AM by John Nurick	1	68
URGENT - How to convert this decimal values into hours? by Marco Hi. I'm having some problems in converting decimal values into hours. Sometimes my decimal values are less then 1, that means that the hours are less then...	October 23rd, 2007 03:31 PM by Marco	2	102
URGENT - Getting hours totaled for the month by HeatherLou1974 I have a database with our subcontractors and the hours that they worked daily. What I need to do is get a report to total the hours that the subcontractor... ( 1 2)	March 8th, 2005 12:08 AM by John Vinson	10	234
Urgent - deleting partial amounts of a field by Nikhil hello, I need to delete the last 11 characters in a field. I have used Right(,11) which displays the characters i need to delete, but i do not know how to...	June 24th, 2004 11:59 PM by JulieD	3	113
Urgent - Create column on query depending on another column text by Fred HI.. i need help on solving one big problem i can't get the solution.. I have a query that gets some values and also a month text from one table.. based on a...	May 22nd, 2008 07:25 PM by Jerry Whittle	1	128
Urgent - Calendar - Need 7 days for week selected by Jani Using Access2003. This db has a calendar popup form (thanks Allen Browne). The textbox for the date selected is named 'weekloaddate' and the default value is... ( 1 2)	January 4th, 2008 12:51 PM by Jani	11	139
URGENT !!!! PLZ HELP by hafsa_aziz i have a major problem with my exam database which i have created for my IT A2 Project. i have a no of delete and append queries which are run together as...	April 12th, 2007 07:49 PM by hafsa_aziz	2	151
urgent ! outer join not picking all records by questy SELECT a.Field1, a.Field2, a.Field3, b.Field1, b.Field2, b.Field3, c.Field1, c.Field2, c.Field3 FROM (query2 AS a LEFT JOIN query2 AS b ON a.Field1 = b.Field1)... ( 1 2)	April 29th, 2005 11:29 PM by Van T. Dinh	10	181
urgent ! Delete Dupe records and also Append Fields by vbastarter Hi I have table PROCESS with 250,000 records in it. TWO fields ID, BatchName are in this table. Problem 1: Some records get repeated for same ID, with same...	February 25th, 2005 01:49 AM by questy	4	336
urgent by SHIRA each two row in my table is duplicate ,how to take out duplicate rows?	November 15th, 2005 10:51 PM by [MVP] S.Clark	2	67
Urgen Query Help Needed by tmdrake[_2_] I have a main form that the user can select a ProjectID. When this is selected a subform displays all the records in that table for that ProjectID. My...	May 20th, 2008 12:29 AM by Evi	1	76
upsizing to sql 2005 by Dee I am using the upsizing tool to slq 2005 from access 2003. I have three tables which use 100's of queries. Some if the primary keys to the three tables may... ( 1 2 3)	October 23rd, 2007 02:27 PM by Michel Walsh	26	259
Upsizing to sql 2003 by Dee How do I create an Access database front-end to an SQL Server database back-end so that you can create a front-end/back-end application (front-end/back-end...	October 18th, 2007 04:35 PM by Michel Walsh	1	86
Upsizing failed on IIF by Dkline I just did an upsizing to SQL Server 2000. In the MDB file I had this...	February 7th, 2005 03:13 PM by Dkline	4	265
Upsize to SQL by apex77 My Access database uses a front end (containing forms, queries and macros), and a bcak end (tables). I have recently upsized the back end to SOL. Now my...	August 19th, 2008 03:38 PM by Dale Fye	2	100
UPSERT Query Performance by [email protected] I have a large table (almost 4 million records, 12 fields) in Access that is cleared and re-populated over a WAN connection on a daily basis. It is time...	May 26th, 2009 03:48 PM by [email protected]	3	139
UPSERT Query Performance by [email protected] I have a large table (almost 4 million records, 12 fields) in Access that is cleared and re-populated over a WAN connection on a daily basis. It is time...	May 26th, 2009 03:45 PM by [email protected]	2	124
Uppercase to ProperCase Update Query needed by Bikini Browser I need a query written that will change everything in one Column in One table to Propercase versus upper case. How do you do that? (I am not a programmer...	October 16th, 2006 08:31 PM by [email protected]	2	76
Uppercase and * in search query by Wind54Surfer Hi all, I am using the following: If Me.txtDescription "" Then varWhere = varWhere & " LIKE """ & Me.txtDescription & "*"" AND " to search but...	September 28th, 2009 04:57 PM by John Spencer	5	100

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