Search results

Do you have access to the design of the source query? The join property of the two tables are linked by patient number. Make the join (by double clicking the join line) to option #2 ( Right Join). This gives you all records from diagnosis and only those demographics that match.

I imagine you have a field in your query called something like " "amount purchased" In this control source of the field in the report type something like this: IIF([Amount Purchased] Is Null,0,([Amount Purchased]) This will place a zero in the field when the amount purchased was zero if the...

Is the report based on the table or a query? If its a query add the table field to the query and then from the report design of the desired report choose "field list" from the icons at the top and drag the field to the report.

In the database window select Reports and go to the desired report and right click and choose "Object dependencies"

I created a report that due to a criteria is generated for one certain day, for example (06/21/06). I can run the report for any day, any department except for 1 department. When this one department is selected I can only generate one report for 1 day. When I attempt to select any other day...

I need to change the primary data source table in my DB to a different table. The new table is an external linked table so i cannot just change the name. Is there an easy way to update all queries and reports to reference this new table?? Thanks.

I created a report where is lists sales volume by day. I was asked to create a table where data can be excluded from this report. The exclusion table consists of only three fields: Date Department and a check box What do I need to do in the query to have it exclude the data listed in this...

I created a report where is lists sales volume by day. I was asked to create a table where data can be excluded from this report. The exclusion table consists of only three fields: Date Department and a check box What do I need to do in the query to have it exclude the data listed in this...

I created a report where is lists sales volume by day. I was asked to create a table where data can be excluded from this report. The exclusion table consists of only three fields: Date Department and a check box What do I need to do in the report (or the source query) to have it exclude...

Summation in Group footer Thanks Rich but i thought of that so I renamed the field in the detail 'one' and placed the following control in the footer: =Sum([One]) The parameter box still comes up any other suggestions? Also this is a calculation control added just to the report, it is not...

I'm trying to add a control in a group footer where it Sums a control in the details but when i go to preview the report ,the field in the details I'm referencing pops up as a parameter to enter. What am I doing wrong? Here's the control: =Sum([sales]) The parameter that pops up when trying...

I tried this andreceived an error message stating it contained the wrong number of arguments. Am I doing something wrong?

I'm building a report where the detail consists of 3 fields. Sales forecast Actual sales Variance The variance is a % ( .5% -.5% 10%, etc) In the footer I need to create a control where the number of records in the details are counted based upon the variance %. (basically how many...