Search results

Nevermind about this guys n gals, I found a way to get the result I needed using a pivot table. Easy. Cheers, rob.

This should be a quickie I hope - I've got two columns: Date / Hour, Avg Response Time. I want to make a further two columns, one called Date / Hour (unique) and one called Av response/hour I want the Date / Hour (unique) to look at all the dates and hours in the date / hour column and only...

Not sure if you're asking why it does this here emp but I'll answer it as though it were a question :) It's supposed to be like that :) Week numbers go Monday - Sunday as one week. Week number 53 this year started monday December 27th and ended Sunday January 2nd. The first week of the new...

Hi, I've got a multichart Pivotchart and am trying to print it off, however because there are so many minicharts created, they are useless when printed onto the page. Is it possible to split these over several pages (e.g. 6 per page) so that they print off at a decent size? Cheers, Rob.

This works and returns "53/04" for something which happened on 29/12/2004. I guess you could put "WW/YYYY" to return a full year so that there's no confusion whenn it comes to 04/04 04/03 etc....

lol thanks - I didn't think it'd be so simple :rolleyes: Much appreciated!

Hi again, Hope everyone had a good christmas / new year! I need a little help with an access query. I'm trying to add a column called "Week Number" to a database with "logged Date / Time" as a record. I need the date / time field to be looked at and then a week number be produced from it...

Is this possible at all? I can't find any info on it anywhere :(

Nevermind I got it - CDate: Left([month / date / time],9)+Mid([month / date / time],10,4)+":00" I only need the hours so I took off the first "00" Thanks for all the help reclusivemonkey it's much appreciated! cheers, Rob.

Hmmmm, this ALMOST works, it returns 16/12/204 00:00 as an example of 16/12/2004 hhmmss

I'm expecting to need something like this: DATE: Left([Receivedatetime_inbound],InStr(1,[Receivedatetime_inbound]," ")) This code changes the date / time field to display just the date but I don't know how to change it to make it display date / hour.

hmmm, no not really, It's going to be used for a pivot chart to represent data coming in per hour with spikes (in this case the spikes relate to seconds / milliseconds). The databse tracks messages sent to a server and the response time. There's two tables, one with sent / received times my...

Hi, I've got a database with the date / time set as: dd/mm/yy hh/mm/ss, what i need is just the date and the hour, so 22/12/04 15:13:15 would read 22/12/04 15:00:00 I don't need it to round up (e.g. if it was 15:32, i don't want it to display as 16:00). I'm guessing this is easy but I'm...

Hello, I'm trying to have a dynamic title on a pivot chart based on what's been selected in a combo box. what happens is: User click item in combo box Clicks "Get chart" button Button runs a query and displays chart based on this query All the above runs fine and the chart is produced...

While on the subject - is there any code I could add to the Database so that on close it automatically compacts? Rather than set the option on each PC the database is used on? (There's only 3 people who will be using it though!!)

anyone?! :)

Lol, thanks for the vote of confidence pat! I've been using access for two weeks! I never said I was a professional :)

I found Tools - Options - General - Compact on close but is this a database specific (i.e. it will follow the database around as users open / close it) or is it user profile / workstation specific (i.e. each workstation must set the option individually) ???

hmmm, no, i did it via a macro, there's an option in there to set warning messages to "no". by the looks of the code though I'd guess they're doing the same thing. Is there a way to automatically compact the database when it's closed? At the mo it's about 1.2MB after a compression and will...

Success! It's working - I've now got the Append query to run with the button (with the warning messages off) and then when the pivot chart is closed and the front form re-activated the delete query runs to clear the table. Woo. Thanks very much for all the help it's really appreciated!