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/ 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
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 07:09 PM
by Joe Cilinceon Go to last post
11 136
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 86
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 12th, 2008 12:35 AM
by Michael Gramelspacher Go to last post
6 115
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 07:11 PM
by John Vinson Go to last post
1 98
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 70
Year(Date()) not working by johnlute
Access 2003 Win 2000. SELECT tblCustomerComplaints.DateReceived FROM tblCustomerComplaints WHERE (((tblCustomerComplaints.DateReceived)=Year(Date()))); The...
February 15th, 2010 04:49 PM
by johnlute Go to last post
9 280
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 07:03 PM
by Chris2 Go to last post
1 124
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 64
Year to Date subquery by ram
HI I would like assistance with creating a year to date subquery. I tried to copy the MS help example but still can't get the query to run. I have the...
February 22nd, 2010 06:15 PM
by ram Go to last post
5 186
Year To Date Record Selection by Kathy Webster
I am trying to select records in a query where the is between the first of the year selected and the end of the month of the month the user selects when he...
July 29th, 2006 04:12 AM
by John Vinson Go to last post
3 82
Year to Date Query Issue by Steve
Hi all- Thanks in advance for taking time to give me a hand. I'm having an issue with trying to make a Year to Date function in my query. I want it to give...
February 15th, 2007 03:59 PM
by Michael Gramelspacher Go to last post
2 217
Year to date month/year by Kim
I am creating a database table and query for billing that uses the date form month/year, or mm/yy. I want to be able to filter to "year-to-date" in order to...
June 22nd, 2009 05:25 PM
by John W. Vinson Go to last post
1 127
Year to Date Date Restrictor by Haji
Hello, Can someone tell me how to do a date restrictor for year to date that would not be just "between 1/1/04 and 12/31/04"? Also, is there a web site that...
October 19th, 2004 07:10 PM
by John Spencer (MVP) Go to last post
2 145
Year to Date date restrictor by ChuckW
Hi, I want to create a year to date date restrictor. Right now for all of my queries I have used between 1/1/05 and 12/31/05. I want to create one that will...
November 22nd, 2005 10:20 PM
by fredg Go to last post
2 93
Year to Date by Alex
How could I put restrictions in Criteria for the current year to date in the one field and for the previous year to date in the second field to compare the...
July 21st, 2004 05:20 PM
by Alex Go to last post
3 201
Year query based on text by cathyt
Hi Everyone, I’m creating a database that has a table called History. History contains 7 fields; ID, Year, Schedule, Hold, LType, Painted, Approved. The...
February 3rd, 2010 01:54 AM
by Allen Browne Go to last post
3 159
Year Query by Sue
In a table containing employee information, I have a field that shows birthdate as MM/DD/YY. How would I write a query that I could use a parameter box that...
June 29th, 2004 03:45 PM
by John Vinson Go to last post
1 86
Year over Year Query by michaelloveusa via AccessMonster.com
Hi there. I haven't worked on Access for a few years and I was asked today to help someone with a query to calculate Year over Year percentage changes. Here...
November 6th, 2007 09:30 PM
by michaelloveusa via AccessMonster.com Go to last post
2 60
Year Only as Query Parameter by Kathy Webster
I have an field in a query. I want the user to be prompted to enter the desired year they want matching records for. For example, if they enter 2004, the...
February 1st, 2006 06:04 AM
by Kathy Webster Go to last post
4 86
Post New Thread


Display Options
Showing threads 141 to 160 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:00 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.