Search results

Can someone refresh me on using if-then-else statements in VBA, or point me to a resource that covers this? Thanks, Andreas

Is there some way to slant or rotate text for use as a column header? The CFO wants a report that contains 21 columns, and it's proving to be a bit tricky (since IT people never use the word 'impossible') to fit all the headers onto one sheet. Any suggestions, beyond using using a 2-point...

Huh... I can't get it to work. I keep getting a dialog box saying The expression OnFormat you entered as the event property setting produced the following error: Invalid character. * The expression may not result in the name of a macro, the name of a user-defined function, or [Event...

Hi, folks. I'm trying to print a report for a single job classification and its associated data. I'd like the user to be able to select the appropriate job in a combo box, then hit the command button to print the report. I've tried DoCmd.ApplyFilter and DoCmd.OpenReport stDocName...

Woohoo! Solved it! If anyone cares, here's how. My original 'average' control was coded thusly: =Avg(agedSimpleMean) My new control is now coded: =IIf([simpleMeanCounter]=0,0,(Sum([agedSimpleMean]))/(Sum([simpleMeanCounter]))) where simpleMeanCounter is a field in the query that's...

Thanks for your replies, folks. I really don't care if the zeros print or not, just as long as they're not included in the Avg calculations. I'll give your IIF suggestiona atry, Pat, since that's something I was playing with anyway. Thanks again! Andreas

This might be no-brainer for some, but not me. When I created my report I was able to set it to sum certain columns, and that's just peachy, but if I have a column with no value then it automatically puts in zero (the data type is Currency, so it actually puts in $0). You can imagine the...

I'm trying to develop a system that allows a compensation manager to analyze market data. The data comes from surveys conducted by large research firms (Milliman & Robertson, William M. Mercer, etc.) and is divided into job classes. Each job category (such as "Admin Asst 1") has a pay...

Heh! I knew I was overdoing it. Thanks for your help, folks! Andreas

I have a combo box that displays an employee's job code (cboJobNumber), of which there are currently six (stored in the tblJobClass table). It used to display each of the six codes on drop down, but now that I have populated the underlying employee table (tblEmployeeData) to its full extent of...

I'm trying to do the same thing, and one of my former professors suggested using SQL select statements to update the related fields. However, I'm not sure how to refer to a data control using SQL. Any tips? This thing has me stumped; none of the other methods I've seen posted have worked...