You don't show any records with an "items produced" value/field. Your QCTable doesn't have any values that match values in the ItemTable. I can only assume...

Can someone help me, I need to merge text strings from records with the same data. How do I go about this. Fons

How can I count the number of checked checkboxes on a report? I want to get a percentage, so I need: (Number of Checked Checkboxes/Total Number of...

I have followed the support.mdb suggestion to create a report with Dynamic Headings. I created unbound fields called Head1 - Head 22, Col1 -Col22 and Tot1 -...

I need to be able to print the Ansi Character set symbol for "Section Symbol" on an Access report. It is code Ansi Code value 167. It looks like the capital...

Four Report Problems: (So you know my Control Source for the Report, it is a Query.) 1)Sometimes, the FieldID AutoNumber, ie,�45,� shows in the Report...

I have a survey that had 38 questions that had multiple choices. I imported the reponses to the survey into my Access database. To count up how many people...

Hallo I using the RTF2-Object from Lebans under Office XP with Access XP it works correctly. if I use the Application under Office 2003 with Access 2003 it...

Using A2K. How do I hide text in a group header? I have some text in the group header that I want to print only on the first page of the new group. I want it...

I have created a ranking query that works just fine. Rank Total 1 978 2 927 2 927 4 916 When I try to create a report...

Hello: I'm working on a library database to hold books, both print and digital. I'd like the report to print either the title of the book in plain text if the...

I've got an Access report that prints one, two, or three groups on a page (using keep together). When the page breaks, there is usually some blank space at the...

I have a multi-select list box where the user can chose to print multiple reports at once. Where do I position the vba code to bring up the print dialog box...

Hi friends, I have a column in access report in which a particular column(say "columnBool")is attach to datasource whose datatype is BIT. Hence a checkbox...

In one of my Access 2003 databases I have a date field formatted to date, BUT some dates I cannot recall exactly and so I have an 'Alternate date' text...

How do I calculate values in a field on a report detail? First I have database fields called FabricBasePrice and FabricRiserI. The report recordsource is...

Hello All, I have create a bunch of Access reports that work very nicely and are exportable (either to PDFs or the Printer). Now we are moving to SQL...

I have a report with two groups. Group0 Header Group1 Header Detail Group1 Footer Group0 Footer All groups(0 and 1) contain "Totals" for the report.

I have a simple query that gets all the results, that are not null, of one column for a predetermined date from one table. The results are 5 different text...

There is a generic concatenate function with a demo at http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane -- Duane Hookom MS Access...