| Thread | Last Post | Replies |
|
| Format currency field on report. | 13 Dec 2007 21:03 GMT | 3 |
I know you can "fiddle" a lot with date formats can you do anything with the currency format? I don't think this is possible but just in case here goes: I have a report where I'd like to have the currency fields formatted so that
|
| email report per record | 13 Dec 2007 20:53 GMT | 1 |
I am trying to email a report. On my form I have a button that the user will click - this will send a report based on the record shown on the form. Private Sub Sheet1_Click()
|
| Access command to select from multiple reports | 13 Dec 2007 17:39 GMT | 9 |
I have a command button on a form that I want to use to print one or two of four letters (reports) based on the criteria tied to the persons account. Right now my statement is this: Private Sub Print_Invitation_Click()
|
| Report returning table ID, not actual table data | 13 Dec 2007 16:51 GMT | 15 |
I have a table which has First Name and Last Name as fields. I have another table used for problems that references this into 1 field called FullName. The properties for this is a combobox and the row source is: SELECT [EmployeeID], [LastName] & ", " & [FirstName] FROM ...
|
| Applying filters in a report | 13 Dec 2007 15:24 GMT | 1 |
I have a report that is sourced to a query. Now in the report properties there is a filter property and I want to further restrict data to the report at this point. I want to first do a simple sub-string extract and then compare the result to a fixed value. For example my ...
|
| Help with Report Grouping | 13 Dec 2007 15:07 GMT | 2 |
If I have 2 sections in a report like this: Reviewer Header Vendor Header Detail
|
| How to squeeze out vertical space in a report section | 13 Dec 2007 13:26 GMT | 6 |
MSAccess 2003 This sounds so simple - what am I doing wrong? My simple report has several fields arranged vertically in the detail section.
|
| Unbound Controls | 13 Dec 2007 02:03 GMT | 3 |
Can I store a field that I calculate in a report in a table. More or less what I want to do is take a stored value on a report and put into a field in one of my tables. Is this possible?
|
| How to Count Records from a Field in a Report Form | 13 Dec 2007 00:56 GMT | 2 |
I have a dbase with many fields with dates. One field is a text field and will only accept certain 2 character alpha characters such as MA, NA, SA, etc... What I need is a report of that one field which will only give me a number
|
| Sum YTD totals | 12 Dec 2007 22:11 GMT | 1 |
I am creating a report and am able to have the report sum the monthly totals from my date range that i am using from my query. How can i also had year to date totals in my report since my query is asking for a start and end date and i only want records from the past month? I ...
|
| Report Columns | 12 Dec 2007 21:57 GMT | 1 |
I am trying to add columns to my report but am having some difficulty. The report is basically a form letter. It is grouped on the employee’s unique ID. In that group header is the letter, Dear so and so etc. It is the details portion that I am trying to get into two columns. Is ...
|
| Date parameters won't work on crosstab report | 12 Dec 2007 18:11 GMT | 1 |
I have queries and reports that show our quotes by lead source. I use date parameters to filter the "QuoteDate" range on which to report. However this doesn't work on a crosstab query or a crosstab report. My row heading is Lead Source (e.g. Yellow Pages, Recommendation, etc etc).
|
| 0 value is blank | 12 Dec 2007 18:08 GMT | 2 |
I would like to print a report where if the value of the field is 0 is prints out as a blank field. Can anyone help me do that? Jana
|
| Running make a table query before final query | 12 Dec 2007 17:21 GMT | 5 |
I have a make-a-table query that is used by query1 for my report. Is it possible to run the make a table query as well as query1 when the report is opened. I know how to do this by using macros but would prefer to use code if possible.
|
| SumIf equation in report | 12 Dec 2007 17:08 GMT | 2 |
I would like to translate the following Excel formulas into Access report expressions: =SUMIF(D3:D485,">0",(D3:D485)) =SUMIF(D3:D485,"<0",(D3:D485))
|