Running & Setting Up Queries - Page 12

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.

		Home » OfficeFrustration forum » Microsoft Access
Running & Setting Up Queries

Home

Page 12 of 2165

Threads in Forum : Running & Setting Up Queries

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
query field reference help by -dch I am running Access2002 under Windows XP Pro. I have built a query as a row source for a listbox on a form. The first version of the query is working...	June 2nd, 2004 07:30 PM by	4	1,695
Week number problem by Mike Collard I have a table that holds average values by week number - the last week held is currently week 21 so I now need to add data for week 22 and week 23. If the...	June 2nd, 2004 07:38 PM by Mike Collard	2	779
I am getting incorrect responses to complicated Count() Query... by Gary B MASTER Table: CHARGES Fields: ChargesKey, ChargesDate Data: Row1 = 1, 01/15/2004 Row2 = 2, 03/20/2004 Row3 = 3, 04/25/2004 DETAIL Table: SERVICES Fields:... ( 1 2)	June 2nd, 2004 08:37 PM by Michel Walsh	14	553
Matching Data by Mark R. I have a query where company name fields from two different sources need to be compared. I need an expression (or something) that will compare the first 15 or...	June 2nd, 2004 09:06 PM by Mark R	2	300
Query truncates data by Jake Hello, I've created a query that contains two queries, with a left outer join. The query duplicates values if I don't set the query properties to...	June 2nd, 2004 09:56 PM by Michel Walsh	3	571
Query - Not equal to by Annick N. Hello all, I have two tables that have employees IDs as key fields. I am trying to create a query to fetch all of the employees IDs that do not match with...	June 2nd, 2004 10:34 PM by Ted Allen	3	257
SQL statement by Floradee I need to run a query in Access that will give us the clients who have not given us work since 2001. The problem; there are clients who have been giving us...	June 2nd, 2004 11:51 PM by Floradee	5	402
Can I setup a search engine? by Scott How do I create a search engine of some kind for my database? (without having to setup a new query everytime) I have a database which contains a library of...	June 3rd, 2004 12:41 AM by John Vinson	1	375
Selecting first record by In a sorted table, is there a way to select the first record for a group?	June 3rd, 2004 01:05 AM by John Vinson	1	322
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
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
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
Dates and MTBF by Ana Hi, I have the following columns: Vehicle# DateRepair	June 3rd, 2004 02:09 AM by fredg	1	123
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
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
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
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	611
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
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
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

Page 12 of 2165

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is Off HTML code is Off

Forum Jump

All times are GMT +1. The time now is 12:02 PM.