I provide help with Access applications. I specialize in designing the tables for a new database and fixing problems and adding new functionality in existing...

Is there a reason why you don't use a running sum on a text box? -- Duane Hookom Microsoft Access MVP "Access infant" wrote: Hi, I want to display the...

Hi, I’m using Access via XP Office Pro on Windows 2007. Tables: tblWorkOrder – contains all the parent level information for the work order /...

Hello. I am getting an Err when I put this dlookup in the Detail section of my report. I am trying to lookup ID from tblMain where the year equals a hard...

Using Access 2007 I am trying to build a couple of strings from the following tables/fields. Is it possible to do with this table structure, or would it be...

Hi all, In the detail section of a report I want to display the number of records a query returns. Example query named "support" In the report I want to...

When I print a report I don't want the page footer to print at the end of the report I only want the report footer to print The page header must print on...

I've inherited a DB in Access 2003 and I am trying create a query that will create a pie chart. One table lists and by . There is a Separate field called ...

I have a report with GroupHeader0 and GroupHeader1. The data source of the report is a query. In the GroupHeader0 I have the Purchase Order Header info which...

Hi, Using Access 97 at the moment. After building a report in code using CreateReport and CreateReportControl coding I wish to save the report without being...

Greetings again, This community is a life saver! I think there is a simple solution to this problem, but I'm unable to come up with it. Each page of my...

I realy need your help for the following problem. I need to display some data in a tabelar mode in a report or form, using the data from a temporary table...

Hi, I cannot seem to resolve a problem and I hope someone can help. In the Detail section of a report in a field I use the following equation: =IIF(=" ","...

Hi, I downloaded the sample database "RptSmp97.mdb" and extracted the code I needed. Everything is working fine and I even achieved to mix both Sorting and...

I have a fairly complicated report which pulls in information from various other reports, including some charts. The problem is that sometimes the charts pick...

I have a report that lists months and then details for each month. Problem is that it prints them in this order: April June May, not April May June. How do I...

Hello I have a report which opens based on a query. I would like to open the same report but based on a different query. Can I make a command button (or two...

TIA I have a simple report based on a parameter query. The report shows Account Numbers and the number of Labor Hours that employee spent on that...

Is there a way to change the 'Back Color' of a field in a report based on the content of the field. i.e. If the field contains "R" make the back color Blue, if...

I am trying to sort a report by date using the "order by" property. If I have only two levels of grouping it workes fine, but if I add a third level then it...