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
Cumulative totals by SamMexico via AccessMonster.com
Hi everyone, I would like to create cumulative totals per month to create a chart. I have got this far: SELECT Data.Region, Data., Count(Data.) AS FROM...
May 18th, 2010 02:35 PM
by SamMexico via AccessMonster.com Go to last post
0 829
Concatenate fields without duplicating data by Rachel
I have two tables that I'm creating a query with. Table 1 has Agent field and Table 2 has product field. I'm linking the tables by a primary key. Table 1...
May 18th, 2010 01:50 PM
by PieterLinden via AccessMonster.com Go to last post
1 866
Date Question... by 116
I am trying to create a query to give me the results from the first weds of each month back to the following day after weds. Having trouble formatting the...
May 18th, 2010 12:36 PM
by 116 Go to last post
5 886
Determining EVERY month between 2 given dates by Edwinah63
Hi everyone, I have a table with the following data upon which I would like to report: SomeDt SomeValue 1-sep-09 100 12-dec-09 ...
(Multi-page thread 1 2)
May 18th, 2010 12:02 PM
by Edwinah63 Go to last post
17 1,788
Convert text to Combo by Mickey[_4_]
Hi, I have some 20,000 entires populating a text filed that ideally should be a combo box. I'm looking for the best way forwards with this and wonder if...
May 18th, 2010 03:32 AM
by Allen Browne Go to last post
1 843
Books & Otehr Sources by Mickey[_4_]
Apologies for repeating what has probably been asked before although my newsreader can't find anything! I'd appreciate any advice on Access books and...
May 18th, 2010 03:28 AM
by Allen Browne Go to last post
1 848
crosstab by Mickey[_4_]
Hi, New to Access and have inherited a database at work, I need to create some crosstab queries and am unsure if I would be better off creating a new table...
May 18th, 2010 03:05 AM
by Duane Hookom[_4_] Go to last post
1 742
Flag a value in a group... by Jack Leach
Hi all, tia for any insight. I have the following query that gives some totals for qty's in a releases table, pulling and grouping information (part number,...
May 17th, 2010 07:48 PM
by Daryl S[_2_] Go to last post
4 1,198
Query from day of week by rbeach
I need assistance in creating the formula to select one week ago Wednesday through Thursday of the current week. This query needs the ability to be run on...
May 17th, 2010 07:25 PM
by Daryl S[_2_] Go to last post
3 767
SQL subsets by Stacy in Savannah
I have a set of Permitees 12,000+, who own one or more items 58,908 of a list of 29 items. Some Permitees are only allow to own 3 of these 29 items, others...
(Multi-page thread 1 2)
May 17th, 2010 06:39 PM
by Bob Barrows Go to last post
15 1,117
Multiple criteria IIF function help by Cam
Hello, I am trying to create an IIF query field where if RtgGrp not equal NA or Non, the return Yes, otherwise return No. But it is not working. What is...
May 17th, 2010 06:11 PM
by Marshall Barton Go to last post
2 1,261
Slow Join by jenniferspnc
I'm trying to rewrite queries for better performance and am stuck on one. This is how it is written now: SELECT tbl_OrderParts.UniqueID,...
May 17th, 2010 06:05 PM
by Marshall Barton Go to last post
1 730
SELECT DISTINCT query by Kathy R.
Hi folks, Using Access 2007. I have a query (SQL below) in which I need to select only those records with distinct FamID's I'm pretty sure I need to use...
May 17th, 2010 06:02 PM
by Kathy R. Go to last post
8 874
Max Query by NPell
Hi all, I have 2 tables. One holds account numbers. One holds invoices, linked to account numbers. Ive got a query to show the latest invoice for each...
May 17th, 2010 01:11 PM
by NPell Go to last post
2 693
Query result shows all fields by sunberries
I have not had this issue before with the old .mdb but with 2007 Access , when I am creating or editing a query in design mode, I click or drag only the...
May 17th, 2010 12:46 PM
by Bob Barrows Go to last post
1 765
Sum using totals by Biss
I have a query that I use to sum groups of data... Works great.. However I want to perform a calculaton on the SumOfPayout... All I want to do is subtract 2...
May 15th, 2010 09:42 PM
by Biss Go to last post
2 674
Filtering for fields with character by Louis[_8_]
How can I filter for results that contain the charcter "(" ? For example if my fields a A(2001) B(2004) C D(2055) E(2006)
May 15th, 2010 06:28 PM
by John W. Vinson Go to last post
1 770
Multiple indexes on same fields in different order by Petr Danes[_5_]
I sometimes need to find the largest or smallest value in a field. If I put two indexes on the same field, one in ascending order and one in descending...
May 15th, 2010 08:44 AM
by Petr Danes[_5_] Go to last post
4 938
Emailing a form created from a query by cowbelle
I am using Microsft Access 2007 to email a form to individual email addresses so they can update their details and email it back to me. The form was created...
May 15th, 2010 04:30 AM
by cowbelle Go to last post
0 705
Access 2007: Need more info on 'concatenante fields' by Hummingbird7
Beginner in Access 2007. Question related to queries: concatenante fields. Does the expression results show in forms? Also, pre-existing lookup data type...
May 15th, 2010 01:08 AM
by John W. Vinson Go to last post
1 813
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 09:30 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.