Search results for query: *

Hi, I have a problem with a table, I need to compare multiple records and calculate a figure based on where specific fields match - The table looks more or less as follows: Patient_ID Admission Number Admit_date Discharge_date 5055 1 01/07/2002 05/07/2002 5055...

I had never thought of that! Superb idea!!! A star for you... [shocked] Dodgy Chris ----------------------------------- confucious say : better to save a mans life than to build 7 storey pagoda

Sorry Krispi, I wasn't trying to repeat what you'd said, I think we posted at about the same time... [noevil] Dodgy Chris ----------------------------------- confucious say : better to save a mans life than to build 7 storey pagoda

I hate to say it, but this particular piece of functionality is simply not available in Access. An alternative which I've found quite versatile is to use a label or a picture as a button. Then you can make it any colour you like, use any graphics you like and in any style you like. The only...

select * from table where date_sold between #01/04/2003# and #30/09/2003# Obviously you could change the dates to whatever you need, or you could have it as select * from table where date_sold between [Enter Start Date] and [Enter End Date] at which point you can dynamically choose any date...

Please could you give me some details of column headings/ data stored in the table? I'll then take a look and see what I can do. Thanks, Dodgy Chris ----------------------------------- confucious say : better to save a mans life than to build 7 storey pagoda

You could try this: SELECT ListA from ListA where ListA not in (select ListB from ListB) I've kind of assumed that ListA and ListB are different tables, let me know if their columns though, and I'll see what I can do. Hope this helps, Dodgy Chris -----------------------------------...

delete Table1.name, Table1.data1, Table1.data2 FROM Table1 WHERE (((Table1.name) In (SELECT [name] FROM [Table1] As Tmp GROUP BY [name] HAVING Count(*)>1 ))) and data1 = "source" I think this should do it... hope this helps, Dodgy Chris ----------------------------------- confucious...

SELECT tblCabs.CycleDate, Sum(tblCabs.[LUCENT1_Comp]) AS Cabs, tblLDPP.CIC, Sum(NZ([CompletedCalls])) AS LDPP FROM tbl_Cabs left join tbl_LDPP on (tblLDPP.CIC= tblCabs.CIC) WHERE (((tblCabs.Date) Between #1/1/2003# And #1/31/2003#) AND ((tblLDPP.Switch)="lucent1") GROUP BY...

This code is the query that you could use to base your report on. Obviously, you might want to put some Where clauses in it so you can select your dates. I'm not sure if there is any other way of doing it. (Although there probably is...) If there is other data you want included in the report...

Again, this ain't pretty... but might give you what you want... remember, if you turn this into a report, you don't have to display everything that the query produces... TRANSFORM Sum(test.count) AS SumOfcount SELECT "", Sum(test.count) AS [Total Of count] FROM test GROUP BY...

that last message didn't go through my server well... hopefully this'll be the last version of this... UPDATE test AS a, test AS b SET a.end = (b.create-1) WHERE ((a.zip=b.zip) AND (a.create<>b.create) And (a.create<b.create) AND (a.end Is Null)); Dodgy Chris...

Okay, i think I've got it this time... I'm afraid you would have to run it after every record was created, as if there are 3 records with the same zip it takes the maximum date each time... it seems to work though. UPDATE test AS a, test AS b SET a.end = (b.create-1) WHERE...

come to think of it, and having reread your mail, it doesn't help that much... sorry. I'll have another stab at it and get back to you Dodgy Chris ----------------------------------- confucious say : better to save a mans life than to build 7 storey pagoda

I think that this might give you an idea of where to head, it's a bit ugly and makes use of aliasing your tables. I've given your table the name of 'test'. SELECT a.zip, a.create, b.create, (b.create - a.create) as no_days (this gives you your fields) from test a, test b (by aliasing your table...

Try using the following : TRANSFORM Count([Tool Room Operator Table].[job number]) AS [CountOfjob no] SELECT [Tool Room Operator Table].tre, Count([Tool Room Operator Table].[job no]) AS [Total Of job no] FROM [Tool Room Operator Table] where [Tool Room Operator Table].[date repaired]Between...

what you could do is go into the VB behind the form and after whatever event you want (On Lost Focus of the textbox you are updating for example...) Type in the following: [Forms]![Form2]![textbox] = [Forms]![Form1]![textbox] HTH Dodgy Chris

Thanks to all, that really helps!

Hi, I'm running outlook 2002 and every month I have to send the same email to an end user to ask them to complete a job... Is there any way I can automate this? I know that I could set them a task that regenerates, but this particular user is somewhat senior to myself and would take great...