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
Rolling Totals for 6 month and 12 month by Coach K
I need help! I have Totals query that give me Year, MonthID, Month - Groupby. Then sum ManhoursWorked, Recoardables, Lost Time. I need to get rolling total...
July 13th, 2009 05:26 PM
by Coach K Go to last post
2 109
Parameter queries and null values by JeffN
I have written a parameter query that allows a user to select the criteria Y, N or C when the query runs. I have now been asked to modify the query so that...
July 13th, 2009 04:24 PM
by John Spencer Go to last post
2 131
Getting error table that was deleted by Pamela
I deleted a table & its relationships and created a new replacement that is normalized and has proper relationships and am now trying it fit it back in. ...
July 13th, 2009 04:18 PM
by John Spencer Go to last post
5 135
Trouble with Query Results by Eric Starn
I seem to be having a problem with getting my query to run the way I want. I have a table of records that has an autonumber field on it as a PK. The query I...
(Multi-page thread 1 2)
July 13th, 2009 03:23 PM
by Eric Starn Go to last post
11 230
MS Access SQL Book Recommendation by cp2599
Would someone please recommend a book that can help me with formulating queries for MS Access? I'm somewhat familiar with DB2/ Oracle though I'm a little...
July 13th, 2009 02:01 PM
by vanderghast Go to last post
1 129
Dlookup a range with multiple criteria by kazzaw
I am trying to calculate markup based on a price range and code number, when I use the range part of the code it runs fine but as soon as I add the discount...
July 13th, 2009 12:34 PM
by kazzaw Go to last post
7 140
A fast and Easy way to populate records from Temp Table to Permanent Table? by Aldred@office
Hi all, I am trying to solve a problem for the company which I chosed to use Temp table. In some certain conditions, we need to populates all the records...
July 13th, 2009 10:26 AM
by Allen Browne Go to last post
1 106
Nested If Statements by Alex Hammerstein
Hi I am trying to get a nested if statement to work, which includes some date fields. Part of by query is: IIf(#31/07/2007#,DateDiff("ww", is between 1/8/07...
July 13th, 2009 04:53 AM
by PieterLinden via AccessMonster.com Go to last post
1 95
Queries by gr8_access
Hi, I am having issues with access sql. I have data for example: 123456789. I would like to break this into two lines and I don't know how to do...
(Multi-page thread 1 2)
July 13th, 2009 03:27 AM
by John W. Vinson Go to last post
10 163
Some text isn't recognized in report's query by tina
please don't multi-post. for more information, see http://home.att.net/~california.db/tips.html#aTip10. hth "JimTrekker via AccessMonster.com" u53152@uwe...
July 12th, 2009 08:17 PM
by tina Go to last post
1 116
Parameter query by Richard
Hi forum, I have an unbound form with a Calendar control (9.0) Two unbound text boxes, option group, and a command button. I all ready have the calendar...
July 12th, 2009 05:26 PM
by drill_monkey via AccessMonster.com Go to last post
2 136
Parameter Query Null Response Error by Bruister via AccessMonster.com
I have some parameter queries in which I enter a as a criteria. I also want to be able to return all records if I want. I have seen the instruction on adding...
July 12th, 2009 12:58 PM
by Douglas J. Steele[_3_] Go to last post
2 125
Type one number into Access, get another in the database by Maury Markowitz[_2_]
Please READ CAREFULLY before saying this is an FAQ issue about storing floating point numbers. It's not. I have a form in Access linked to a table called...
July 12th, 2009 11:34 AM
by vanderghast Go to last post
4 124
Most Recent Contract by timbits35 via AccessMonster.com
Hi, I have a database that tracks yearly plans for a personal trainer. Each athlete usually renews every year and therefore one athlete can have...
July 12th, 2009 03:44 AM
by Ken Snell [MVP] Go to last post
5 118
Access Pass-through Query to SQL Server by Kirk P.
I'm getting a "Query timeout expired" error when running my Access pass-through query. The query works when I retrieve a small date range, but when I expand...
July 11th, 2009 10:02 PM
by Bob Barrows Go to last post
7 165
Changing UPPER to Proper Case by FmEdit
Hi, Using Office 2007 with SP2 In a query I use the function: Strconv(,3) for converting upper to proper case Only snag is: RED LION 49/SOLID STATE LOGIC...
July 11th, 2009 02:01 PM
by Douglas J. Steele[_3_] Go to last post
2 88
seksi djevojka by Pella
July 11th, 2009 05:08 AM
by Pella Go to last post
0 62
seksi djevojka by Pella
July 11th, 2009 05:08 AM
by Pella Go to last post
0 67
seksi djevojka by Pella
July 11th, 2009 01:48 AM
by Pella Go to last post
0 73
seksi djevojka by Pella
July 11th, 2009 01:48 AM
by Pella Go to last post
0 47
Post New Thread


Display Options
Showing threads 3961 to 3980 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 05:33 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.