I need to set up a report to count the number of variables by date order. Can anyone give me examples on how to do this? I am using Access 97. The inpurt...

i have a form. inside the form i have a text box & a command button. the command button runs a query based on the value user puts inside the text box. i need...

Is there a way to test (from the main report, perhaps in a textbox) whether a subreport has data or, if it closed because of no data? Damon

I have subreports on my report, that need a border around them. I set the borderstyle to show, and it works fine, except when there is no data for the...

I learned how to reset the page value (using a macro) for each new section on my report. I now also need to reset the pages count. I have a lot of data that...

hello I like to know if a expression is just a function or an SQL statement? Herman

I have a problem with the RTF2 control in Access 2003. I used the example database from the Lebans site by Andre Minhorst to split apart long text into the...

Hello, When I attempt to update my report I get the error #NAME?. Is there anything wrong with the expression below. I'm lost... =! Steve -- Message posted...

I have inserted a unbound text box in a group footer of a report. The formula is to pull up a value from a subreport. It works fine except when the value is...

I want to add a watermark to my report, so I created a report section by defining a new Group with the expression '=1' and Group Header = Yes. I put my...

Hello: I have report that will not calculate certain expression for one record only...I went back to my querie from which I created my report and the...

Hi, I need to create an Access 2003 Summary Report with the following specs. 1) User selected Date Range for the report. 2) The Reports displays totals for...

I am using the following statements, but they return nothing (blank), when they should be returning -18.96 =IIf( = 0,"Val",) =IIf(Val(-)0,Val(-),"") Can...

I have a list of name that I want to use to create a phone directory. The first time the Last Name appears it will be included in the listing each occurences...

I have a report that shows attendances. I have instances of Present, Sick and Absent. I would like to count the instances of each one and have it record the...

I have a form with an embedded subform. The underlying DataSource for the subform is a query. This same query is the underlying DataSource for a report...

I am trying to number an Access report starting from page 41 sequentially through the end (about 265 pages). I can get some expressions (using the Format()...

Hi: I have the followinf problem with my report: Problem: I have created a report in which I added a subreport. Well, I created the subreport using the...

Is there any way I can have the data I want to send to a user using the SendObject Action appear in the body of the message as opposed to being...

I created a basic database that tracks hours/days worked. The report is grouped on the field and that seems to be working properly. In the sorting/grouping...