Running & Setting Up Queries - Page 1508

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
[microsoft][odbc visual foxpro driver]function sequence error (#0) by Dundoan Hi All, I am trying to connect to a free table Foxpro 2.6 table from access 2003 using ODBC, Visual Forpro Driver 6.01.8629.01 and I get the above error. If I...	January 18th, 2006 03:37 PM by Cindy Winegarden	3	142
can you use action queries with user-level security by bill_s Is it necessary to use action queries with user-level security??	January 18th, 2006 03:34 PM by Michel Walsh	1	95
Update Query by Paul W Smith I have two tables, one contains the highest score each team has ever achieved - this has been manually built loaded from the leagues historical records. I... ( 1 2 3)	January 18th, 2006 03:29 PM by Duane Hookom	20	273
Multiple parameters by LizJ Can someone help. I need to retrieve peolple's addresses from a table. The only criteria I can use to identify these people is their ID number (an auto number...	January 18th, 2006 03:26 PM by Duane Hookom	4	116
How do I query any combination of 7 fields - 4cbo and 3 txt by Richard Horne Hi guys, bit of a tricky one here and I can't seem to find satisfactory answers anywhere so hoping you can help. I have a form which contains 7 parameters. 4...	January 18th, 2006 03:22 PM by Duane Hookom	2	70
Comments in queries by Jonathan Is there a way to put comment lines in in an Access query? e.g. ;Comment ;Comment SELECT ... ;Comment Thanks, Jonathan	January 18th, 2006 02:59 PM by Roger Carlson	3	100
bar code script by shank I need to update a bar codes field for hundreds of records. Does anyone have a script that I can use to accomplish this in an update query? I'd like to...	January 18th, 2006 02:45 PM by Michel Walsh	1	75
Queries Taking too Long...... by Roman B. We have 10 users using access XP 2002, all are connecting to an access database with about 300,000 records (150meg DB). and currently it is taking about 6-8...	January 18th, 2006 02:31 PM by Jerry Whittle	3	93
Calculating difference between FirstOF / LastOF by Winger I have a table which logs various dates for a project, and the field name is "Date_Of_Change". As multiple dates can occur for a project, I have a query that...	January 18th, 2006 02:29 PM by Bob Miller	3	113
Append and Update 10% of records to say "Yes" and other 90% say "N by consjoe I have a main table and a completed table. At the end of each week an append query is ran to move all comleted records from the main table to the completed...	January 18th, 2006 01:24 PM by Brendan Reynolds	3	97
A question on database design by Simon Harvey Hi everyone, I'm hoping someone could give me some advice on how to achieve the following. I'm making a system that stores information on holiday homes. In...	January 18th, 2006 11:16 AM by Simon Harvey	5	90
Field values associated with Min or Max value in Group by Totals Q by Catchy MS Access Database (Office Professional 2003) When obtaining a minimum ("Min") or maximum ("Max") value for a group of records obtained through a Select Query...	January 18th, 2006 10:44 AM by Allen Browne	1	87
Query for Combo Box Selections by Ann Hello - Please bear with me as I am an amateur! I have a form that has a subform that contains a combo box. A user can select numerous items from the box...	January 18th, 2006 08:58 AM by Van T. Dinh	2	80
run query for the system day by Mark_Milly Hi Guys, I need to now redo the below SQl to show not todays date but one week from today to send out birthday cards etc, can anyone help me please? Cheers...	January 18th, 2006 07:42 AM by Van T. Dinh	2	88
SQL Query view behaving strangely by Damon Heron I have searched MS and can't find an answer to this bizarre behaviour. When I am editing an existing sql statement, the cursor will not stay in one place, if...	January 18th, 2006 06:24 AM by Marshall Barton	1	110
1-to-many relationship, i want only the last subtable entry by jlwoods1 I have a one-to-many relationship and want to display the master record and only the LAST sub-table record.	January 18th, 2006 03:41 AM by Tom Ellison	1	119
paramater Queries by JUSTIN HOBBS We are trying to create a generic paramater query that will work for many applications. Is there any way to set it up so that certain criteria are...	January 18th, 2006 03:17 AM by Duane Hookom	1	88
How can I concatenate a MEMO field and a text field? by kvogler I have a make table query in Access. I am attempting to create a "MEMO" type field in an expression. If I have wkcomment: M_COMMENT and M_COMMENT is...	January 18th, 2006 02:37 AM by Dale Fye	1	292
Free mp3's by Jickles HTML HEAD META NAME="GENERATOR" Content="Microsoft DHTML Editing Control" TITLE/TITLE /HEAD BODY PAnd much more that that!/P PA...	January 18th, 2006 02:31 AM by Jickles	0	107
Problem with query results by Jim Hello, I have an Access 2003 query that changes descriptions for a bill of lading based on the hazardous content. For example "0 " is not, "1" is hazardous and...	January 18th, 2006 02:23 AM by Jerry Whittle	6	97

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