Running & Setting Up Queries - Page 42

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 42 of 2165

Threads in Forum : Running & Setting Up Queries

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
What does "expression" refer to in the Totals list in a Query? by Joshcat99 In the drop-down list in the Totals row in a Query grid, what does "expression" refer to? How do you use it?	June 9th, 2006 02:48 PM by Marshall Barton	4	138
What does "Alike" in the filter criteria mean? by Shawn When I type a filter in the query design for 5154* it returns Alike 5154 and does not work although 5154 exists in my database. If I type Like "5154"...	January 19th, 2006 09:52 PM by MGFoster	1	110
What does & ", " & means ? by SpookiePower I found this query in the Northwind sample database. SELECT Employees.EmployeeID, & ", " & AS ReportsTo FROM Employees ORDER BY Employees.LastName,...	June 21st, 2007 07:03 PM by SpookiePower	4	109
What do you think of the new Windows ?? by Nnigma3 Hi All - I just found this site and it got me thinking... http://www.windows-vista-update.com It has alot of new information about the Windows Vista and...	April 26th, 2006 06:17 AM by John Bokma	7	105
What do I use for this querie? by James I am using Access 2003 and I am trying to get all the colors that are not shipped by supplier S1 using a querie? Thanks for your support. James	July 6th, 2004 02:25 AM by John Vinson	2	132
What do I need? by [email protected] Ok, I don't really know how to accomplish what i want. I have a query that returns results based on an audit. The query returns results of the last three...	December 19th, 2006 02:55 PM by [email protected]	7	75
What do I need: multiple nested IIF? Switch()? DateDiff? by AccessNeophyte Hi again, I have a situation that may call for either a multiple nested IIF, or a Switch(), or a DateDiff, something else I haven't even heard of. Basically,...	May 24th, 2007 05:06 PM by AccessNeophyte	2	92
What do I need to enter - pop up "Enter Parameter Value" by Marcus in Critera i have entered the following : LEFT(,2) To trim the week number from another column. When I try to view the query, I get the pop up "Enter...	October 13th, 2008 06:54 PM by Rick Brandt	1	57
What do I enter in Criteria to query yes/no checked boxes? by bryce_akagi I have a database set up with yes/no data. The data is displayed as checked/unchecked boxes. I want to run queries that will return only those records that...	June 9th, 2005 06:30 PM by Rick B	1	118
what determines if you can add a record to a query? by MattE I have two queries, each based on a simple single table (a different table for each query). One allows me to add a record and the other does not (either...	October 4th, 2006 07:10 PM by MattE	2	121
What determents is recrordset updatable or not? by Domac Query based on sums etc. (Aggregate) is not updatable , but what determents is query updatable or not! I have query that uses GroupBy query to retreive...	May 17th, 2006 03:16 PM by Domac	2	79
What criterion would I use to ask a user to select a value from a by sk Hi all. First, thank you in advance for assisting me. I really appreciate what these forums do for users like myself. My question: I'm trying to create a...	January 15th, 2009 02:59 AM by sk	2	70
what criteria will select a blank in a date/time field? by challems I have a table with a field (date.time) showing sales dates. I am trying to write a query that selects the records that have a blank in this field. ...	January 5th, 2006 05:51 PM by Duane Hookom	1	71
What criteria to use to extract #Error messages in a query by Johan Nel I have a table containing in excess of 100 000 records. I am running a query with a calculated field to determine the age of members from a DOB field....	October 16th, 2007 02:47 PM by Johan Nel	4	62
What character(s) is(are) used to preface comments in Access SQL? by John I want to accomplish as simple task - adding comments in my sql so that it is documented. Nowhere can I find this in the MS documentation or via a web...	December 4th, 2009 05:54 PM by Bob Barrows	4	166
What causes the "#Name?" error in text box? by Richard Hollenbeck Once I get this working I'll need to use this code several times in one form or report. The following code typed into a text box returns the "#Name?"...	September 29th, 2004 06:02 PM by Richard Hollenbeck	4	163
what causes an error that says: "Too few Parameters. Expected 1." by Paul I'm trying to use the following code to test whether there are any records in a recordset, but when VBA tries to run the line containing the SELECT...	February 1st, 2009 12:59 AM by Paul	3	79
What can I put in my query to show that a field bein duplicated by Big Mike What can I use in my query to warn a data entry person that they are keying in a duplicate record. Thanks, Big Mike	February 1st, 2006 12:54 PM by John Spencer	1	48
What can I enter in a promp criteria for the query to show all? by Genio I have made a Query out of a list of clients and have also selected a "criteria" but what if I whant to see the complete list? What can I write so that the...	November 15th, 2005 10:20 PM by John Vinson	2	79
What are the steps to change numbers to currency in queries? by ebrar hiiii i want to know the answer of this question today i really need it i seach alot but find nothing i hope will you find the answer this is a question: What...	December 17th, 2006 11:35 PM by Tom Lake	2	110

Page 42 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 05:01 AM.