I'm having trouble linking a subreport. I've done this many times in the past with forms and reports and I've narrowed the problem down to the crosstab query....

I want to have a field in a report become red if the field is blank. I can't seem to use conditional formatting for this. Thanks, John

Hey! Sorry my bad English! My Name Is Per Erik Løkken, and comes from Norway. I have been in contact with MVP Duane Hookom regarding an issue with a report...

I am trying to display multiple records in one text box on a report. I can get it to work if I put the text box in the "Details" section of the report, but I...

Duane or others- I tried this and it WAS helpful. I have the following questions: I need to do a crosstab query where the results will be used in a report...

Thanks Steve, I put four queries like you provide "Between...... and .... " . When I get preview report with four different subforms then I decide to...

I have a report (rptHV) that uses a query (qryHV) as its record source. The user opens a form (frmHVClient), chooses a name from a combo box, and then...

Hi, I am using Access 2007. I have created a report where the RecordSource is set to something like the following: SELECT MyTable.Tag1, MyTable.Tag2 FROM...

In a League Table report I have the following layout Season Header - Group on 'Season' (EG 1948) League Header - Group on 'League' (A to Z) Detail - Sort by...

Hello, I have this big report that summary a lot of data. Sometimes a group need to be shown if that group has data on it otherwire I dont want to show the...

I have two things that I’m trying to do in an unbound text box in my report. I have this =Format(!!,"q""Qtr""yyyy") which returns “1QTR2010� but I...

I have Acrobat 9 Standard and generate numerous reports out of MS Access 2007 into the PDF Format. The reports are grouped, but I can only get a bookmark...

I have a table that displays results horizontal, that needs to be verticle, so it shows up on a report in one page, instead of one record per...

What is the "msysaccounts" table in the workgroup information file of Access2003? I'm trying an ODBC connection to an .mdb database and being told the...

Background first: I have a database for tracking contracts. Some contracts are straightforward and only cover one service but the bulk cover multiple...

Hey! Sorry my bad English! My Name Is Per Erik Løkken, and comes from Norway. I have been in contact with MVP Duane Hookom regarding an issue with a report...

Hi. I would like to create a report using the information from a form. The problem is, I have a few "Unbound" text fields where info is manually typed in...

I am having the same issue, but with many users. I created the db in 97 and overtime converted it to xp and only recently started having issues with two...

Hi, all. Lately I resized my database from 800X600 to 1024X740 by using form resizing tool. Ever since I resized my forms, I have problem with print preview....

Thank you so much for your help. I did exactly what you had suggested (using a ruler to make EXACT measurements). Now, it finally worked!!!!! The company that...