Reports

Report Error for certain Crosstab Query
I'm developing a report that uses as its recordsource a crosstab query. All works well until I run a query where one of the columns has no data. For example, let's say I had a table that showed inventory at different stores and a crosstab query that pivoted on ClothingType and I had "Mens" and "Womens" in the... 2 Jul 2008 18:05

Sum Problem
I have a control called TreatWeeks in the Detail section of a report. Its ControlSource is: =Int([LOSDays]/7). This produces the desired result in the Detail section. In the Report Footer secion, I created a control with a ControlSource of: =Sum([TreatWeeks]). When I run the report, I get an Enter Paramet... 2 Jul 2008 17:03

duplicates within fields
Hi I have a table with the following fields: Surname Address Phone number Date I want to create a query that shows the latest entry for a particular surname, so if I have the following in the table: Smith, 1 New Street, 01234567, 01/06/2008 Smith, 5 Old Road, 76543210, 01/07/2008 Jones, 14 The Avenue, 98... 3 Jul 2008 04:18

Cannot open any more tables
I've read through previous posts regarding this error and tried printing even without previewing first, and I still get this error and the last two columns on my report do not print. Originally, I had 18 subreports based on 18 queries. However, I was able to consolidate my queries down to 9 since they were essent... 2 Jul 2008 11:54

Grouping two fields together ?
Hi, I've been trying to search for an answer, and haven't come up with anything. I'm hoping it's possible. I have three fields on a report: [DocumentNumber], [DocumentTitle], and [Filed With]. The [Filed With] field will be a document number that will coincide with another record's [DocumentNumber]. I am hopi... 9 Jul 2008 12:41

query to update data
I have the following data sr no1. no2. no.3 no.4 no.5 no.6 1 1 8 11 25 30 32 2 4 8 19 28 30 45 3 7 14 20 31 35 39 4 4 12 15 20 43 48 5 9 16 21 22 26 36 6 5 17 28 29 31 47 7 20 13 15 30 ... 4 Jul 2008 14:07

Chart based on data in the report
I'm looking for an answer how to make a chart in the report, but this chart has to take data from cells in the report. I have a report that collects data from queries and make a some mathematical operations on them. At the end of the report I make a summary of the data (also data which comes from mathematical op... 2 Jul 2008 09:50

why is report wizard coming up with "expr1" instead of "name"
Thanks Duane - will have a go "Duane Hookom" wrote: I expect you might have changed a table name or similar. Try create a report without using the wizard. -- Duane Hookom Microsoft Access MVP "Rosie from Sussex" wrote: When I try to create a report using wizard, and it ... 8 Jul 2008 07:58

Ledger for Individual Customers
I have following tables. I have not included all the fields and all the tables but the fields that I thought that are important for understanding the database structure. 1) Orders: Order ID (P.K) Customer ID (F.K) Employee ID (FK) Order Date Ship Address Ship Date, PO number, Ship Name, Ship Address, Ship St... 2 Jul 2008 11:54

Can I execute 'send object' using a pdf format?
I generate long reports, sections of which I distribute to different entities using the 'where' clause in my open report action. In the send object action, the choice of formatting is .rtf, .xls and others - but I really want to use a .pdf. How can I do this in Access 2003? ... 2 Jul 2008 23:13