Recent content by din2005

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.