In my query builder, I'm getting the message: "The string returned by the builder is too long. The result will be truncated." I think I understand why, as I...

I've just created a report that uses variables from 8 tables with the constant variable being a Subject ID. It works beautifully except for several ids are...

After proofing my tables and identifying a couple of duplicate records and a couple of Subject ID typos, I've been able to reclaim the missing Subject ID...

I have created a database with one table, a query and a form. The table has names, course name, start date, completion date and comments. The query and form...

I need to force the display of detail rows in a report even if values for these rows are not in the data provided by the query. For example the query data...

Is there a way to change the text orientation in label boxes to vertical (ie rotate 90 degrees)?

When I created this database everthing was working fine. Now all my reports open in extremely large font using 24 pages when before it maybe too 2 pages. ...

Please Help I am working on an inventory system. I need a report to show/calculate the following: first grab information by date when opened (which I have...

Is there a method for sorting a report in the design view by a specific order, not just sort in ascending or descending order?

I've posted this question but can't find my post. I have a report with three columns and have the headers set to repeat on each page of the report. ...

Hi I am trying to format the textboxes on an access report I have created from a database query, when the report is populated from the query I want to...

Hi all, Is there a way to choose the destination printer + parameters programatically when we want to print a report? If so, can those parameters be in such a...

MS Access says it will store the settings for page setup with a report. But everytime I print the same report, the settings set previously was lost.

Hi all. Im using Leban's ReportToPDF tool to export Access reports to PDF and convert them to Word XML using PDFBOX (great java library too). My conversion...

Here's the scenario, I have two tables, two queries. Table A contains two fields, Name and Location. Table B has Project Name, Project Lead, Project Lead...

Here's the scenario, I have two tables, two queries. Table A contains two fields, Name and Location. Table B has Project Name, Project Lead, Project Lead...

I have a field in a report and I want to hide the first 4 characters of the field within the report. For example: Qty SKU Description 1...

I know just the basics of Access, and can create tables, forms, and reports, but I can only report all records in the database. I am attempting to be able to...

Access Version: 2003 OS: XP Pro First a little info about the database. This database is used to keep track of checkout information from our production...

I'm a beginner so this might be a stupid questions, but... My report lists all of the employees in a group. Is there a way that I can number the records in...