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 Chriss Miller 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: *

  • Users: antihippy
  • Order by date
  1. antihippy

    Evaluating field: previous against current values

    I decided not to go with Dcount. It seemed to take forever ... What I did instead was to create two seperate queries, one for version one and the other for version two, then link them with a third table. From this last result set I took the membership numbers. Seems to work ok, although it's...
  2. antihippy

    Evaluating field: previous against current values

    Hi there, I'm having difficulty getting a query to work. I have a query which returns a set of infringements. I'll explain: I work for an auditing company and if you fail at an item for more than two years you fail your audit. The results set I have is a query based on multiple table joins...
  3. antihippy

    Problem 1; Cascading Combo box

    Actually I fixed it. I entered me.cbotag.requery in the AfterUpdate property in cboUser. I think I was confusing myself about which objects I wanted to requesry. Seems to work now and it updates dynamically (which is what I wanted). Thanks AceMan you put me on the right track.
  4. antihippy

    Problem 1; Cascading Combo box

    Hey AceMan1 I'm fine. It's Monday and I have the same headache. The damn cbo will not requery. I made your suggested alteration. Any other thoughts?
  5. antihippy

    Problem 1; Cascading Combo box

    Hi There, I've got a problem with cascading combo boxes. First some background: I am using Access 2003 to write a little helpdesk app. I have a Table and form (tbl and frm Helpdesklog) which lists the bulk of the users details plus descriptions of the various requests. I have a second...
  6. antihippy

    Chart Report and Dates....

    Ah! I think I have it - and I think I've been a but thick about it all. Here's the SQL: SELECT Format([qrySCSCADReview]![txtDate],"mmmm") & " " & Year([qrySCSCADReview]![txtDate]) AS [Report Date], Count(DatePart("m",[qrySCSCADReview]![txtDate])) AS MonthCount FROM qrySCSCADReview GROUP BY...
  7. antihippy

    Chart Report and Dates....

    PS: I inserted your Reportdate suggestion and got the following output: 2004: 11: January 2004: x 2004: 12: December 2004: x 2005: 1: January 2005: x 2005: 2: January 2005: x 2005: 3: Janury 2005: x Am I missing something?
  8. antihippy

    Chart Report and Dates....

    Thanks GingerR, Re: 1)I was trying to describe what happens when I look at the graphical output. The problem is that it is numbering according to the month and as I have more than one years data this is a problem. 2) I tried format(blah,"mmmm") but it seemed to collapse all the months...
  9. antihippy

    Chart Report and Dates....

    Hi There, I feel this must be a common problem yet I can't find much about it here or Google. I would like to chart some information based on a date field. Basically I want a running total per month. It's a chart of 'assessments'. X is the month, Y is the value. I have extracted the month...
  10. antihippy

    Need to work out dates that are 16 months in the past.

    Yes actually. I have been using date. I was using now while I was playihg with it as I there might have been a time requirement. Now that I know that there isn't I've changed it to date(). Thanks anyway.
  11. antihippy

    Multiple rows returned but I only want the last one.

    Thanks. Seems to do the trick. I think I was surffering from overload as your solution is ... simple! ;)
  12. antihippy

    Multiple rows returned but I only want the last one.

    Well I've been playing with these options. I couldn't get dmax to work so I tried just max instead. I'm going to post up some sql: SELECT MEMBERS.[Membership Number], MEMBERS.[Approved for JBL], Max(T_CA.AssessmentDate) AS MaxOfAssessmentDate FROM MEMBERS INNER JOIN T_CA ON...
  13. antihippy

    Multiple rows returned but I only want the last one.

    Thanks I'll check it out.
  14. antihippy

    Multiple rows returned but I only want the last one.

    Hello, I've sorted my query out toget me a bunch of records that are 16 months or older. Now I need to decide know which one is hhe last one. This is for a DB which records asessments. Thus you may have an entry for one user but he may have been assessed several times over the last few...
  15. antihippy

    Need to work out dates that are 16 months in the past.

    Ah no. I apologise - there was a typo. oops.
  16. antihippy

    Need to work out dates that are 16 months in the past.

    So it's not me then? Its jsut that when I apply it to a set of data (and I know that it contains records more than 16 months old) I get nothing back. And it's the only limit.
  17. antihippy

    Need to work out dates that are 16 months in the past.

    Hi There! I'm not sure if I am posting this in the right place. I have requirement to add a function that is supposed to look for dates that are 16 months or older in the past. I hate to say this but I cannot get my head round the date functions for this. This is what I tried...
  18. antihippy

    Error - broken reference to the file 'OWC10.DLL' version 1.1

    You have probably got a reference to a missing library. In this case it is probably the 'Office XP Web Components'. To fix this: Log into your DB. Click on one of your forms. Press Alt-F11 to launch the code editor. Click on tools Select References Look through the list of references til you...
  19. antihippy

    working out average number of records.

    Nice one! I know that the param's on the QBE have to be enclosed in '[]' but it was really the 'd' being interpreted as a parameter that was annoying me.
  20. antihippy

    working out average number of records.

    Hi, I've got a question which seems to be quite simple but I cannot seem to get it to work,. I'd appreciate it if anyone can post any suggestions. I have a table (SR). There are a number of columns, of which, I am only interested in CompanyName, LogDate and Requests. What I want to do is...

Part and Inventory Search

Back
Top