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
QBE by Elaine J.
I have recently started using Access 2007 and I have a question about the QBE. I like to arrange my fields in a particular order when I am creating a query....
March 3rd, 2010 01:56 AM
by Elaine J. Go to last post
0 259
Calculate difference in rows in a query by Glenna
I have a query that calculates how much revenue is claimed by month per job but then I have to take the new month less the prior month. The problem is the...
March 3rd, 2010 01:32 AM
by KenSheridan via AccessMonster.com Go to last post
2 293
Different Data Formats- Rows Vs. Columns by TXgirl via AccessMonster.com
I have 13 yrs of tide data and precipitation data, each in a different table. (.csv format) They are both measured hourly but rain data has the hours labeled...
March 3rd, 2010 01:12 AM
by KARL DEWEY Go to last post
5 221
Search by product & alsoshow other products purchased by same cust by sebruce
Asking for help!! I searched all day yesterday in the forums with no luck. I am trying to create a query to display customers that purchased a particular...
March 2nd, 2010 11:51 PM
by sebruce Go to last post
2 256
Crosstab Groupings by Karen
I would like to create a crosstab query to count IDs by specific ranges: 95% 75 - 94% 50-74% 50% I do not know how to create this grouping by percentage.
March 2nd, 2010 11:47 PM
by Duane Hookom Go to last post
2 187
export to xls. by Humbled Learner
Good Afternoon, I have a query set to export to xls... table = "error" set to yes/no Form reflects a check box Query has "error" and shows check box (checked...
March 2nd, 2010 10:43 PM
by PieterLinden via AccessMonster.com Go to last post
3 208
Crosstab query with custom grouping by Karen
I would like to create a crosstab query to count by Id for specific percentage grouping. The ranges a 95% 75 - 94% 50-74% 50% I am not sure how to...
March 2nd, 2010 10:39 PM
by John Spencer Go to last post
1 302
Now()+1 by Caburky via AccessMonster.com
Using Access 2003: A date/time field in my query has the criteria: #3/2/2010 7:00:00 PM# Or #3/2/2010 7:00:00 AM#. I would this query to run each morning and...
March 2nd, 2010 09:48 PM
by Caburky via AccessMonster.com Go to last post
4 240
Query Question by Ryan
Hello, I have a query that i would like to filter when i click a button on my form, that uses a field on the form to filter the query. I do not to display...
March 2nd, 2010 08:39 PM
by Jerry Whittle Go to last post
1 188
Return all dates for 'next month' irrespective of year or day by Andy79
Hello, Sorry to ask such a simple question; I would like my query to return all rows were the my 'date' field is any day in the next month. The year & day of...
March 2nd, 2010 07:57 PM
by Andy79 Go to last post
4 202
IIF stmt in query by AMZ
I would like to return different results for different conditions more than one field. here is my IIF...
March 2nd, 2010 06:42 PM
by AMZ Go to last post
7 236
all posible combinations by cliff
have the following programme.module for generating all possiible combination of in a group of 3 items and it works like this Private Sub Command1_Click()...
March 2nd, 2010 05:17 PM
by Daryl S[_2_] Go to last post
3 172
Instr by Breecy via AccessMonster.com
I would like to return the left of the % in my field if a % is in the field. Currently I have the following code in my query: Formatted_Rate:...
March 2nd, 2010 03:36 PM
by Breecy via AccessMonster.com Go to last post
4 186
Between ...And by Leif Thorsen
I am using the command "Between XX-date and YY-date" in a date-field named "DateWritten" in a question where I have a bunch of posts. Let´s say that the...
March 2nd, 2010 03:17 PM
by Allen Browne Go to last post
4 225
Select two records then select the next two records by Ian
I am still somewhat a beginner at this access stuff but I have something that I am sure can be done but I don't know how to do it. I am using ACCESS 2003. ...
March 2nd, 2010 11:27 AM
by Stefan Hoffmann Go to last post
3 231
Serial Number - Temporarily In A Query by Faraz A. Qureshi
I have a table with fields: DT, INVOICE, AMT Now invoice numbers are different unique keys but not numeric, how to add a fourth temporary column in a query...
March 2nd, 2010 07:23 AM
by Faraz A. Qureshi Go to last post
6 198
Parameter Query Question by Zoomiest
Why doesn't this work? In the Criteria field of a QBE grid, I have the following formula, to pull some parameters off a form. How can I code the "*"...
March 2nd, 2010 03:51 AM
by Sylvain Lafontaine[_2_] Go to last post
2 181
Problems with a join by Biss
Access 2007 I am trying to produce a simple query or at least I think that it should be simple. I apologize in advance as to how I am going to explain but...
March 2nd, 2010 12:10 AM
by KenSheridan via AccessMonster.com Go to last post
2 141
Eliminating duplicates in Access 2007 by Doones
I have done a query in Access and duplicate records are showing up and I'd like to have the duplicates not be displayed. Can someone assist me with this. ...
March 1st, 2010 11:39 PM
by PieterLinden via AccessMonster.com Go to last post
1 164
Between [First Date] And [Last date] by Peter
Hi all..i have this issue in a newly formated field (date) =Now()..running a query with parameters between and..does not give me correct results..any odeas...
(Multi-page thread 1 2)
March 1st, 2010 10:40 PM
by Peter Go to last post
10 480
Post New Thread


Display Options
Showing threads 1021 to 1040 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 10:01 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.