Search results

That would be the ideal indeed. However, i am no software programmer, so i think i will have to settle for good old manual work :) Thanks Luuk

Thanks for the reply! I was planning on creating a query that counts the number of records in a timeframe that i specify to be 10 months, i would then insert a calcuated field which counts the number of records in the specified 10 month timeframe. The criteria for this calculated field is then...

I have a table containing the following two fields, one with monthly dates (end of month plus year) and one with profits (per month). However, for some dates the records are missing. For example, for the 31-1-1994 there is no record (not in the date field, nor in the profits field). How can i...

Cheers mate! Works brilliantly. Now i can start using this query in combination with some more challenging nested queries, so i might have to come back to you :D. I didnt have any problems with that header yet.

Hello All, I have already read some of the IFF threads on this forum and tried multiple solutions that have been provided on this site, but somehow Access keeps coming up with the ''#error''. The following syntax was plugged into SQL view SELECT IIf([Group by Fund +...