I have an Access 97 application that I converted to Access XP for a client. The application contains reports that use the Format function. For example, an...

Can a pdf file be inserted into an Access 2003 report? Is so, how? Thanks, Al Kaufman

I have an Access 2003 application using SQL Server as a backend. A separate web application allows access to and maintenance of the SQL Server data. For...

Can I generate a report based on an XML recordsource, i.e., without importing the data? If so, how? Thanks, Al

We are storing HTML in a SQL Server field. The front end of the application is an Access 2003 MDB. I need to display the HTML on an Access report. I've tried...

I want to create a report that gives Sales YTD by month for each customer. I get the relevant data from SQL Server and insert it into a local table and then...

I have a report that I am trying to sort based on the value of a checkbox. Here is the code I have (based on Allen Browne's site) Select Case frm!chkDesc Case...

Access 2003 - 2000 format mdb I have the following TRANSFORM Sum(tblSalesYTD.TotalSales) AS SumOfTotalSales SELECT tblSalesYTD.Customer, tblSalesYTD.CustName,...

Access 2003 I have a report that at the moment has all the data from a recordset inserted into a table and then uses the table as its recordsource...

I am trying to insert a word like "Green" if the value is 1 or red if the value is 2 but less 3 or Red if the value is 3. Can someone help? Thank...

I need to print 7 days worth of a report. I tried Today()+7 and DATE()+ 7 to give me 7 days but no joy. Can someone help Thanks AL

I tried with all my efforts to create a report that is due within weekdays 7 days from today but no joy... I have a data element that states due date but...

First, thank you for the suggestions I've found here for subreport page headers and grouping. Now that I have mastered that part, I would like to have a...

Hi All. We have ported over an Access 2000 database program into a Citrix Presentation 4.0/Windows 2003 TS environment. The problem we are having is when a...

I am trying to create a report based on a table of about 10,000 records to display records with duplicate street addresses. I created a report with a grouping...

Hello- Access 2002 user, have a subreport which provides data when available, however, if no data is available in the subreport, the header does not show in...

Copied mdb from access 2000 format to 2003 format but page margins will not allow change. How can I get the page setup to allow changes in margins?

Hi, I am trying to include this structure in the footer section of a report: But I can't get each name of the person to come out. For eg, I have it...

any idea how to calculate Covariance in MS Access database? thanks

When I print out labels using access report, the last line of labels doesn't print. It is skipped. any suggestions