Recent content by marcnz

Hi JHB, You are correct. I don't know why it wasn't showing. I might have still used the previous version. Case closed. Full rewards to you :) Thank you very much for such a quick and great help. ps: I am amending this post to attach the result showing on the page after clicking the "Thank...

Hi, Yes I read your signature. I still don't see the record that should be showing in the 9/7/13 slot with a start date of 15/7/13. I put 1/1/13 to 31/12/13 in the calendar. Do you agree that the record with a start date of 15/7/13 should be visible in the 9/7/13 week? Thanks a lot for...

Hi JHB, That was very quick! Amazing job. I also thought about having a table with all the week dates as you have done. I didn't find a way to use it without a join as you did. I like the final result, all on one row as requested. However, checking the dates, I spotted one missing entry in...

Hi, Thanks for looking into this. I have attached an excel file with the original table, the intermediate query and the final query. Each on its own worksheet including the SQL statement for each. I apologize I can't provide more information due to the company's restrictions. I hope you will...

Hi, Well, my idea still doesn't give me the result I need. I have attached a spreadsheet showing the query results. As you can see, I should have only one row for DDS account with the "promo" value in each of the week date column, all in one row. Instead, it is not grouping as I hoped and I...

I think I found my solution while walking back home after work. No need to have any union queries at all! It is actually so simple that I was surprised I spent so much time making things so complicated. The idea is that: 1/1/13: iif(startdate < #8/1/13# and enddate > 1/1/13, "my value in...

Hi, I have spent all day trying to figure out how to get a crosstab query in MS Access 2010 that would allow a dump of resulted record in Excel sheet. I only need help with the crosstab issue: 1. I have the following tables: tblForecast tblAccount 2. I have to display the following rows from...

Hi, I have a problem I don't know how to solve it. I have a subform in datasheet view, linked to the main form. There is a running total on the main form based on a dsum on a field of the subform. When I delete a row on the subform datasheet, the main form calculation is not automatically...