Hi
I think this is the correct forum to place this question - apologies if not.
Bascially teh set-up I have is this. I have to produce a graph showing quarterly numbers for a (varying) number of regions.
Unfortunatly, some of the data is missing. I can interpolate this missing data by using data from either side of this missing data. I have written this as a function and works fine from the command line and also in SELECt queries if I enter one of the missing dates.
But my question is how do a write a query that will give me a result for each quarter between, say, 2001 and 2003? If I use > and < as a criteriaa for the date field, it simply misses out those quarters for which there is no record (not surprisingly). Ideally I would want to 'force' Access to use each quarterly interval and use my interpolate function for each quarter.
Hope that has explained everything
Richard
PS Please help
I think this is the correct forum to place this question - apologies if not.
Bascially teh set-up I have is this. I have to produce a graph showing quarterly numbers for a (varying) number of regions.
Unfortunatly, some of the data is missing. I can interpolate this missing data by using data from either side of this missing data. I have written this as a function and works fine from the command line and also in SELECt queries if I enter one of the missing dates.
But my question is how do a write a query that will give me a result for each quarter between, say, 2001 and 2003? If I use > and < as a criteriaa for the date field, it simply misses out those quarters for which there is no record (not surprisingly). Ideally I would want to 'force' Access to use each quarterly interval and use my interpolate function for each quarter.
Hope that has explained everything
Richard
PS Please help
