Search results

I have a crosstab query that generates counts for deaths (two categories - primary & secondary causes) within age ranges (generates zeros if none). The query generates the results OK. For example: PCauseofD SCauseofD X Y 0to10 11to21 22to30 31to49 50to69 70plus 0 0 5 0 0 1 X...

I have five tables that are related by 1 to 1 relationships (I broke down a former very large table into five tables, the fields are unique and I have normalized them as much as possible). I am trying to create/run a delete query (form a command button) which will delete the record from each...

I have a report with two subforms side-by side in the report's detail section. There are no headers, footers, nor page breaks. The problem is that the first page of the report is blank. Each subform is approximately 22"x3", so I am not sure if this is related to the blank page (each subform...

I have a QBF form (Form1) which displays a subform of records (in "Continuous Forms" view). I have a "More Details" button on the subform which opens another form (Form2) which I would like to display additional data (from same query) for the current selected record on the subform. I do not...

I have a single table that has duplicate records. For example, two records (call them "record1" & "record2") would have 5 fields, which are identical in both records. Record1 might have 4 other fields which have data, and Record2 might have the same 4 fields without data. What I would like...

I have two tables that each contain a memo field. I would like to know if it is possible to have an append query that only appends the contents of the one memo field in the one table to the contents of the other memo field in the second table. Thank you.

I am trying to generate a query & then the report that counts on one of two groupings of data. I have one table, tblSurveyResults, which contains the following info regarding a person's primary and secondary ownership goals: Primary Own. Goal Secondary Own. Goal Age...

I am trying to generate a report that counts on one of two groupings of data. I have one table, tblSurveyResults, which contains the following info regarding a person's primary and secondary ownership goals: Primary Own. Goal Secondary Own. Goal Age House Boat 25 House Boat 20 Car Car...

I have a strange thing happening with textboxes on a report. I have a report that has a textbox field with a calculated control source (from a query). I only want to display & print the results of the control source, and NOT the report Name (from the textboxes' properties sheet). What is...

I am trying to find a good example of how to pass selected multiselect listbox values to a query and report for printing. Thank you.