Running & Setting Up Queries - Page 2153

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
Find a date in many columns and put that date in another column by Sandy Hello - I have several columns labeled V1, V2 . . . V10. Each record may be blank or it may contain a date in one or more of the columns. I need to find the...	June 3rd, 2004 05:11 PM by John Vinson	2	423
Count Unique numbers by Johnny I have two columns: Job Number and Part Number. Since most jobs consist of more than one part the Job Number may repeat in this column as I list all the Part...	June 3rd, 2004 05:08 PM by Gerald Stanley	1	405
Top 5 by Heather Hello, Is their a way to get the top five per each ID. So say each ID has 21 funds, I want the top 5 sales for Each ID. ID Fund Amount 1111 A ...	June 3rd, 2004 05:03 PM by Heather	3	146
Percentiles by Tony Does anyone know how to calculate a percentile in Access' Query? I run reports where I need to show Min, Max, Avg, and a certain performance percentile, and...	June 3rd, 2004 01:32 PM by Jeff Boyce	1	144
Query Problem by Niall I have a query which shows me the following data: Name 2003 2004 2005 Joe 5 6 7 Bob 8 9 ...	June 3rd, 2004 01:24 PM by Jeff Boyce	1	345
query to select one record using report name by Nasos I have a report which is based on a table which contains one record for each of my reports (title, code no etc), I want to create one query as the record...	June 3rd, 2004 01:20 PM by Jeff Boyce	5	867
Changing a column type in sql by Andy Levy Hi Is it possible to change the column data type in an sql statement I have a table column which is set as text data type. It only contains numbers, but fir...	June 3rd, 2004 11:52 AM by Allen Browne	1	405
Simple Query Question by Rebecca Greetings. I deeply appreciate the help the MS MVPs have given me (especially John Spencer). I have a quick question about the following query that Mr....	June 3rd, 2004 10:59 AM by Allen Browne	1	386
line breaks by Grimble Gromble I'm trying to use an update query to concatenate several text lines into a single memo field with line breaks. I can't seem to find which character to use for...	June 3rd, 2004 09:27 AM by	4	332
Query won't run but copy will by John Has anyone ever seen this problem before? I have a simple update query (that has been running daily for months with no changes or problems). Now...	June 3rd, 2004 08:57 AM by Nikos Yannacopoulos	1	524
FINDING THE "#" CHAR by Mike Could anyone help me ? when used in a query what would be the best way to filter out everything that had a # in the text field any help would be...	June 3rd, 2004 08:47 AM by Mike	3	210
Need help to write a query that returns a value for a given date by salesi Can someone kindly assist me on writing a query on the current table below that will return my desired result (also detailed below). Current Table Date ...	June 3rd, 2004 08:41 AM by Van T. Dinh	1	405
Access 2000 Crashes when creating a query using the wizard by Dale Hobbs I have a user who has a brand new installation of Windows 2000 Server and Office 2000. When they are trying to create a query using the wizard, access crashes....	June 3rd, 2004 08:23 AM by Allen Browne	1	612
DLookup by Chris Can it be used multiple criteria for the DLookup function in the validation rule for a control on a form?(Ex:For every control except the first one, the...	June 3rd, 2004 05:57 AM by Chris	3	622
Query/Report Setup by bnichols0330 I have a table set up with Group Name Q1 Q2 Q3 Group 1 Yes No No Group 2 No ...	June 3rd, 2004 03:05 AM by Duane Hookom	1	376
Counting or Grouping Rows by Chuck I have inherited a table with information that looks something like this: Name Fruit John Apple John Orange John Pear Jane Apple Jane ...	June 3rd, 2004 03:03 AM by Duane Hookom	1	238
Dates and MTBF by Ana Hi, I have the following columns: Vehicle# DateRepair	June 3rd, 2004 02:09 AM by fredg	1	123
Query by CGibbons Is there any way to share a query? I have created a complex query that i need to email to someone so they can use it with a table. This person is computer...	June 3rd, 2004 01:50 AM by John Spencer (MVP)	1	228
type conversion erron in update querry by Leonard Hart Where do I look for the problem with the error message fields not updated because of type conversion error.	June 3rd, 2004 01:11 AM by John Vinson	1	244
SQL field limit by imAGine I have imported a querry from Microsoft Querry that extracts data from a SQL Table. The SQL table has more fields than can be viewed using Access. Is there a...	June 3rd, 2004 01:08 AM by John Vinson	1	120

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