Is it possible to set the Report Record Source to an SQL statement?

I have a application that allows the user to record staus of various equipment on a form. I also have setup a report for the various fields to...

In my table I have a yes/no field and I want to send it to a report and count how many yes's or no's in the report. Is there a count if type function in...

Hi guys, I recently bought this PDF MS report merging program. It converts ms reports to multiple page pdf files. My client would like to have cover sheets...

Can anyone tell me why the following won't work when I use a form to enter the dates - if I substitute the variables dteStartDate and dteEdate with actual...

I have a report with two groups. Group0 Header Group1 Header Detail Group1 Footer Group0 Footer All groups(0 and 1) contain "Totals" for the report.

Hi all, I hope someone can help. There has to be an easy answer for this but I can't find it. In one of my reports, I no longer had a need for a line of text...

I posted this quest. and was hoping someone knew or had a suggestion... I created a report (form ltr) that On_Open, I want it to update with -1 If...

I have three separate tables in one folder that I would like to combine and then create one report. I can't seem to export data from one to the other and I...

I have a query with many columns. Some of them are Product Territory Distributor Broker Country Qty1 Qty2 Qty3 ... In addition to creating a report with...

I would like to group data according to month, but am having trouble doing so (See below). I tried using the Dlookup function, but it only returns one value. ...

I've inherited a rather large access database. I've been asked to change a field size (3 decimal positions instead of the current 2). I know how to find...

Hello I am trying to create an Access report which is 5-6 pages long, but Access doesn't allow me to create so long a report (Each section of the report can...

I have a report that the # of pages changes every time i run it and I want to be able to put a date and signature line on the last page any help would be great

I'm generating 50 reports each based on it's own query. I want each of the 50 reports to have the same exact look. How do I get the next report generated to...

Newbie Form / Report using code Question I am tring to generate a form with two combo boxes, using a 'Value List' as the source type and manually entered...

When viewing a report can the zoom be preset to something other than "fit"?? No one can read "fit"

I'm trying to create a calender report (will look like a calender) using http://www.invisibleinc.com/divFiles.cfm? divDivID=4. I've run into a couple of...

Is there anyway to use a list box in a report to pull data from with a query?. This is what I put in the report on the listbox: SELECT , FROM ...

I have a table with the following information: item id, location, cartons, units. With this table I created a report that will print labels but I need labels...