A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
"Enter Parameter Value" dialogue boxes by zufie
I can't figure out why when I open my database the "Enter Parameter Value" dialogue boxes for the Date From and Date To textboxes appear on the screen. These...
July 16th, 2009 07:07 PM
by KARL DEWEY Go to last post
2 137
"Enter Parameter Value" when sorting by [email protected]
Hi, I'm a bit of an access newbie, so sorry if this question is a bit daft but I couldn't find the answer in any FAQs. When I have a query like this: SELECT...
August 10th, 2006 10:28 PM
by [email protected] Go to last post
4 86
"Enter Paramter Value" Prompt - how do I stop it? by JohnG
I have a calculation in a query that is as follows M3: **/1000000 The "Lineal" feild refers to a calculated feild in the same queary as this new "M3"...
April 29th, 2007 10:50 PM
by John W. Vinson Go to last post
5 112
"exploding" a field in a record by Hanksor
I need to take a field that has a full name "First M Last" and split it into three different fields. All names use a space to seperate the first, last, and...
October 4th, 2006 04:13 AM
by Marshall Barton Go to last post
2 96
"Expr 1014" if field of query ? by BobC[_3_]
In attempting to troubleshoot some problems in a query, I noticed that three of the fields (design mode of Access 2000) showed "Expr 1014", "Expr 1015","Expr...
February 28th, 2008 01:37 PM
by John Spencer Go to last post
3 275
"Field is too small ..." when running append query in Access 2003 by Jon Ley
Re-post of question from a couple of weeks ago (got no responses). I have an append query that is inserting data into a temporary table. When running it from...
December 19th, 2005 05:29 PM
by Jon Ley Go to last post
7 124
"Find Duplicates" Query by FJquestioner
I have a query to find duplicate invoice numbers. I use the access find duplicate wizard query as follows: SELECT Invoices.AssignorInvoiceNumber FROM...
August 20th, 2006 03:04 AM
by FJquestioner Go to last post
2 103
"floating" date query by Rick Stahl
I have a tblPersonalInfo containing information including dtmHiredDate and strJobTitle. I have another tblPromotions containing info including dtmPromoDates...
November 12th, 2007 01:53 PM
by John Spencer Go to last post
5 104
"Group By" makes Simple Query Run FOREVER by [email protected]
I am stumped! I have a query that uses a function to calculate the total freight for each order. curTotFreight = Nz(DSum("", "tblFreightBill", _ "= "...
June 30th, 2006 11:45 PM
by Marshall Barton Go to last post
8 134
"group by" option not on short-cut menu by dennis@gate
The "group by" option is not on short-cut menu when I right click on diagram pane of query designer. I think this is what I need but am not sure. Here is...
May 13th, 2009 05:59 PM
by Bob Barrows Go to last post
4 101
"If - Then" Return These Records by BM
I have a query based off of two tables. There are date fields in each of the tables (class date and enroll date). The query includes each of the date...
January 14th, 2007 08:11 PM
by Rick Brandt Go to last post
1 136
"If" Statement help needed by Alberta Rose
OK, I have to try this again. I have a convoluted issue and I hope I can describe it clear. I have a report (rptCloseout) that is fed from a query...
January 21st, 2010 07:59 PM
by Alberta Rose Go to last post
6 172
"if" statements by Alberta Rose
I have a convoluted issue and I hope I can describe it clear. I have a form (frmCloseout) that is fed from a query (qryLink). In the design mode of the...
January 18th, 2010 05:25 PM
by Alberta Rose Go to last post
4 162
"if... else" statement in MS Access by ali[_4_]
For example,I Have two tables in MS Access ------------------------------------ Table...
September 6th, 2007 03:02 AM
by ali[_4_] Go to last post
2 68
"IIf dilemma" - John Spencer by BCS
Hello John, Please see my post initiated 10/15. You requested my SQL and the error message to my IIf problem and I've posted them. Please review and let...
October 20th, 2008 03:50 PM
by BCS Go to last post
2 85
"IIf" formula, how to return a value of zero by Alberta Rose
Can anyone help me with this? I need to know where to put the coding to tell the formula that if there is no value in any of the txt's, to return a value of...
January 25th, 2010 07:41 PM
by John Spencer Go to last post
8 141
"IIF" in Criterea area of Query by JohnG
I've created a Microsoft Access2000 form in which users can select several parameters for including or excluding data on a report All brokerage firms or an...
January 13th, 2006 02:18 AM
by George Nicholson Go to last post
3 115
"In" Query Question by [email protected]
I am trying to use the below query to access another Access database that is password protected. When I run the query as-is it says the passowrd is invalid. ...
March 12th, 2007 12:54 PM
by Gary Walter Go to last post
2 124
"Incremental Values from a Table" by Len at BV
I have a table with four fields: Project,Month, HoursSpentToDate, WorkHrsThisMonth. Project is a project name MonthNo is the sequential number of each month...
March 21st, 2006 12:16 PM
by Ken Sheridan Go to last post
3 137
"inter parameter value" by siahman
"inter parameter value" i get prompt "inter parameter value" when i open query . how do i can to prevent it? thanks
January 19th, 2010 06:13 PM
by John W. Vinson Go to last post
3 147
Post New Thread


Display Options
Showing threads 181 to 200 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread 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 06:56 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.