Recent content by antihippy

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

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

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.

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?

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

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

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?

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

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

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.

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

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

Thanks I'll check it out.

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

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