I am trying to get my head around using dates in reports (and queries). For example pulling off all the, say, IT problems logged in the period Apr-June 07 in...

Hi, I have a report that is grouped by a field called Type. There are two values in type which are Existing Customers and New Customers. There is a "Type"...

Thanks for taking the time to read my question. I want to put a filter on my report from a form. DetailMonthYear = Between #4/1/2007# And #5/1/2007# is what...

Hello, I want to create a report that shows two lists. The first list will be a list of projects and the second list will be a list of work codes. The two...

I have coded the following inside the report open event: ........ OrderByOn = True If Not LTrim(RTrim(strSort)) = "" Then Select Case strSortOrder ...

I've upgraded to Office 2007. I have several reports that I want to print using a certain printer, 2 sided and hole punched. I've used Page Setup to select...

Hello, I have two fields and is a text field with a list box (target, adjacent (N), adjacent (S), adjacent (E), adjacent (W)). is a check box with a...

I am struglling with the Where condition when I use OpenReport. In a form I have a list box in which I can choose multiple selections. Then in my report I want...

Hi, I have an unbound field on my report, the rowsource contain the following: ="This sub-award is made under the authority provided to "& & " under its...

We have about 70 users on the DB and about 8 of them can not run a command to print a report. They get the message "The Microsoft Jet Database egnine could...

Hi All, I need to distribute reports electronically so save them to word where they appear as rtf files. I thought that the truncation issue that I...

Hello, I've got a textbox in a report, some records of which may contain text within { }. I need to find some way to format only that text (which may be in...

I have created a database to keep track of golf scores, courses etc. It has come time to start creating reports and I would like to report all scores across...

I have a Report which is based on a query with a date parameter. This parameter is user defined. I need to display the dates chosen in the Report Header eg...

If I have a report that generates 8 'cards' to a page and I print 100 pages for example, can I get access to sort the cards in such a way that when the 100...

i have two SQL queries filtering data for my report but I keep getting this error when I run the report. The Microsoft jet database engine does not reconize"...

Do any of you know if there is a way to rotate the subreport using Visual Basic?

I have a report that needs to print the entire contents of a memo column. The con trol on the report has 'can grow' set to YES. The report source is a table...

I have a field in my database where I enter a particular number for each record I would like in a report to show all these numbers in one color & the ones...

I've inserted an unbound object (word 2007 doc) into a report in Access 2007. Font size = 12 in Word, but when I print the report, font is tiny and text...