Member Avatar for wezel

Hello friends,

I am looking for a bit of help. Here is the scenario. I am trying to compile sales data for a number of stores from multiple databases and import them into excel for the current month by day. I have a field for date and sales. The problem I am having is some stores are open Sunday and some arnt. When I run my query the stores that are off that day skip a day. If there a way for me to set up my query so that if there are no sales for a day make it zero or force it to use consecutive dating? Let me know if you need more information or clarification.

  • 2 Contributors
  • 3 Replies
  • 126 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by wezel

Recommended Answers

All 3 Replies

Member Avatar for BitBlt

This was a fun one, but I do have a couple of questions about your scenario. First, is this always to run for current month, or do you want to be able to set a date range? Next, were you looking for tabular data, or a pivot? And, did you want to do this all with querydefs or do you want to put it in VBA code? Last, what version of MSAccess are you using?

Edited by BitBlt because: n/a
Member Avatar for wezel

Your assumptions are correct. This report would only need to be run for current month. Cross joining the tables is a great idea and exactly what I'll do. I'm suprised you were able to decipher that. As always thanks to the community and thank you Bitblt + marks for you!

Member Avatar for wezel

Tabular data, MS2007. VB or querydefs are both fine. No preference.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.