Search results for query: *

Is it possible to use iif statement and could you show me example? cheers

Hi all i have query which looks for patients under 18 and i would like them to be grouped between certain ages? for eg. ages howmany 0-4 5-10 11-18 the sql code i have got is this so far.. SELECT PATIENTS.Hospital_no, PATIENTS.firstname, PATIENTS.Surname, TREATMENT.TREATDATE...

Hi all, I have 2 tables... (table1 and table2) i would like to compare them and show records that dont match? could some1 show me an example or something regarding this... many thanks

Thanks for replying, how would i change this so it works with.... tblAppointments and fields are DiaryDate and Slots Also i don't want to exclude holidays or weekends now?

Hi all, I would like to make append query which adds dates for the next 2 years but also adds slot 1 to 3. But does not include sundays. basically a query that creates dates monday to saturday and each day has 3 slots. e.g DiaryDate Slots 19/02/2007 1 19/02/2007 2...

Hi everyone...am still stuck on this query....any suggestions. As lespaul mentioned....i would like the total by OrderID? many thanks

i want it to add the next result e.g ordervalue Running toal 15.50 15.50 25.00 40.50 10.00 50.50 and so on etc (i want the total by orderID) thanks... i want the total by orderID

Thankyou for replying....here its is! I tried puting the dates in the reqDate field but the running total still adds up everything regardless of filtering it using the dates in the reqdate Hope that makes sense? SELECT tblPreOrder.PreOrderID, tblPreOrder.SupplierID, tblPreOrder.SupplierName...

Hi how do i include a where clause so it adds up the value between ReqDate. e.g RunningTotal: Sum(DSum("OrderValueIncVat","tblpreorder","PreOrderID <= " & [PreOrderID]))where between reqdate Startdate and endDate. many thanks

Hi i have this query where i would like to show all private patients and group them by year for e.g year patients 2006 15 2005 26 etc so far i've got this SELECT PATIENTS.Hospital_no, PATIENTS.firstname, PATIENTS.Surname, TREATMENT.TREATDATE, TREATMENT.PrivatePatient...

Hey all i have this subform with a check boxbut also u can maximise this subform to see all the form. Now about the checkbox i want it to do the same functionality in the after update if it was maximised or if it was in a subform... can this be possible? i.e check if u r in subform and do the...

i use this code to add a new record using a button DoCmd.GoToRecord , , acNewRec

its already on increment.... but the increment for some reason has started 1200 when it should continue from 7000 anyway to set increment back to 7000 and goes on 7001, 7002 etc

Hi all, For some apparent reason when i go to a new record it says that there is a duplicate record. When i check my autonumber field theres about 7000 records. now every time i click on a new record the autonumber has started at 1156 and so on and these records have been already done. its not...

I've all ready have code to flash label every 1 second or so... but what i would like to do have another timer event to flash another label every 5 seconds. Can this be done... is it posible to describe it in easy steps and a sample code will be very helpful many thanks.

Hi all is it possible to bring up a record by 2 criteria's e.g ' Set rs = Me.RecordsetClone ' ' stLinkCriteria = "Treatment_ID = " & Me.txtTREATMENT_ID ' rs.FindFirst stLinkCriteria ' Bookmark = rs.Bookmark this shows how to bring up a record based on treatment id How would i...

Hi all am sure this might be a simple one... but am abit slow today how would i show the dates of all patients who have been treated in the past two years to now! do u know what the criteria would be? many thanks

yep worked it out «LESIONNo» «Sided» «PATHOLOGY» «PDose» «PrescripCont» «Next Record If»«LESIONNo» «Sided» «PATHOLOGY» «PDose» «PrescripCont» «Next Record If»«LESIONNo» «Sided» «PATHOLOGY» «PDose» «PrescripCont» «Next Record If»«LESIONNo» «Sided» «PATHOLOGY» «PDose» «PrescripCont» «Next Record...

Hi all! I have this letter which is mail merge but when i try to display more than 1 record the last record does not appear. The mail merge fields am using are «LESIONNo» «Next Record If»«Sided» «PATHOLOGY» «PDose» «PrescripCont» «LESIONNo» «Next Record If»«Sided» «PATHOLOGY» «PDose»...

Hi all i recently exported my project in vb to vb.net. However everything seems to be ok so far, but on certain lines of code its undelined with blue line. When i mouse over it says suchas "type DNSTools.NowPlayingInfo is not defined" I think theres a reference that may have been missed out how...