I wanted to use Crosstab query to generate my report. Since the fiedl names depend on the row heading which is vary, I need link fields at run time. Please...

Greetings, I need to adjust a report so that it filters records as opposed to the query doing the filtering. I can't do this in the query because...

I need help with an issure for a ward in a medium stay hospital setting. I have 21 available beds, and patients change rooms daily. I have a database that...

Hi, How do I capture and display the change date of the mdb file in the heading of a report. I'm using Access 2003. Thanks, Marv

I created a report in Access using conditional formatting to show a different background color based on the value of the calculated control based on the...

I have a fairly straightforward report based on a fairly straightforward query. On it I have four fields which represent 30 60 90 90+ aging. On the report,...

How Can I get a report Like this??? ------------------------------------------------------------------------------ --------- TransactionID ...

Sorry for the first 2 incomplete questions. Here is the SQL code I am trying to use. Any Help will be appreciated. Query Error Update WS_Cr from...

When I try to export one of my reports into excel, it's take the leading zero's out of one of the columns that I'm trying to export. The report is taking...

In the footer of my main report I would like to have a total from my subreport. The subreport has the Total calculation - and it correctly sums all...

Hey guys, It's been some time since I have had to come to the Community because of a problem but I have run into a bit of a puzzler. I am trying to...

I searched all over to find how to change the rowsource on a graph. What I have found is that it can be done in design mode or by changing the source query....

Hi Guys, I've read numerous posts and found exactly what i'm looking for, but there must be something i'm doing wrong......Need Help before I go nuts !!! I...

I am looking for a way that, when I click on a report a pop up screen will appear and ask me to enter a category, then OK this will then look through a...

Why would the rpt control =nz(,0) produce #Error on one Access report, but work correctly in another Access report in the same database, using the identical...

I have a report called 06-07 Active Projects. I am trying to use a command button on a form to filter it. The report has a field "date plans received" I...

Hi All, This is my first post in this group. For each record i have a field which is City of origin. I would like an index grouped by City and the details...

Hi In the report details I wrote: If IsNull(Me!Nieuw_gegeven) = True Then Me!oud_gegeven.Top = "0,6cm" End If This doesn't seem to...

This is a repost as my first request fizzled out. I have three tables. TblCompany, TblProducts and TblCompanyProducts. Basic table set up. There can be...

I have been working on a report the new request is to have the percentage rate bolded only if it is lower than 95% - is this possible? This is what I have...