Search results

Okay, this is a complicated one. I'm not sure there's an actual solution. Each month, we have monthly excess usage charges from our clients. If our client does not have any excess usage, data is not entered for that customer in the database for that month. There is one entry per month per...

Hello all, This might not seem like a big deal, but it's kind of annoying. I'm creating a query with VBA, then exporting it to Excel. I have a couple calculated date fields that are exporting in the format of dd-mmm-yy, but I want them in the mm/dd/yyyy format. In the query, they're in the...

No problem, I had that feeling. Thanks for looking into it! Another problem I'm having with that report is that each group is printing on a separate page. Do you know if there's a way to fix this? I have Force New Page set to No.

No, I have multiple columns in the report (Page Setup > Columns: Number of Columns: 2, Across, then down). I'm using it as a sub-report, so that's why it's Across then down. I've attached a dummy database. The group header is City, so I want the city name to span across multiple columns, but...

EternalMyrtle, Sorry for the delay, but I put this project aside for a while. I'm able to span the report header across multiple columns, but not group headers. Are you saying you create a group header using an expression as opposed to a specific field? Thanks, Jeff

Hello all, I'm trying to make a multi-column subreport in a report that's all one column. I was able to accomplish this by changing the columns to across then down. But each group (in this case City) is on a separate page. I want them all on one page. In Properties for that group, I have it...

I'm not sure what you mean by "add the balance." If I remove the WHERE statement, it shows all 533 records, but the count shows the count of ALL contracts. If company ABC has 1 contract that is Terminated (or Inactive or Null), and no other contracts, I want the query to return as follows...

Do you mean I need to add: Or tblContract.Status Is Null Because that will just add to the count by including records where the Status is Null. I want it to return 0 for customers having only contracts with statuses of "Terminated," "Inactive," Or Null.

Hello, I'm trying to create a query to count each customer's (tblCustomer) Active or Open contracts (tblContract). I'm using a left join, but it's still not taking all entries from tblCustomer - if the count is zero, it's not showing up as a line in the query. I have 533 customers, but the...

This question is rather trivial, as it can be done in design view. If I'm working strictly from SQL, is there a way to format a field as currency, standard number, etc. without using the format() function? Basically the equivalent of setting the format in the property sheet in design view...

Awesome, that worked. Thanks! By your statement "FROM tblNameHistory As tmp," does that create a subquery? And is tmp a reserved word, or just a variable?

Hello, I have a table called tblNameHistory. When one of our companies changes it's legal name, the old name is stored in this table, along with a date that it was changed and its Customer ID (COID). The unique identifier is LegalID. I'm having trouble pulling just the minimum date (by COID)...

Hello, I'm trying to create a report where I can use a section header as a hyperlink to show/hide detail, but only for that section. For example, my customer names are: ABC Co. ZYX Co. 123 Co.If I click on ZYX Co., I want it to show the contracts for ONLY that customer: ABC Co. ZYX Co...

I guess listing the problem would help. It's making the query run slow at times. It only takes a few seconds for the query to load, but if I try copying and pasting (just to see it in Excel), Access freezes. And thanks for the multiply by 1 tip!

I am running into a couple problems. One, I am using DCounts to rank each customer's revenue within a given month. Two, when using DSum, the query yields the correct number, but it's in text format. I know I can use the Format([Field],"Currency") function, but is there another way to fix...

On the pop-up form, there's a text box where I enter [Month End Date], then click a command button to open the report. If I enter "6/30/13," the report should look like this: Company Name June Revenue May Revenue ABC Company $6,000 $5,000 So the June...

Okay, I have follow-up question. I have created a table where the entries are separate for each month, and have therefore added a "Month End Date" field. I have a pop-up form that asks the user to enter the month end date. In the report, I want two side-by-side columns, one for the current...

That was one of my thoughts, but there is a big problem with how the data is retrieved. We have a monthly file (updated daily) tracking revenue in Excel form (With the columns: Customer ID, Customer Name, Usage Charge). I am trying to put a weekly report out, but it tracks the cumulative...

Hello, I am in need of some suggestions. I have a table where I track monthly revenue by customer. So my field names include January, February...December. I have a query that tracks the total for the year, the annualized amount (based on a parameter [As Of Date]), 3 months lagging revenue...

No, I'm only able to center it within the text box. The text box only spans across the first column. Like this: Header Column1 Column2 But I want this:------Header------ Column1 Column2