Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dodgychris

    Update table row by row

    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...
  2. dodgychris

    Button colour on form

    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
  3. dodgychris

    Button colour on form

    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
  4. dodgychris

    Button colour on form

    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...
  5. dodgychris

    Problem Creating a Query

    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...
  6. dodgychris

    Problem Creating a Query

    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
  7. dodgychris

    Unmatched query

    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 -----------------------------------...
  8. dodgychris

    Delete Duplicates with a twist

    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...
  9. dodgychris

    Need help with query that contain Nulls

    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...
  10. dodgychris

    Report Columns

    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...
  11. dodgychris

    Report Columns

    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...
  12. dodgychris

    Query Question - HELP

    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...
  13. dodgychris

    Query Question - HELP

    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...
  14. dodgychris

    Query Question - HELP

    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
  15. dodgychris

    Query Question - HELP

    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...
  16. dodgychris

    Suggestions / better ways to approach?

    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...
  17. dodgychris

    Can anyone help

    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
  18. dodgychris

    Scheduling an email to be sent automatically

    Thanks to all, that really helps!
  19. dodgychris

    Scheduling an email to be sent automatically

    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...

Part and Inventory Search

Back
Top