| Thread | Last Post | Replies |
|
| Query multiple fields | 09 Oct 2004 12:14 GMT | 1 |
I would like to create a report summarizing/listing all the occurrances of a particular criteria. For example: I have a form with a subform. The form lists the owner, the subform lists all the associateted issues along with the responsible party.
|
| Setting a report to display a set record number | 09 Oct 2004 05:05 GMT | 1 |
I am creating an Access database for a Taekwondo competition and need the report to display each record in a set position on the report. I have created queries to filter the competitors list down to each individual catagory, once I have a single catagory i want to be able to
|
| Converting Currency to obtain total for report | 09 Oct 2004 04:04 GMT | 1 |
My DB has transactions which involves amounts in USD.How would you convert the USD totals or show both the grand total in usd and the grand total in another currrency such as a fixed exchange rate for brazillian reias? Thanks
|
| Totals by date on report footer | 09 Oct 2004 03:32 GMT | 1 |
I have a report that is designed like this: Location Header:3 Locations Detail: By Date Mon
|
| form total does not appear in report total | 08 Oct 2004 21:17 GMT | 9 |
Ok , heres the deal. I have a form with an aggregate total of cargo tonnage. When I make a report the total is zero. When I check the table the total also gives zero,
|
| autosizing labels | 08 Oct 2004 21:09 GMT | 1 |
I'm probably the only person on the planet whom this bothers, but here goes: I tend to create my column headings after I locate my record fields. Once I have them lined up, I go back thru the labels and change their Caption to what I want. It seems that most every time I do this, ...
|
| Missing spaces in memo field | 08 Oct 2004 21:08 GMT | 1 |
I have a memo field which I would like to have print on a report the same way that it looks going in on the form. As near as I can tell, the field boxes on both the report and the form are the same size, and the font and formatting are identical. I want the secretary to be able ...
|
| Default format | 08 Oct 2004 20:21 GMT | 1 |
I'm trying to set up a default report format and found some info yesterday on how to do it, from Allen Browne. Well, I'm having problems. In the lower left corner I like to print the date and time. So I'm using: ="Date " & [Date] & "- Time " & [Time]
|
| 1 for the guru's & MVP's | 08 Oct 2004 19:33 GMT | 4 |
I have a report with 2 columns setup quite nicely with totals in the report footer. What I need to know is if there is a way of totalling each column seperately.
|
| CROSSTAB QUERY: Combining text across columns | 08 Oct 2004 19:31 GMT | 3 |
Subject: CROSSTAB QUERY: Combining text across resulting columns into one text string. Any suggestions for method to combine text across columns in crosstab query into one text string - when number of
|
| Form entries | 08 Oct 2004 19:29 GMT | 3 |
I have a form to enter data by month. How do you set up the form so I can have a drop-down list that allows you to just click on the neccessary month without having to type it over and over.
|
| PARAMETERIZED PASS-THROUGH QUERY using textbox on form. | 08 Oct 2004 18:04 GMT | 2 |
SUBJECT: PARAMETERIZED PASS-THROUGH QUERY using textbox on form. Can this be done? If so what is the SQL code for Access 2000 (and 2003)? I have tried SQL logic from other
|
| Limit Report Print Preview to One Record | 08 Oct 2004 17:34 GMT | 1 |
I've created a report but want it to print only the record that's selected by the print preview button. Right now the report displays all records. Here's some details. The report queries data from 3 related tables:
|
| small font | 08 Oct 2004 17:13 GMT | 3 |
Using A2002 on a particular report in 1 text box I need to a font size less than the smallest size of 8pt. Any advice on how this could be achieved would be appreciated
|
| Running sums | 08 Oct 2004 16:27 GMT | 1 |
I am trying to design a report that has four fields, city (text field), building name(text field), building area (number field), and leased or owned (logical field). I have set up the report so that it is grouped by city and
|