Recent content by DJ726

Ok, I think I found the problem(s). First, the report structure I mentioned earlier.. I should have been more clear and described it as the Excel spreadsheet that my database tables are linked to. So.... the NUMBER_OF_NEW_Circuits field is what had changed to NO_OF_NEW_T1S. I made the change in...

Morning Plog, Sorry about the confusion. Ultimately I'm trying to get to a point where I can create a report that looks similar to the Report Structure tab in the DB Query and Report Example spreadsheet, which is basically a count of orders and a sum of circuits (T1's), per month, and...

oh-oh.... Hi!

Hi Plog, Sorry for the delay in answering... There was a slight report structure change I had to deal with 1st thing Monday morning so I couldn't give this project the attention I wanted to. But along the way I did learn that 1) table names with spaces need to have brackets [] arund them in...

Thanks Plog! This looks like it's all built in the SQL view, correct? Looks like I need to find an additional 24 hours somewhere, somehow this weeked! :-) or maybe it'll be easier than I'm imagining! And thanks fot the link. Hopefully will have some results to work with sooner than...

I've got another thread started where I'm getting some great support, so I'll wait to see what comes out of that. Don't need to have too many people chasing my problems :-) But thanks!! David...

Plog, Both the Order Create date and the Order Complete date are used, but in different scenarios. In the Report Structure Tab, New Orders Keyed (Row 4) or Disconnects Keyed (Row 7) shown will use the Order Create Date (Col C) of the Order Detail Tab. New Orders Completed (Row 5) and...

CJ_London, Thanks for the link and recomendations on naming restrictions! I'm not exactly sure how to apply the code, it looks like that belongs in a form as it's a prompt for a user? David...

Plog, attached is a zip file with a sample Spreadsheet which contains the strucure of what I'm working with, and the results I'm trying to achive. (I went back & re-read the post about the 10 post limitation) David...

Thanks Plog! I'm not sure I can add files yet as I have less than 10 posts here, but I'll see what I can do though. I've been using pivot tables in Excel a lot as well, and that's basically what's driving me to Access. Some of the other reports I have to build are much more complex and...

I've tried a crosstab query for what I'm trying to accomplish (months in columns also) but so far the results are less than promising. I'm still trying to figure this out :-)

Greetings, As I mentioned in my introduction post, I’m *very* new to Access, and am basically trying to learn it (when I have free time) because I’ve been told it will help automate and reduce the amount of work and time I spend building monthly reports in Excel. Because I’m so new and the...

Hi all, I'm located here in the greater Kansas City area where BBQ is king, and I'll be putting some pork butt and ribs on the smoker this weekend! Add in some potatoes, corn, and a salad, and life is good :-) Coffee is another hobby of mine, so in addition to BBQ'ing some meat, I'll also...