I'm using Access to create a report with data from a SQL database. I've tried using SUSER_SNAME, but each time the result prints as #Name? Also, CurrentUser...

Hi all, I'm not sure what else to look at here. I have a rather complex query that I am using to underly a report. All the data in the query is correct when...

i have a different multiple total in my report.when i make group total it show only values not the name of the field, but as soon as i make grand total it...

Is the Gantt Style chart avalible inside of Access 2003? if so how is this carried out to generat a report or produce a chart on a form. I hope you can...

Hello, Is there a maximum number of subreports that a report can have in Access? Thank you! MN

I have a report based on a table with multiple fields. Within this report I need to construct some counts based on data within the table. I can do this for...

Hello, I have a report that runs off a linked table. The report generates a leave record for our timekeepers. It works so well. All the timekeepers need...

How do I not show a report if it doesn't contain data? I also do not want the report poping up a box requesting my input to close the routine. Would be nice...

Using Access 2000 Why won't my reports save with the page size I have saved them under? Also, I have chosen to have a field be general number with 4 decimal...

Option group values are always numeric. If these are numbered 1,2,3,... you can add a text box to your report with a control source like: ...

Use the OpenArgs in the open report command line to pass the value to the report Docmd.OpenReport "ReportName" , , , , ,Me..Column(1) In the Report OnOpen...

Hello, How can I express a name comprised of several fields in a report control? I think I have the basic idea: =&" "&. But how do you add title and...

Duane, Many thanks. Just what I needed. CW "Duane Hookom" wrote: Option group values are always numeric. If these are numbered 1,2,3,... you can add...

I have a database that requires the report printout to be by date. how do I do this whenever i have tried they just get mixed up

I'm not sure where you would want to insert the new values into your existing report. I you want to sum years across customers, you might need to create...

Hi I am struggling to do my very first chart at the moment! I have a table of students Maths results. The students are given a mark in December, April...

Consider using the code found at Allen Browne's page http://www.allenbrowne.com/ser-33.html. -- Duane Hookom Microsoft Access MVP "hdfixitup" wrote:

Hi All, I am trying to make a formula that will sum a column in my report which is called . But before it sums the it needs to look at the same row at a...

I have a report that has 2 fields that I need formated a different color when the value is empty. They are & . I have done conditional formatting for them...

I see what your talking about and it helped - but that's not really the issue. My issue is within the report and I don't need to eliminate dups. I did try...