I hate excel and I hate access

[SPBisResisting]

Just that. They ourk there looking all useful but when I actually need to use tbem they misbehave. I have been workkng on tis all day

Leave the timings as text though, they mess everything up

Wow! I never knew that! Thanks!!

I used to love Access more than I loved my husband (not as irrational as it sounds) but am several versions out of date now. I'd like to get up to speed with it again, as building websites just so I can process data on them probably isn't all that smart. Or, okay, it is fairly smart, but not as smart as knowing how to use a sophisticated DB tool with pre-written code is smarter!

Recommended 2010 Access tutorials for users who aren't beginners, but aren't very good either?

Hah, looking at the verbal logic in my post above, it's clear why I struggle with data processing

Coco pops good, SPB! :)

Well done for translating my garbage! Have decided just to go to bed and get some proper chocolate tomorrow.

No tutorials im afraid. I did miceosoft office user courses that were very good, and the forums are excellent too - doesnt help when yoj just want a problem to gst stuck into I know

Soryr I mean none im aware if or can recommend. Im sure there are plenty!

Your thread has made me decide to allocate enough time to work through the tuts methodically. You're an accidental Access evangelist

The coco pops seem to have perked you up! Well done, sleep tight, and treat yourself to a highly indulgent breakfast before continuing :)

Hmm do breakfast biscuits and a load of coffee help :o
Good luck with the tutorials, let us know how you're gettin on. Lol at accidental access evangelist - what a tongue twister

Leave the timings as text though, they mess everything up

Why the hell would you take a number (in a calculation package) and convert it to a format that requires more overhead with less functionality? Insane

I dont know what she means by timings? As in a time field? In which case yes they are incredinly difficult to deal with and sometimes it is better to do some manipulation. I dont really do a lot with time fields though.

I am getting there tbh holding the data in access and pivot in excel. But it has been so frustrating and such a waste of time :(

Ive already got access for another purpose but read omly not write. And tbh im so far through now im better off just continuing. Nothing in it happens fast!

Well thats the thing I only have read access on the sql server. Id be happy to query the sql server directly as i dont like acceaa but its just getting the data on. someone else woukd have had to load it and by the time he was in thjs morning I was most of the way througb the worst of it.

Load it on or give me permissions to create databases.

i love excel