Running & Setting Up Queries - Page 1096

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
Need a query by Lori I have a field called position code (PC), this can have many different values. What I need to pull all PC's that are 1010, if not then 1005. but not both....	November 29th, 2006 06:25 PM by Lori	4	113
how can I select partial data from a field? by Dale Fye Krista, How are you going to use this information, and what do you want to do if the name does not contain the hyphen? I find it easiest to write a function...	November 29th, 2006 06:24 PM by Dale Fye	0	88
Part Numbers Change after Importing by Nanette I have an Excel spreadsheet that I imported into Access. Some of the data (Part Numbers) are coming in strange. The part number in Excel (9000175) turns into...	November 29th, 2006 06:23 PM by Nanette	0	94
Query: Sum column with Duplicate Values by Aquestion I have created a query with the following column names Month Name Month Number Cost Center Manager Team Leader Hours Each manager has various team leaders....	November 29th, 2006 06:06 PM by Aquestion	0	89
filtering different types of record with same date and finding by Klatuu I must have misread your original post. It sounded like you wanted only the most recent visit for 3 or 4. "KerryF" wrote: Sorry, I don't think I made the...	November 29th, 2006 05:56 PM by Klatuu	0	89
A union B works, A union B union C fails by Phil Smith Each individual query is fairly simple. One table has fields for three possible sales reps, I need to treat them as as one set of fields. Each query is...	November 29th, 2006 05:50 PM by Phil Smith	2	71
Changing Time From Minutes to hh:mm:ss by TheNovice Good morning all and Happy Holidays, I have a simple one. I have a formula that I am using with is great, but when it converts minutes it gives me a total...	November 29th, 2006 05:41 PM by TheNovice	0	90
Average Of The Best n Results by EA Can this be done in Access? I have query which returns all the results for a criteria. What I want is another query which determines the total of the top n...	November 29th, 2006 05:23 PM by Allen Browne	3	126
Help with a delete query by Tony Williams Could someone help me with a delete query? I want to build a query that deletes the data in specific fields I have a table which has a date field and I want...	November 29th, 2006 05:16 PM by Tony Williams	4	112
data missing in query by jomara via AccessMonster.com I have a parameter query that has worked fine for 2 weeks this morning i went to run the query and yesterdays data is not there. If i go to the table where...	November 29th, 2006 05:14 PM by Jeff L	1	136
Trim and Distinct by Nanette I have some new data in a table that I need to clean up. How do I use Trim ( ) and Distinct?	November 29th, 2006 05:14 PM by Nanette	0	68
Combining multiple records by summing by [email protected] Hello, Hope you are doing well. I am somewaht basic in my databases, and am not good with code. I am trying to build a query that will pull a bunch of info...	November 29th, 2006 05:11 PM by Marshall Barton	5	83
how can I select partial data from a field? by Krista Looking for a way to select a part of a name up to a certain character... ex - I have a name with a hyphen "-" in it, I want to select the first part of...	November 29th, 2006 05:06 PM by Krista	0	70
Format a number within a SqlString by Duane Hookom I'm not sure why you only provided a small snippet of your WHERE clause since this part doesn't return a field/column. When creating SQL statements in code,...	November 29th, 2006 05:01 PM by Duane Hookom	0	80
filtering different types of record with same date and finding by KerryF Sorry, I don't think I made the question very clear. The number shown is a Unit number and I need the last visit for each unit (number) which is type 3 or...	November 29th, 2006 04:40 PM by KerryF	0	71
How to insert values on blanl fields by Marco Hi. I've got several records that have no data on some columns. I want insert zeros on those records witch has no values, but on the records that have values...	November 29th, 2006 04:21 PM by Klatuu	7	99
Putting Column Values into Column Headings by [email protected] My apologies if this has been answered elsewhere - being a complete SQL newbie I don't know what to look for. I have a table that looks something like...	November 29th, 2006 03:58 PM by [email protected]	3	74
Format a number within a SqlString by Sandy I am building a SqlString within a procedure and I would like to make the query results of this field as Format(,"0.##") but can't get the syntax...	November 29th, 2006 03:49 PM by Sandy	0	73
filtering different types of record with same date and finding max by Klatuu You don't need to use the MaxOfDate. Order the query by Date Descending and ID Ascending. Use the TOP 1 predicate. It will return the most recent date and...	November 29th, 2006 03:31 PM by Klatuu	0	76
Duplicate Record query by Jerry Whittle It's the MOD field being blank. Actually 'blank' is incorrect. Rather it's Null and Count doesn't count null records. If it was an empty string or spaces, it...	November 29th, 2006 03:18 PM by Jerry Whittle	0	91

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