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
=[BeginDate] And =[End Date] by Iram
Hello. I am using Access 2003. When I write a parameter querey with = And = as criteria for a Date field, I don't get the desired results. When I put...
June 12th, 2009 10:43 PM
by fredg Go to last post
1 105
=[forms]![main menu]![from %] And =[forms]![main menu]![To %] by brown_eyes
=!! And =!! or Like =!! & "*" Can someone tell me what is wrong with this? I have this on a query and I want to pull a report using these parameters. ...
April 24th, 2006 04:59 PM
by Allen Browne Go to last post
1 85
Greater than and less than by Slipps
Hi. What should seem like a simple thing is baffling me. I want to build an iif query that requires a greater and less than paramiter and I am struggling. Can...
November 26th, 2008 02:51 PM
by Ken Snell \(MVP\) Go to last post
1 98
and for Date Search by GregB
I have 2 unbound text box son my form that I want users to be able to input a date and my subform to pupulate with dates that or after the first text box...
October 6th, 2008 09:12 PM
by GregB Go to last post
8 103
In() by stephenson22
How can I use the " or =" operator(s) in this situation (In(select from )) I want to circle tha values in a table (which I can do) but use the boolean...
November 8th, 2006 12:28 AM
by Michel Walsh Go to last post
3 83
cross tab query by a
() why this sign appears in cross tab query
February 11th, 2008 01:18 AM
by Duane Hookom Go to last post
1 110
data query by fishtofly
I have two tables and both have a field called tag_id. The first table "my2003" has about 5000 records. The second table "monitor2003" is a subset of table...
March 28th, 2007 04:54 PM
by fishtofly Go to last post
4 96
not working correctly in query, unable to separate data by SCC
I have two tables. The Contact table contains has a single record for each employee: first name, last name, phone, etc. The SemesterWorked table has...
September 16th, 2009 07:29 PM
by SCC Go to last post
3 174
0 criteria in query does not work by Pat A.
I created a query that has many calculations. It all works fine until I enter the criteria "0" in one of the calculated columns. It then treats the...
October 25th, 2007 10:26 AM
by Wolfgang Kais[_2_] Go to last post
1 85
= by blancla
I created this expression from other 2 expressions Expr3: IIf(,"MISS","HIT") Expr1 is a variance from Field1 and Field2 Expr2 is Field2 x 2% Expr3 should be...
July 10th, 2008 05:30 PM
by KARL DEWEY Go to last post
1 140
= #Date# problem by Darren via AccessMonster.com
Putting together a simple query and noticing some abnormal behaviour e.g. = #31/7/08# is excluding 31/7/08??? Any ideas? Thanks -- Darren
September 9th, 2008 02:20 PM
by darren via AccessMonster.com Go to last post
2 121
ack!!! simplify to resolve Query too complex ack!!! by [email protected]
Yesterday I posted a request to simplify an IIf and Doug Steele (any relation to Marion L. Steele of Amherst, OH fame?) helped to go from this: UNEstNtWt:...
October 24th, 2008 01:02 PM
by [email protected] Go to last post
3 151
no subject by Ò¶ÃÀ¾ê
hi
July 8th, 2006 05:55 AM
by Ò¶ÃÀ¾ê Go to last post
0 80
no subject by johnson
Ass poop
September 15th, 2006 12:22 AM
by johnson Go to last post
0 103
" Charecter by Max
How can I delete this " from a feild. eg: "khkhkhkh" kk"khkhk" Thanks
March 22nd, 2007 09:56 PM
by Douglas J. Steele Go to last post
1 74
" is not a valid name by Sharon Peterson
I have the 60-day trial version of Office 2007 and am having issues with Access 2007. When I create (or attempt to modify) queries of tables in a split...
June 17th, 2008 09:28 PM
by Stuart Bratesman Go to last post
1 306
"#Name?" Error for only one cell of a record in a query? PLEASE HELP! by Ryan Clair
Yeah, I have a query that is populating in a subform. In the WHERE clause I have one of the fields outside of the subfield. It shows everything fine except the...
December 3rd, 2006 08:31 PM
by Ryan Clair Go to last post
2 82
"Access" by Fivee
Is "Access" a stand alone product or part of a larger program?
May 9th, 2007 05:23 PM
by Jerry Whittle Go to last post
1 83
"Aggregate" error when running query by Graham
Access 2002 I have constructed a Select query (using the Wizard) and when it is run the following message is displayed You tried to execute a query that...
January 26th, 2007 12:58 AM
by John Vinson Go to last post
3 105
"all" in dropdown not working for query by papa jonah
I have a dropdown that is populated by the following query - but it doesn't do what I want. SELECT DISTINCT .Division FROM UNION select '(All)' from ORDER...
December 13th, 2005 09:20 PM
by papa jonah Go to last post
2 80
Post New Thread


Display Options
Showing threads 141 to 160 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 11:08 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.