Search results

Hi been a while since I followed this up! I now have =CLng([0]+[1]) in the control source of the text box on the report but it is still concatanating it instead of coercing it to an integer

Hi there! I have a query which outputs Numberofworkdays as rows. The Numberofworkdays could be between 0-12 but at the moment if there isn't a value between that, then that isn't reflected in the cross tab query. I need to have the column headings specified as something else (hospital) so i...

I have a conditional query: IIf(([202 Method of Admission] = "1. Called GP who saw patient then called emergency services" Or [202 Method of Admission] = "2. Called GP who called emergency service then saw patient” Or [202 Method of Admission] = “3. Called 999"),"Called 999", IIf([202 Method...

Hmmmm - in excel is a space deemed a character - maybe I could apply validation rules to the postcode data?

I do need need inner join though as I am looking to join fields postcode fieds that are the same in tblrehabaudit and tblpostcode. I only get 321 records returned though - there should be 1609

Just to verify my PK and FK I have tblrehabaudit with ref as a PK tblpostcode with postcode as a PK An inner join from postcode in tblrehabaudit to postcode in tblpostcode

Something aint right - I have SELECT tblrehabaudit.postcode, tblpostcode.SOA1 FROM tblpostcode INNER JOIN tblrehabaudit ON tblpostcode.POSTCODE = tblrehabaudit.postcode; as a query and I get 2 results there should be 1609 results because that is how many records there are in tblrehabaudit

I can do that but I am not sure what join type to use in relationships

Hi! I have three tables tblaudit - has 1600 records - one field has postcode tblpostcodes - has 230000 records - one field is postcode, another is lsoa tlbdeprivation - has 32000 records - one field is lsoa, another is score What I am trying to do is run a query that selects the...

Been a while.. since I looked into theory of normalisation but I would welcome some links for sure. I am sure I am limited though to creating just two tables. The table is big at the moment - yes - it covers clinical event, presenting symptoms, prescripitating factors, associated factors...

I take your point about the lack of relations in the database. What I can do is have two tables. One called tblPatient, the other called tblTreatment. The aim being 1 patient could have one or more treatment episodes. That is all I can do to normalise this surely.

I have a form where you enter a start and end date and a report is run. The source for the report is a cross tab query. This was working like a treat but now the error message says the microsoft jet engne doesnt recgonise 'Date_referred' a a valid field name or expression. see attached...

Thank you for the pointers guys Muchas apprreciatos

Is there a way to change the font size and type of all database objects - forms (including labels, text boxes etc), queries etc so they are ALL the same

sorry see attached work so far

I am trying to use form filter but I get a syntax error message (see attached) What I really want is to have a datasheet list out all the patients and then be able to click a record on the datasheet and go into the patient details that way

I found a wonderful example of a search form yesterday that let you do a search by one or more criteria but I cannot find it. What I am trying to do is search for a patient and click a command button which takes me to the patient details. I have searched the forum today but cannot find...

Tis good to know for future reference Dcrake thankyou

Got it! - taken off the reference to link child reference in the Properties!

I have a query which lists date and totals and I want to present this in a column graph. I have done this sooo many times before so I am not sure why this is not working. At the moment only the last date shows and one series!! see attached - for problem illustration