Search results

I have a custom field in a query Outcomereport: IIf([Outcome] Is Null,"No outcome",IIf([Outcome]="GP","GP",IIf([Outcome]="Cardioversion","Cardioversion",IIf([Outcome]="Cardiology","Cardiology",0)))) but is there a more efficient way doing this so it says if the outcome is null "no outcome"...

I have a form that when you choose a start and end date and click preview - a report is run. In that report I have a three columns and another one that is supposed to be a 'total' Problem is the total column is not summing the total it is concatanating the three columns e.g. column 1 = 3...

The report is run using a cross tab query so what you are suggesting is basically have that query run using VBA. I am not confident on VBA but want to learn. Can you signpost to a beginners thread you know of about running SQL queries and error handling using VBA? I don;t want to be spoon fed...

I have a reporting tool that requires the user to enter a start and end date. At the moment if either date is not entered - the error message: The MS jet engine does not recognise " as a valid field or expression. Is there any way I can over ride this message and create my own

Quelle surprise I am learning after all - I have fixed it myself. I added this into the original query: Ethnicgroup: IIf([Ethnic origin] Like "*White*","White","BME") which means i can group the ethnicity now!

output looks like one attached. Effectively I want to group the Black African/Carribbean and some other ethnic minorities so I have White, Asian and BME. this is the query itself: SELECT [Acceptance by ethnicity, gender and age].[ethnic origin], [Acceptance by ethnicity, gender and age].[age...

I have a cross tab query that results in 47 results. I am looking at the age, gender and ethnicity of patients. Trouble is 47 lines is too many so i want to group the ethnicities into Asian, White, Other and Black african/carribbean instead of the 12 or so that exist. How can I do that?

check out the attachment and you will see what I mean. open frmviewagenda form, pick a date and run report on the report is a text field where the names of people are supposed to be listed for that meeting date The concatrelated function falls over if you specify a parameter in ther query -...

I was wondering what syntax is used to refer to a variable value chosen in a combo box of a form? I am using Allen Browns concatrelated function to list results from a query but I am trying to limit results to a specific date. I cannot use Forms]![frmViewAgenda]![Choosedate] in the query I...

sorry PNGBill - my VBA skills are limited - I can't see how this will limit my report to the Date chosen in my combo box. struggling with this one

hiya can't tell which one on allens site you mean?

I am using Allen Browns ConCat related function to put commas between values in a query with MeetingDate in one column and Apology in the other I have =ConcatRelated("Apology","QryApologys") embedded in a text box of a report to show the names and this works but I am trying to limit it to...

I think what you are asking for is cascading combos? do a search for cascading combos and see what you find good sir

this is cool- I have set up my module - and in the report I have a text field where I want to output the apologies for that meeting. I am using the query qryApologys for that. I am not getting the expected results though see attached I get a too few parameters error message the form to...

that works a treat - cheers guys!!

OK- I have a report called 'Agenda' with two subforms in it which is in datasheet format - There is only a single column of peoples names attending the meeting for thaat agenda but I was wondering is it possible to have the output as comma seperated values instead of a datasheet? The sub forms...

This is most strange as it was working before! I have a search function form but when I click a button 'View patient discussion' to view the record based on a list box item I get the openform action cancelled error message. The form that is supposed to open is frmPatient and obviously it is...

I am not not advanced with VBA really but I can now see how to change where the default files directory is in your code and how the table tfiles is populated. I have changed the directory now and added a field in tfiles table PatientID. I have added fscanDirSelectFromFileTable as a subform in...

Hi ghudons I have tried out the browsing sample - I know when I use ffindopenimportfile form I and click 'Import ' I get an error message: error 2091 field F1 doesn't exist in destination table tblimport How is the database capturing a filepath, and storing it so it can be recovered If...

does your sample capture the file path and put that into a field named 'filepath'.