Running & Setting Up Queries - Page 486

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
Decimal format by Jasper Recto I have a query that does some calculations. One particular column is a statement that says something like this: ColumnE = If (columnA = 'HR', ColumnB *...	July 28th, 2008 06:24 PM by Jasper Recto	0	75
Query to take count and find most likely by Jordan[_3_] We are trying to build a query to diagmose our products by the tests they fail in our automatic testing machine. Engineers will be able to look at symptom...	July 28th, 2008 05:35 PM by Jordan[_3_]	4	109
Combining Fields by RoadKill This is a stupid question, but I just can't seem to remember how to do it. I want to combine the two fields of 'FirstName' & 'LastName' in one field named...	July 28th, 2008 05:22 PM by Bob Barrows [MVP]	4	103
query to sort nos by cliff i have the following data cdate nos total of digits(int+mod of nos) 24/7/2008 12 3 24/7/2008 16 7 24/7/2008 23 5 24/7/2008 35 ...	July 28th, 2008 05:11 PM by KARL DEWEY	2	91
Importing Access 2007 (ACCDB) into Excel by RNDL Forever, I've created data links in Excel that imported Access queries. This allows me to do higher arithmetic and prettier graphics. Now I've moved to...	July 28th, 2008 04:56 PM by RNDL	0	112
Pivot table problems by gibsol I have a large database currently 6500 lines of data but will grow to a very large size by the end of the year. I am attempting to analyse the data using a...	July 28th, 2008 03:42 PM by gibsol	0	73
Nearest matching date value by Pam80 I have two tables T_1 WELL1 DT_1 TEMP MEAS_ID_NUM A1 3.7.2007 5 1 A1 ...	July 28th, 2008 01:22 PM by John Spencer	1	111
Sort out earliest date by vitality Hi Everyone, Does anyone know to sort the earliest date (single result) from different rows? Sample as below. Fields: â€œInvoice Numberâ€ & â€œInvoice...	July 28th, 2008 10:14 AM by vitality via AccessMonster.com	2	141
filter a query by gibsol I have a large database, in which are listed "period", "Model","MPC" and "Country". What I am attempting to do is filter the query by one or all of the...	July 28th, 2008 09:40 AM by gibsol	2	98
query to sort data by cliff i have the following data cdate nos 24/7/2008 12 24/7/2008 16 24/7/2008 23 24/7/2008 35 24/7/2008 42 25/7/2008 16 25/7/2008...	July 28th, 2008 08:33 AM by Allen Browne	3	149
Last date in a date range by woods1119 How do I query the last date in a date range? For instance I want the last date a person was here between 01/01/2007 and present. I cannot use "Between...	July 28th, 2008 02:25 AM by Ken Sheridan	2	101
Directions to Resources by Padda-Juan Hello, recently completed New Horizons 4 day Access 2003 class. I have inherited some data bases that the level of instruction did not cover. For instance,...	July 27th, 2008 05:06 PM by Allen Browne	1	98
ACREDITE FUNCIONA!!!!! by [email protected] Ganhar dinheiro rápido e honesto meu blog http://jet72.zip.net/ : QUER GANHAR UM BOM DINHEIRO? FAÇA COMO NÓS ! : COMO TRANSFORMAR 12 REAIS EM NO MINIMO...	July 27th, 2008 04:47 PM by [email protected]	0	88
Posting Calculated Data to a Table by Sean Bishop Hello, I am using Access 2000 Having done a series of calculations through an UpDate query I want to post the results in a Table truncated to 2 decimal...	July 27th, 2008 04:09 PM by Jeff Boyce	3	105
How to calculate an accumulated balance by Laxanh Hi - CustNo TransDt TotalChargeAccumBal A100 2/4/2008 100 100 B201 4/8/2008 300 400 A102 5/3/2008 200 600 I have a table of fields like custno, transdt,...	July 27th, 2008 03:03 PM by Laxanh via AccessMonster.com	4	86
Display Graph Data Table with Integers rather than decimals by BarryL I have created a query using SQL to calculate the percentage response rate to a questionnaire e.g. (32.8402366863905). I am using this query to display a...	July 27th, 2008 01:05 PM by BarryL	2	101
Adding items from another query in a form by Jasper Recto I have a continuous form (frmProduction) that was created from the query qryLabor. I have another query called qryLaborSum that uses the qryLaborCosts to sum...	July 27th, 2008 10:53 AM by Graham R Seach	2	86
random number generator by aspgk Hello: i want to set a value.. call it delay time... using an access function that would statistically select a number with a range... say 1-100. Is this...	July 27th, 2008 02:55 AM by John W. Vinson/MVP	6	114
Simple Combo Box by Jasper Recto I have a text field where a user enters a part number. From that part number, I want a combo box to list all the different revisions it has. How would I do...	July 27th, 2008 02:31 AM by John W. Vinson/MVP	7	78
New query in front-end: " is not a valid name by PattiB I have just started using Access 2007, and I am converting from an old, but very reliable db. I am trying to re-create a query based on two tables. In... ( 1 2)	July 26th, 2008 05:54 PM by bcap[_2_]	11	164

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