Search results

This seems somewhat wider than required. I'm familiar with normalization. this is about seperately listing answers to single questions, so if 3 answers are possible to one question, how do I get answer1s in column 1, 2s in column 2, etc? Or can I set up a countif function in subsequent columns?

Hi Gender Q: (e.g.) Male or Female? How do I get (e.g.) Male answers in one query column, and (e.g.) Female answers (to the same question) in query column 2? Repeating the question, and specifying the different answers, does not work.

Hmm. Doesn't work for me. Query 1: Age calculated from DateOfBirth. No sub-queries, so Query 2 [Age] and [AgeCount]. Works fine: 73 1-year olds, 92 2-year olds, etc. Now I need to put this into categories, which is where it falls down. New column: AgeCount1-10:[AgeCount],Count, Criteria...

Sorry: not thinking clearly. Now I see this wasn't correct. This is in a text box referring to a sub-report. =IIf([subreport].[Report].[HasData],[ subreport].[Report]![Field].[control],0). Still shows #Name.

Thanks. Can I just check that your word 'control' equals my word 'field'?

Well, not sure how you did. I get #Name. =IIf([SubreportName].[Report]![FieldName].[Report].[HasData],[SubreportName].[Report]![FieldName].[Report]![control],0). Any idea why?

Hi. If you figured this out, how did you do it? I can't get any of my subforms to print, even though they are OK in the report.

Hi Bob. Thanks for this. The sub-forms happily get their date from the date on the form. My problem is this date. If I get this date from a query/table, it won't accept a date unless it already exists on the table. If I set this up as a straight text box =Format([MonthYear],"mmm yyyy"), I...

Hi. I've done as you suggested above, and have created a couple of reports consisting of sub-reports, each using queries. For a simple digest of the previous month, this works fine. However, I now need to offer a choice of month covered, which involves parameter dialog boxes. But how do I...

HI (for Short) is a table. It , as well as the form, shares a (linked) field of Hospital No. The text Box (bottom left) now works fine. On this blank form, a string of 0s, but on real pages, lots of 1 and 2s.

The first one works fine. Thanks very much. (The second one gives #Error)

Sorry, but still #Name? =DCount("*", "Haemoglobinopathy Investigations", "[Hospital No] = ' " & [Forms]![Patient Details]![Hospital No] & " ' ") (Single quotes gapped for clarity: no effect on result. .Extra gaps are reduced by the text box.)

Sorry, but still #Name? =DCount("*", "Haemoglobinopathy Investigations", "[Hospital No] = ' " & [Forms]![Patient Details]![Hospital No] & " ' ") (Single quotes gapped for clarity: no effect on result. .Extra gaps are reduced by the text box.)

VBAInet, your translation produces a #Name (error): =DCount("*","Haemoglobinopathy Investigations","[Hospital No]="” & [Forms]![Patient Details]![Hospital No]& "'") Galaxiom, your translation produces a flashing #Error (error): =DCount("*","Haemoglobinopathy Investigations","[Hospital...

Hi. they're Reference numbers, but with gaps between (as in 75 045 564). Probably safer to treat them as text?

Hi. =DCount("*","Table2","[Field1]=" & Forms![Form1]![Field1]) looks OK according to most forums, but I get Name errors. What am I doing wrong?

Hi. I've got a pretty similar problem, but it's less 'first event' than Sue's. I've got fields on a form showing ethnic categories and ethnic types ( there are 3 or 4 possible types per category). So it's main role is to report existing categories and types. If edited, or new, however, the...

Hi Paul. I've moved it to After Update, but it still fires up on the change from Deceased back to Living. Surely there must be some way to say that if Life Status = "Living", do nothing, else run query (or vice versa)?

Hi again Paul. The routine is working well on change, but it also runs when people change back (eg if a mistake). Is there a 'one way only' or 'only choice 2' easy variant of the 'on change' trigger?

Thanks John. Revised: INSERT INTO [Deceased Patients] (ID, [Patient ID], [Hospital No], Forename, Surname, [Client Type], [NHS No], DOB, Sex, [Ethnic Origin], [House No], Address, Area, [Town/City], [Post Code], [Tel No], [E-mail], [Health Visitor Details], [Patient Referral Date], GP, [At Risk...