I have a report which has details of the projects. I have them sorted by the year they were done and i was wondering can you the different years on seperate pages
eg
say 2004 had 4 projects that be on pg1
2005 had 20 projects that be on pg2 and 3
2006 had 80 projects be on pg4,5,6,,7etc
is this possible?
I am editing a database that provides the option of creating custom reports, where the user can input a date range of their choice and receive aggregate data for that time frame. Although all of the numbers in the report are correct, I am having trouble with a chart that I inserted into the report.
Specifically, if the date range requested spans 2 calendar years (i.e. April 2014 through January 2015), the data for January 2015 appears at the beginning of the year (so the chart x-axis is for Jan through Dec, and the Jan 2015 data is showing up in Jan (as if it was 2014, not the end of the given range in 2015). When I try with smaller time frames within a calendar year, it adjusts just fine (i.e. shrinking the window so just March-May is displayed on the graph).
How to adjust the axis so that it properly records the data range- so that it would start the axis with April and end in January, for example?
For the record, I have indeed searched the forum for help with this, but no luck so far, so here goes. (C++ programmer, little background in access).
I have a table that stores a person's name, gross amount spent, gst spent, pst spent, and total amount spent.
I need to be able to create a query or something that asks me to enter a year, and it will sum up the amounts, gst, and pst over the course of that year, and print it neatly on screen.
Also, I need to be able to create a similar query that asks for a year and a month (does access possess Java's ability to easily create a pop-up calendar applet-like instance that provides a GUI for selecting months/years, or does the data need to be entered through a command prompt?) which will create a month-end report in the same manner, but only spans a 1 month period?
Any information that could be provided to me, even a means of getting started on this problem, would be great. Thank you and cheers everyone!
I have a Floating Holiday that doesn't happen every year how do I incorporate this in Access 2010, I have a report that calculates Paid Time Off for employees and when they have a year that has a Floating Holiday or doesn't have a floating holiday, how do I incorporate that into a query or report without losing the calculations from the previous year reports.
for example, this year a floating holiday is allowed so my calculations work, but next year if a floating holiday isn't allowed how do I make it a 0 without losing this years data.
I tried tblFLOATINGHOLIDAY with several years listed (at first used Yes/No) and a field that you either put 8 or 0 (8 hours or 0 hours). Then I used a query combining tblEMPLOYEES and tblFLOATINGHOLIDAY with citeria for FLOATINGHOLIDAY to be 2015 so all the records would show 8 under FLOATING HOLIDAY. But it comes up with no records.
I have a report filter that filters the reports by month and year:
Code:
DoCmd.OpenReport "AttWholeCity", acPreview, , " Month = '" & txtCourseDateMonth & "' AND Year = '" & txtCourseDateYear & "'"
I want the code to also show these two columns where there are null/blank values aswell, for example if I filter by apr 2015 i want the report to show these columns as well as blank columns is this possible
i'm trying to filter is a datetime value and it just doesn't whant to work.I tried to make a separate unbound text field to filter out the Datetime into year and then filter that field out with year but it doesn't work. What I did:
-I clicked on the control element of the unbound text field.
-made a expression with this code : datepart ("YYYY", [BeginDatetime])
-(BeginDateTime is a table value)
-After this one it keeps showing me this error :
-"the syntax of the expression You've taken specified is invalid"
So I have a report generated, listing all my companies personnel in one column and the next column has the expiration dates of a certian training certificate. My question i would like to add some statistics to the bottom of the report, mainly how many certificates are expired, which is the ones over a year.
I have attempted to use:
=Sum(IIf([AT_LEVEL 1]<"Now()-365",1,0))
previously in excel my spreadsheet counted it like this:
=COUNTIF(C5:C77,"<"&TODAY()-365)
I need to put a date field in that is the month and year of the reporting period...
for example
February 2013
and then another date field that is the 10th day of the month following the reporting period.
example: March 10, 2013
I have tried a number of different formats and can't get it right.
I have a report that I am trying to show data for the current year, but with a record count.
So, for example: I have 3-OVI, 3-Conduct Unbecoming, and 3-Did not transport for the current year.
When I run my report, it will show the above data for the current year, but in this format;
OVI-1
OVI-1
OVI-1
Conduct Unbecoming-1
and so on.
What I would like is;
OVI-3
Conduct Unbecoming-3
Did not transport-3
Total-9
If I take out the date code for the current year in my query, then I get the desired results but I get all data.
If I leave the date code in, then I get the data for the current year but I get the first example above.
I have a huge table with transaction dates. I need to slice and dice
this data (sum, %'s, etc), but group by FY. Our fiscal year is from
7/1 thru 6/1.
For example:
1/8/2004 = FY 2004,
8/12/2004 = FY 2005,
2/3/2006 = FY 2006
THEN . . . . I need to also isolate certain periods, for example July-
March for YTD (year-to-date) analysis and compare YTD of 2006 with that
of 2005.
What do you suggest? Many thanks.
Mehran
I'm trying to add a couple of fields to the Contact database in Access 2010.
In the Contacts table, I created a field called "Sobriety Date" that has dates formatted like 12/27/1995
I am trying to add a calculated field called "Years Sober" which should be the current year minus the year in the 'Sobriety Date' field (1995 in the example above).
I have been trying to tweak this:
SUM(DatePart("yyyy",[Date]) - DatePart("yyyy",[Sobriety Date]))
but it's not working. Keeps giving me "The expression that you entered is not valid for web-compatible calculated columns"
I trying to figure out how to make this query work. I have a simple database that is being used to show employee employment information - name, hire date, salary, bonuses, etc. Everything is just about done but they want me to show what percentage of the prior year the employee was there. In other words if an employee was hired 4/20/2004 they want me to show the percentage of 2004 they were employed with the company. I've tried just about everything I can think of but nothing seems to give me the right answer. I am also showing the percentage for the current year (2005) and that works ok. Just can't figure out how the calculate it for a prior year.
This is being done in a query and we're using Access 2000.
Any help would be greatly appreciated.
Thanks,
I have fields [DayOfYear] and [Year] can I somehow produce the dd/mm/yyyy from this. I know how to do it in Excel but the Asscess function Date() is a little different.
I.e. if [DayOfYear] =152, [Year] = 2014 then [Date] = 2/6/2014
I'm going to try using the year, day of year, hour & minute (24 hour clock) as a report number. It's set up in a field on a table. Right now I have....
Default Value =Format(Now(),"yyyhhnn") 'which works but not exactly how I would like
yy = Last two digits of the year
y = Number of the day of the year (1 to 366) 'can this show three digits all the time?
hh = Hour in two digits (00 to 23)
nn = Minute in two digits (00 to 59)
For instance, right now for Jan. 10th, 2012, 1306 hours the result would be 12101304 which, for all intents and purposes works, but I would prefer the "day of the year" to always be represented by three digits and not just when it hits day 100 of the year.
I would prefer to see 120101304
I have a query based on payment date which I have extracted the Year part as a seperate Field StartYear, but I want to now add EndYear which just adds 1 year to the StartDate. e.g. EndYear = StartYear +1. Anyone kow please I know i's proably simple but I keep getting syntax errors.
View 3 Replies View RelatedHi..
I need some help how can i get all persons that age is equal to 25 years till the end of this year??
any clue please??
There's a lot of info that I need to keep track of by just the year. If I enter it as a normal date, I would need to extract the year every time I need to query and then do what ever. Would it be easier just to extract it once, convert to an integer and use it like that through out the system when I need to query by year?
Thanks,
scratch
In my DB im trying to determine the aniversary date of a loan closing. I can't seem to get the query to ignore the year and just show me the loans that closed in upcoming month regardless of what year. This is what I have so far, what else do I need.
thanks,
Raydan
SELECT Loans.LoanID, Loans.EndDate, Loans.LoanLender, Loans.CustomerID
FROM Loans
WHERE (((Loans.EndDate)>DateAdd("m",-1,Date())));
My main report shows deliveries and types by month. At the bottom there is a subreport that totals everything for the year. However if you go back a month or two or three, etc the report show the total for the year, not up until that month. Any Ideas on how to total up up until the selected month?
View 2 Replies View RelatedI have a church database for our choir...we are usually the same group each year ... I have built a database logging all robes, hymnals, etc... I have a table with the contact person (contact), address information, sizes, and yearly dues paid (year)... I would like to just update the year from one year to the next without having to change 135 individually... is there someway to automate this or a function that I can use.... I still would like to have access to the 2006 files to see if someone is making partial payments and check their records (as well pastdue balances) but at the same time move/update to 2007.... is there an easier way to this...I am fairly new to Access and don't mind trying something...I have backups of my database so I can try anything. thanks in advance..
View 6 Replies View RelatedI want a field in a table that is a date but that is the year only.
I only want this because I want to be able to filter my charts to show one or a span of years for comparison. I have criteria in a query that states between [forms].[charts].[begin] and [forms].[charts].[end] and the corresponding form that my user puts the desired begginning and ending dates into before pressing buttons that bring up the charts based on the query.
My problem is that I can't even get the table to take a year only date. If I leave the date field as text the between clause in the query won't work. I tried it as a number with >= etc. and that didn't work either.
How hard can something this simple be?
Please help me oh cyberspace wizards.
Hi everyone-
I have what I hope is an easy question....
I have a query that returns the following fields:
Feature // # of features to be fixed // Total fixed (all years to date)
Bathroom // 14 // 7
Parking Lot // 5 //2
The total fixed field is calculated by counting on a "completed date" field.
I'd like to add fields by year after the Total fixed field:
Total fixed (all years to date) // Total fixed - 2006 // Total fixed - 2005
7 // 0 // 7
2 // 1 // 1
I've tried doing a subquery to select for each year but haven't had much luck on my syntax.
Any suggestions? Thanks in advance, Meg
Please could someone advise me how to set the YEAR in a query - all my data for 2006 is fine but I have uploaded some data for today (01 Jan 07) and ALL by queries / reports now show to 31/12/2006 then at the top, instead of the bottom, reads 01/01/06 ?
Regards
Richard
I currently have a query that lists the date of something. I just need to have the year in which it is done for a task so I need to somehow find a way to write a function that will just show the year instead of the entire date. Any ideas.
View 2 Replies View RelatedI would like to run a query to return all dates for a year like 2007. I need to ignore the day and month so the user will be asked to enter the year “2007” they require a form list on.
I have used the between date query:- Between [Start Date] And [End Date], and it’s okay but it would be much faster if only one parameter can be typed to return a list of the full year.
Any help would be appreciated, I cant find anything here which helps.
Thanks!
Hi All,
i need ur help, i have working on database in which one of form/table i m using the day code(e.g 1 to 365). i want that these day value are automatically add on next day.......
For Example:
Today Date: 17/08/2005 Day Code: 229
2nd Date: 18/08/2005 Day Code: 230
3rd Date: 19/08/2005 Day Code: 231
i just want when date chenge, day code is automatically chenged.
thanx
ami