Recent content by State

Problem Solved! Thank you for your help - I was not entering the column headings EXACTLY as they appear on the resultant query. Once I fixed this, the query & report ran OK. Thanks again. Paul

My Column heading field in the crosstab is the following: AgeGroup: IIf([Age]<=10,"0to10",IIf([Age]>=11 And [Age]<=21,"11to21",IIf([Age]>=22 And [Age]<=30,"22to30",IIf([Age]>=31 And [Age]<=49,"31to49",IIf([Age]>=50 And [Age]<=69,"50to69",IIf([Age]>=70,"70plus")))))) I tried to list the column...

Identified problem! - need solution! Eureka! I discovered that if no data exists for one of the age ranges (for example, no daaa for the 0-10 age range), then the query will not generate the 0-10 range column. That is why the report is not generating - it needs this field, but it does not...

Update Part II - Here is another clue to this problem: Trying to enter a date range with a beginning date of 3/30/02 now generates the following message: "The Microsoft Jet database engine does not recognize '[0to10]' as a valid field name or expression. (Error 3070)" Any ideas? Paul

Update: I replaced "DummyField: nz(Count("x"),0)" with "DummyField: Count("x")" in the query and was able to generate the report. Now, however, the report will only execute for a certain beginning date in the date range (I am entering a beginning and ending date range to run the query &...

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...

Thank you Pat and BLeslie88 for your assistance and further educating me in Access. I had referential integrity enforced, but was not aware of cascade delete. Once I selected cascade delete for each join, the delete query worked like a charm. Have a great weekend. Paul

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 checked and the "Force New Page" property on the detail section is currently set to None. No other sections have this property. Any other suggestions?

Try this (remove the last two "="): =IIf([LINE_ITM_UOM]="ME",[LINE_ITM_QTY_ORDRD]*1.094*2/3000,[LINE_ITM_QTY_ORDRD]*2/3000) Let me know if this helps. Paul

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...

David: Your steps make sense and I will try it out. I really appreciate your help. Thanks again! Paul

Here's a bit more background. This database contains a table which was a result of merged record fields from two databases, one table in each database. There are three "types" of records from each table: 1) Common populated fields from each table (examples: Street, City, code, etc...). 2)...

Record1 has data in fields 1,2,3, and 4 whereas record2 has data in only in 1 and 2 (3 and 4 are empty). For example, record1 (the "good" record for which I want to keep) and record2 (the record for which I want to extract the data that is not in record1, copy to record1 and then delete...

The reason why I am attempting to do it this way is because I have approximately 40 fields that the user needs to view and compare with record1 and record2. I first tried to list all 40 fields in a subform, but the max width is 20". Next, I broke down the 40 fields into 5 groups and attempted...