Search results

Apologies, it was pure laziness at 2am here. I'll try again: 26/11/2016|01/11/2016|466.69|.... 03/12/2016|01/12/2016|67.83|... 10/12/2016|01/12/2016|67.83|... 17/12/2016|01/12/2016|67.83|... For the data in post 6 I should be able to enter 31/10/2017 in the next record on the tableand...

Hopefully this shows what I'm after: 25/11/2016|01/11/2016|466.69|.... 18/11/2016|01/11/2016|466.69|... 02/12/2016|01/12/2016|67.83|... 09/12/2016|01/12/2016|67.83|... after the ... is working so I left that bit out. The first 3 columns is what I am working on. Essentially it will look like...

Above are my two tables. In [NPS Baseline] is a column called [RICT Month] (dd/mm/yyyy). In [RICTweek] is a column called [Week Ending]. I have formatted this into dd/mm/yyyy since taking the screenshot but there are no other changes. Above is the query I am trying to get working: [Week...

I tried using DatePart('yyyy',[Week Ending]) And DatePart('m',[Week Ending]) as the criteria but that didn't work either.

Ok, thanks for the explanation. I am looking to have the user enter a date [Week Ending]. Once this is entered I would like the return to be compared to [RICT Month] and return [RICT Per Week]. The rest is from calculations but relies upon the query returning the correct month's [RICT Per...

I have setup the following query: RICT Month is a date set as dd/mm/yyyy (e.g. 01/12/2016) while Week Ending is the same format but as the label suggests is a week ending date (e.g. 10/12/16) The above query is not returning anything. but if I leave Week Ending out I get the following: As...

That is almost it but I see 10/12 is being repeated. Is it possible to have all the results for 10/12 on one line so 10/12 would be 124 for sum of total effort and 6 for NPS per week? I feel both columns need to be sums

I am using the following to update a field: Private Sub RICT_Month_AfterUpdate() If Not IsNull(Me.[RICT Month].Value) Then [RICT Month].DefaultValue = "#" & Me.[RICT Month] & "#" End If End Sub 1. How do I make it see the date as 1 August rather than 8 January? 2. When it carries over how...

Had a bit of a different thought on this. Is it possible that if a user enters a date (say 29/01/17) that the return line is the one from 1/01/2017 from the picture above? This would work almost perfectly for me

Perfect! thanks mate

Cool, thanks for that. I setup the query as suggested. The problem is my data comes to me in a monthly format and I need to break it down to weekly. is there a way I can make the query list the week ending for each month that data is given? As you can see from the pictures below; my query is...

Would it be better to set it up as a query then? The problem I have is I need to store the data back in the table so I can reference it later. The user will be able to change a percentage and the other fields calculate. I have it working on a table already. I see the link pretty much provides...

Yearly NPS planner

Here is another example on the query I am actually wanting all this on: As you can see from the original picture the sums are no longer correct. I am referenceing the querys wrong, I just don't know what I am doing wrong

Here is a copy again. Query names are at the top of the pics

I have this query working as I expect and want it to also show on the query above. This: gives me this: Granted, I have done this on the Weekly Baseline NPS query but the details should be the same whether I have it on this one or the original one. I would prefer to do it on the query...

The above is what I have. I want a second number column that shows the contents of either table RICTWeek or query Weekly Baseline NPS shown against the equivalent date. This is how I tried to set it up: As you can guess it didn't work

The above is the query and I want to place it in this form where the #Type! error is: I tried to use DateValue but it threw up the error above

I'm trying to add [RICTweek]![NPS Per Week] to the query [Weekly Predicted Effort] but as soon as I do it throws all the sums out. Is there a way I can add this column so I can graph it? Thanks!

Same question but this time my query has times in it as well. Where do I put the format in the following: =DSum("[NPS Per Week]","[Weekly Baseline NPS]","[Weekly Baseline NPS]![Week Ending]=#" & Format([weekEnding7],"mm/dd/yyyy") & "#") The following is what I thought it should be but doesn't...