|
|
| Print 7 days of data on a report |
| I need to print 7 days worth of a report. I tried Today()+7 and DATE()+ 7 to
give me 7 days but no joy.
Can someone help
Thanks
AL on 21-Nov-09 |
| |
|
| Select Distinct subquery in a Report Control? |
| I have written a report that aggregates (avg, sum, count) a 10 or 15 measures
($, Days to Book, # rejects, %within SLA, etc.) I need to do a COUNT
DISTINCT on one control (D&B number) to determine ... on 20-Nov-09 |
| |
|
| Print a Variable |
| I have a routine programmed in the a footer section of my report.
I have a variable
Dim CurrentClient as string
CurrentClient = "[Client]"
I would like to be able to print the variable currentCli... on 20-Nov-09 |
| |
|
| Calculations with empty fields |
| I have a report that is calculating total elapsed time between dates. I have
the calculation working fine if all fields are filled in. However, out of
necessity there will always be fields that are... on 20-Nov-09 |
| |
|
| expression builder NOT |
| I am trying to do a very simple "NOT" expression in a report and keep getting
syntax error.
First of all when you open the expression builder in a report, what are you
connecting at the bottom? Ho... on 20-Nov-09 |
| |
|
| Ms Access Rpt Change prior detail line format |
| How may I CHANGE the format of the Detail line 1 in a report if Line 2 is missing values but the rest of the detail lines after that have values.
I have a report with 60 detail lines for specific... on 20-Nov-09 |
| |
|
| totals based on specific data |
| We are required to track that each employee has a minimum of 12 hours of
training per year. I have a report based on a query that selects active
employee training data during a certain time period e... on 20-Nov-09 |
| |
|
|
|