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
Year to date values by van_slanzar
I need help on calculating the amount of money the agencies for the company has collected for the month specified, year to date, and the same month compared...
June 28th, 2006 07:39 PM
by Duane Hookom Go to last post
2 65
year to year comparison by steverizzo
i need to create a report that shows orders received, YTD, for current year and last year, same time, and show percenage incr or decr. How do i isolate last...
March 12th, 2005 06:03 PM
by Chris2 Go to last post
1 127
Year(Date()) not working by johnlute
Access 2003 Win 2000. SELECT tblCustomerComplaints.DateReceived FROM tblCustomerComplaints WHERE (((tblCustomerComplaints.DateReceived)=Year(Date()))); The...
February 15th, 2010 03:49 PM
by johnlute Go to last post
9 284
Year(Now()), before Year(Now(), or null by [email protected]
I have a field in a query called NextReview, and currently another field NextReviewYear: Year() with the criteria Year(Now()). I need this criteria to find...
June 30th, 2006 05:58 PM
by Jadabug Go to last post
2 71
Year-to-Date Query by Ramone
I would like to build a query that compares our monthly plan to the Year -to-date actual. I have table 1 and table 2 built. I need help with query1. Table1:...
March 8th, 2005 06:11 PM
by John Vinson Go to last post
1 99
Year-To-Date Query Help Needed by Terry
I don't know if this is a query question or a report question or both, but I'm really confused. I have a table (tblGL) with the following fields in...
February 11th, 2008 11:35 PM
by Michael Gramelspacher Go to last post
6 117
Year-To-Date Query with a lime Twist by AnneMarie
Dear Access Community, I have a database in which all entries are done on a day-to-day basis. A summary report must be done that shows monthly figures as...
April 21st, 2007 12:36 AM
by Michael Gramelspacher Go to last post
5 89
Year-to-date Totals by DAngelia
Hello, This is my second time posting this request. I wasn't sure if it went threw. I have the following fields in a...
(Multi-page thread 1 2)
October 31st, 2005 06:09 PM
by Joe Cilinceon Go to last post
11 136
year/ week numbering by Daniel
Good evening, How can I create a field in a query that will populate itself with a sequential numbering of year - week starting at 2004 - 23 to the current...
April 19th, 2006 04:26 AM
by Duane Hookom Go to last post
5 70
YearFrac by Grace
Excel has a function named YearFrac() which allows you to specify where a year calculation uses 365 or 360 days. I would like to use this in Access, however,...
June 1st, 2004 06:59 PM
by [MVP] S.Clark Go to last post
1 644
yearly blocker divided by weeks by gail
i'm looking for a one year planner, divided by weeks horizontally, with vertical data input.
February 10th, 2005 05:48 AM
by Duane Hookom Go to last post
1 156
YearMonth as column Headings by Terry
How can I produce column headings consisting of YearMonth for all of 2004? Starting at 200401 to 200412, or some other combination. I have data that will...
October 11th, 2004 09:59 AM
by Terry Go to last post
6 472
Years employed by Daryl
How do I calculate years employed for the...
February 11th, 2006 08:01 PM
by MGFoster Go to last post
9 139
Years of Employment by Forsi
Hello I am trying to calculate the years a person is employed by the Company, taking into account the separation date, current date and hire date. For a...
June 2nd, 2008 02:52 PM
by Roger Carlson Go to last post
2 108
Yes - No - N/A questions by DanG
I have a database set up to do quality reviews on files There are a number of questions with Yes, No, N/A as the possible outcome to each question. Each...
March 13th, 2008 01:30 PM
by DanG Go to last post
8 120
Yes / No query problem by Serendipity
* I have a qry that uses the information from 2 other queries with 2 calculated fields. * The "base" queries are pulling thousands of records to just...
October 16th, 2009 04:12 PM
by Serendipity Go to last post
4 144
Yes / Yes + N Responses for percentage by Sue
I cannot find my post from yesterday. We have approximately 1200 employees that we are entering data in a table for their evaluations. We are entering the...
April 2nd, 2010 12:39 AM
by Duane Hookom[_4_] Go to last post
4 173
YES /NO Query by Rpettis31
I have a query that I want to list of all records that do not have a yes it is the yes/no data type and I am not familiar how you query from this data type?
July 1st, 2009 10:44 PM
by Clifford Bass[_2_] Go to last post
1 121
Yes No Combo Boxes Queries Filtering as 0 and 1 Instead....work ar by Richard Horne
Hi guys, I have a form with 5 combo boxes, the results of which are passed to a query to display a list of orders. One of the combo boxes is called...
May 19th, 2005 02:43 PM
by Nikos Yannacopoulos Go to last post
3 100
Yes or No by Robert Smith[_2_]
I have a field that I want to query. The input is Yes or No. I'm trying to find an Iif statement that will do it.
February 17th, 2009 06:09 AM
by Allen Browne Go to last post
2 53
Post New Thread


Display Options
Showing threads 43141 to 43160 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:06 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.