Search results

Hi All I'm possibly missing something obvious here but a date formaula that I was using in access 2007 doesn't seem to be working in 2010. The formula that I had was Between DateSerial(Year(Date())-IIf(Month(Date())<4,1,0),4,1) And DateSerial(Year(Date())+IIf(Month(Date())>3,1,0),3,31). The...

Sorry for the confusion I called the picture table jpg but what is actually displayed is a query not a table. The structure is that a table captures actual hours. These are summed on a query and then converted to percentages by another query which is then used to create the pie chart. What...

Hopefully he attachments make sense So on the pie chart I don't want to see assessment as there are no hours recorded against this. Any help appreciated Kev

Hi All Can anyone help me with the following I have a pie chart showing what percentage of time is spent on which of four activities. Got everything working however I would like the pie chart to ignore zero values so that if a person only spent time on two of the four activities the pie...

Thanks for that That really helps and might even prevent me from asking more silly questions. Thanks again Kev

Astonishingly that worked. Thanks I'd be even more grateful if you could explain even briefly why that worked. I had already tried -7, -2 and +1 but to be honest was struggling to understand the results I was getting. Not very good with Access. Thanks again

Hi Folks I'm trying to set an 'on load' event for my form so that it sets the date field [W/C Date] automatically to last Mondays date. Originally I had it set to open for Monday of the present week using: Me.[W/C Date] = Date - Weekday(Date) + 2 But the user wants it to open displaying...

Apologies if this has been asked before (I could find similar but not exactly what I want) I have a pivot form with a selectable filter to show week commencing date by month - year. Users will normally only be interested in the current week but need the facility to view monthly and quarterly...

Thanks bob

Thanks Bob I'll try it just now. Might be a silly question but could I bracket the whole formula? i.e total: Nz([SumOfDelivery Hours]+[SumOfAssessment Hours]+[SumOfVerification Hours]+[SumOfReview Hours]+[SumOfELearning]+[SumOfDesign]+[SumOfMeetings]+[SumOfScoping]+[SumOfCourse...

Ok here goes. I use a query to get the total of the hours that staff spend on different activities each week. The hours that they enter go into three different tables (delivery, design and admin). I've used colours to show what belongs to what table. Here's the formula at the moment...

Hi all Haven't been here for a while so I hope I'm still welcome. I'm looking for help with something I'm sure is basic but I can't get to work. I have a pivot table form that shows a summary of peoples activities for the week. The table summarises data from another more detailed form. What...

Hi folks I have a menu form that has buttons linking to several pivot table forms. All of the pivot table forms have the filter 'W/C Date by Month'. This is fantastic and provides a flexible and useful report however, on a weekly basis, users are likely to access each pivot table and want it...

Re: Hide collumn if sum = 0 Hi Trevor I'm fine writing a criteria for each collumn such as >0. The problem is that the rows are by date so if someone had no design on 01/04 but 15 hours of e-Learning work then I need to show the row for 04/01. So if someone has done no design all month then...

Hi folks. Me again I have a query that shows productivity. So I have a collumn headed design that shows the amount of hours spent each week on design. A collumn headed e-Learning that shows the amount of hours spent each week on e-Learning etc. What I was wondering was if there is any way...

Thanks David. That's the best most concise explanation I've had in a while. I've never used NZ before but, now I know that it exists I can see where it could have solved a few problems for me. Cheers

Ok I'm glad it worked but I'd like to know why. What does NZ do?

Unfortunately I can't try this this week because I'm busy with other stuff. Don't think I've given up on it though or that I don't appreciate your help. I'll be back on this after this week. Cheers

Hi Galaxiomathome. I like the sound of using code that searches faster and I had a quick look at this last night. The problem is that it wanted the same month/year entered twice (I'm assuming so it had a start and end date of the month). My figures are created on a once a week basis (a...

Thanks galaxiomathome. I'm ok on how to reference the form from within the query however I'm not sure how to set the 'Format' option on the form. In the query 1 I'm using Expr1: Format([Utilisation Step 2]![W/C Date],"mm/yyyy") as a field and then [Compare this month: mm/yyyy] as a...