Recent content by streamranger

I want to populate a set of mailing address fields based on user selection of which address to use I have a relational database with three main tables: Property, Project and Permit. Each property may have multiple projects and each project may have multiple permits. The property table has...

Thanks for the suggestion, it is definitely more flexible than the solution I found! I will try this on a different query/report on my development list. Since my column headings are not likely to change very often for the report in question, my rudimentary solution should suffice.

Problem solved.... I found the solution elsewhere (on the Allen Browne site), but will share here, too. Since the column headings are derived from a field, you only get fields relevant to the data, so if the criteria limit the records to a period when one of your column headings had no...

Sorry, I just re-read my post and it isn't very clear. I'll try again... The report is based on a cross-tab query with permit types as rows, and engineer's initials as columns. The number of applications received is summarized in the intersecting cells. I found that deleting the summary...

:banghead:It appears to be the column headings in the report based on the Xtab query. The reason the dates of the error are so specific seems to be that there are no data to summarize for one of the column headings. (The query summarizes # of each type of permit each engineer receives in a...

Something very odd is happening - I have a cross-tab query that is filtered on user-defined date range using a where condition of: >[Forms]![Reports_Menu]![txtFilterDateFrom] AND <[Forms]![Reports_Menu]![txtFilterDateTo] the Query functions perfectly. The report based on that query...

Thanks, a text box in the report footer did work with the following as its control source =Sum([CountOfPermit_Type]) I think I fixed something in the underlying query. ;)Ended up abandoning this report for a more elegant crosstab query report.

I have a query that is filtering records from a table, I have used the Totals row in the query to Group By and provide Count of totals. The datasheet view of the query has the total row and is working fine. I would like to display the total row on a report, using the query as the record...

Perfect! Thank you. It works like a charm...now to do the same for five other search forms. :D

Thanks for your response. I know this should be a relatively easy thing to do, but I haven't done database work for MANY years and am feeling my way through this. So, If I understand your suggestion, I can apply the filter property from the form to the WhereCondition of the OpenReport...

I have a button with an 'On Click' [Event Procedure] to filter the form, it is a multiple search criteria filter (see code below). And yes, I want the report to apply the same filter. I was envisioning a third button on my form 'print filtered records' that would open the report, apply the...

I have a form in my database with a series of unbound combo boxes in the header to enter criteria to apply as a filter. It works very well, but the form is too wide to print on a single page. I have created a report using most of the same fields in the RecordSource, but formatted it to fit on...