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 / Thread Starter Last Post Reverse Sort Order Replies Views
Passing Multi-Select to a Query by LarryP
I sometimes need to pass the results from a multi-select list box to a query, e.g., "Apple" or "Orange" or "Grape" etc. I've done this before by writing a...
December 3rd, 2009 04:06 PM
by LarryP Go to last post
4 232
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 09:13 AM
by Patrick D. Go to last post
2 178
Query twice with the same criteria == by dede
I will run two "make-table" query with the same criteria I call those two query from a form with DoCmd.OpenQuery the criteria in the query is twice...
(Multi-page thread 1 2)
December 3rd, 2009 09:06 AM
by dede Go to last post
12 306
update next row by shank
I need to update a field in a table I use for grooming data. Something like... IIF (Row1.PO=Row2.PO,Row1.InvNo,Row1.InvNo+1) ....and it would loop through all...
December 3rd, 2009 06:55 AM
by John W. Vinson Go to last post
1 165
How to Identify Records with Overlapping Dates by DudeGenius
I need to be able to systematically identify any instance where there are overlapping date ranges in a data set. I need to pull records like those listed...
December 3rd, 2009 01:09 AM
by KARL DEWEY Go to last post
4 195
InStr Function not finding space by Kirk P.
I'm using this function InStr(Trim()," ") on data that looks like this: (USD 65.00) and it is returning a zero. I'm trying to find the first occurance of a...
December 2nd, 2009 11:36 PM
by KARL DEWEY Go to last post
8 318
how to find records based on three sets of criteria by Access Joe
Hey gang - Access 2003 I have a table that displays the something similar to the...
December 2nd, 2009 11:35 PM
by Dorian Go to last post
2 158
Sum Only Subset Records Included in Max Sale Date by dallin
I have the following query: The sum(taxcredit) is not working -- it is summing all records by PED (period end date) where as I only want it to sum the...
(Multi-page thread 1 2)
December 2nd, 2009 10:21 PM
by KARL DEWEY Go to last post
13 319
Prevent duplicate append - nothing unique by Opal[_3_]
Help! I have been working on this all day and cannot get my head around a solution.... I am running Access 2003. I have created the following select...
December 2nd, 2009 10:03 PM
by Opal[_3_] Go to last post
0 153
DateAdd not working correctly. Need fast help!! by Ben
I have a query with the following field: DateAdd("d",1-Weekday(),) What is need it to do is calculate all the items between Monday and Friday based on...
December 2nd, 2009 09:23 PM
by John Spencer Go to last post
1 181
Return records only when all linked records meet criteria by yator
I am trying to write a query that returns all records only when all values are 12.0 ? For example, the query below returns the following sample...
December 2nd, 2009 09:10 PM
by yator Go to last post
0 176
Return records only when all linked records meet criteria by yator
I am trying to write a query that returns all records only when all values are 12.0 ? For example, the query below returns the following sample...
December 2nd, 2009 09:10 PM
by yator Go to last post
0 159
DateAdd not working correctly. Need fast help!! by Ben
I have a query with the following field: DateAdd("d",1-Weekday(),) What is need it to do is calculate all the items between Monday and Friday based on...
December 2nd, 2009 08:56 PM
by Ben Go to last post
0 193
DateAdd not working correctly. Need fast help!! by Ben
I have a query with the following field: DateAdd("d",1-Weekday(),) What is need it to do is calculate all the items between Monday and Friday based on...
December 2nd, 2009 08:56 PM
by Ben Go to last post
0 155
Year Minus One by Ann
I am using Access 2002 and have a two character text field that holds the last to characters of the current year, (example 09). I want to retrieve all the...
(Multi-page thread 1 2)
December 2nd, 2009 08:08 PM
by Jerry Whittle Go to last post
12 291
SHOWING MORE THAN ONE VALUE FIELD IN CROSSTAB QUERY by Kingsoft
I am atempting to use the crosstab query to display a series of data across various dates, but can only get one value field of data to work. Is there a way...
December 2nd, 2009 07:53 PM
by Duane Hookom Go to last post
9 190
Duplicate Values in Query by AccessIM
I have the following code in a query: SELECT qryDisciplineLevelAll.EMPLOYEEID, qryDisciplineLevelAll.SSN, qryDisciplineLevelAll.NAME,...
December 2nd, 2009 07:43 PM
by Daryl S[_2_] Go to last post
6 217
Help with: ...query that does not include specified expression ....as part of an aggregate function... by Need2Know
Good Afternoon, I keep getting "You tried to execute a query that does not include the specified expression '(Max(.)) Between . And .' as part of an aggregate...
December 2nd, 2009 07:18 PM
by John Spencer Go to last post
9 194
How to Identify Records with Overlapping Dates by DudeGenius
I need to be able to systematically identify any instance where there are overlapping date ranges in a data set. I need to pull records like those listed...
December 2nd, 2009 07:14 PM
by DudeGenius Go to last post
0 166
How to Identify Records with Overlapping Dates by DudeGenius
I need to be able to systematically identify any instance where there are overlapping date ranges in a data set. I need to pull records like those listed...
December 2nd, 2009 07:14 PM
by DudeGenius Go to last post
0 196
Post New Thread


Display Options
Showing threads 2061 to 2080 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 09:27 PM.


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