Running & Setting Up Queries - Page 1498

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
Query Parameter - Between and and operator by Maran I want to supply a parameter to a query to define the from date and to date and retrieve data falling under this from and to date. but, i do not want it to...	January 10th, 2008 03:31 PM by Duane Hookom	1	93
Query parameter - getting this from a subform, having problems! by FattyFatty Hi All, I'm come across a brick wall and am after some help! I'm wanting to use the value of a control (a combo box) on a subform in my query as the criteria... ( 1 2)	July 26th, 2006 04:51 AM by Ken Snell \(MVP\)	11	180
Query Parameter - Mask for Password by Lambi000 I have a query that allows users to enter their records based on a User ID and Password, which works great except that when the user enters the...	May 24th, 2006 05:12 PM by [MVP] S.Clark	2	72
query parameter combo box by Jarred I was trying to use a parameter to open a query. I looked at this page: http://office.microsoft.com/en-us/assistance/HA011170771033.aspx I downloaded and...	March 14th, 2006 08:17 PM by Tom Ellison	1	70
Query parameter from listbox by CJ Hi Groupies .........I detest list boxes......however, my database has a couple. I need to be able to capture the value of the item selected in the list box...	August 6th, 2009 04:35 PM by CJ	2	111
Query Parameter Function by Garrett Berneche Long story short I want to filter a query's results based on CurrentUser and the user group they belong to; ie. if the CurrentUser is not in the "Supervisors"...	February 23rd, 2009 11:45 PM by John Spencer	2	100
Query parameter help by Ryan Tisserand IIf(IsNull(!!),,!!) The above parameter works. If there is a date, it filters with that date, if not, no filtering is done. I would like it to restrict by...	December 19th, 2007 07:14 PM by Ryan Tisserand	3	109
query parameter ignored - please check my syntax by iliace This one has me stumped. My question is, basically: "For the two departments in question, list all employees who (a) got paid on 11/27/2006, and (b) had one of...	December 2nd, 2006 12:42 PM by Gary Walter	6	137
query parameter issue by Mark Hello all, I am using access 97. I seem to have a problem when using a parameter in the query criteria and would like to know if this is a bug, or am I...	May 23rd, 2005 02:49 PM by Mark	4	104
Query parameter not working when expression points to form field by Brady I have a cross tab query with a where clause. I want the where clause to get it's value from an open form using the syntax. !! This works just fine with a...	September 2nd, 2006 08:04 PM by John Spencer	4	105
query parameter order by AccessMan I am requiring the user to enter three parameters for a query and I'd like to control the order in which they are prompted for. Two of the parameters are...	May 7th, 2008 07:34 PM by John Spencer	4	98
Query Parameter Prompt for = by kalexander I have a query in which I'm trying to set a parameter prompt on a calculated field called "Weeks Since First E-Mail." This would allow the user of the query...	August 21st, 2006 04:02 AM by [email protected]	1	81
Query Parameter Syntax by croy When I enter, "Between !! And !!" on the criteria line in a certain query (qryA), it runs fine. But later on, when I base a crosstab query on qryA, I get...	August 17th, 2009 04:00 PM by croy	6	157
query parameter? by js Hi, how to create a query can accept parameters, and how to avoid that(sometime I see a popup box for asking parameters for this query: select * from tb1 where...	April 25th, 2005 03:48 PM by [MVP] S.Clark	1	81
Query Parameters by Mark D.[_2_] I am trying to create an employee turnover query. The table I am pulling from has the employees name, hire date, and termination date. Of course all the...	June 4th, 2009 12:47 AM by KenSheridan via AccessMonster.com	2	102
Query Parameters by Khartoum I am currently setting up a database for managing sickness absence. The dates are recorded as follows: 1st date of Absence Last date of Absence Number of days...	October 25th, 2007 01:56 PM by John Spencer	1	81
query parameters by Patrick D. Hi I have a stored query in a accdb-database: UPDATE Table SET Field1 = WHERE =; Running the query I am just prompted for one parameter. It must be only...	December 3rd, 2009 08:13 AM by Patrick D.	2	196
Query parameters - select from table column? by Dorian BY embedding something like: WHERE T.Team = in my query I can promt for a team However, is there any way to create a prompt that allows for selection of a...	March 30th, 2009 09:14 PM by John W. Vinson	4	70
Query Parameters error of the Upsized database by Niroshana I have upsized my Access 2007 database to SQL server 2005 database (Front end Access Database and Back end SQL server Database). Following Adp query does not...	December 8th, 2009 02:42 PM by Niroshana	0	768
Query parameters for search by Igor via AccessMonster.com Hi all out there.. Am I on the right track? I have set up a query to search my records. I want to search by 6 fields which are inputted from a Form. I am...	May 24th, 2006 03:17 PM by Klatuu	1	76

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