Search results

Hi JezzaBelle I did the ECDL a few years ago. I already used Access so did find it easy, but from what I recall it was fairly simple. Providing you study the practice material and do the on-line tests first you should be fine. My sister did it and she was a non-user of Access and she found it...

Fab - works a treat!! Thank you thank you!! :D

Ooo thanks Bob. I'll try that.

That's fine - I can pull it out via another way. Not sure what you mean about using 2 negative numbers. Using negative numbers might be okay, but my next step is to filter those out, because where there's a negative number, there's an error in the data that was entered and I'm not using that...

Ah - (sorry posted mine before I'd realised you'd posted Brian). So if I take out the text from these DDiff fields, my problem should be solved! (?)

Sorry - I'm just a bit confused now!! :D Are both the DateDiff fields returning strings regardless of whether they return a string in one field and a numeric in another? Both fields are exactly the same. The code is exactly the same bar one date field. Any ideas how I can get around this please?

Well, they're they result of an IIf with a DateDiff. So some fields are numeric, and some are text, where I've asked it to reutrn "No Date" if there are no dates in any of the required fields. Here's the IIf: Tm_1stContTo1stScan: IIf(IsNull([dttm_1stcontact]),"No 1st...

Well that's really weird - thank you! I only did this earlier so didn't think I'd need to but the function is now {sort of} working! But unfortunately it's giving the same results as the comparison! So now I have another problem. ie, some records are okay, but others, there is for example in...

For me it works in Northwind, but not in my db. I'm on Acc 2003, SP3.

Doh! Might because I put it in the code option rather than hyperlink: Try this http://support.microsoft.com/default.aspx?scid=kb;en-us;209857

No! modMinMax And in the query I called the field, MinScanTm

Hi Not been around for a while but good to be back!! I find myself using Access again which is great, but what appalling coding skills I did have, have kind of disappeared more or less completely apart from the dead simple stuff. I have a query, where there are a few fields which are looking...

The reason the column headings are all over the place is because they're from an external source that I have no control over and I realise the problems with this. So I was copying and pasting just the data I needed, then appending that to a table with my pre-defined field names. But this works...

Here you go - thank you!

It may be easier if I tell you exactly how I'm doing this (sorry I probably should have done this first!) Once the table is downloaded into Excel from the external db, I'm importing (at the moment just copying and pasting, but will try and do some sort of automated function). Then I'm...

Thank you ... but I had already tried that and it converts them all to null. One thing I did just try was Format in a query: Format([DtTm_FirstOnsetSymp],"dd/mm/yy hh:mm:ss") This does work although it duplicates each record by about 3! ???:confused:

Unfortunately, I have tried this already and it clears everything and converts it to Null!

Hi Not been using Access for a while and back using it again. I've got a table that I'm importing from Excel which is originally a download from another system. The date fields are mostly set as Date & Time so are displaying like: 09/04/2009 11:30:00 When I import these into Access they're...

I am sorry. I entered in text partially in haste, partially assuming that people would realise that I had included the () in my code.

Hi - no I did enter the () - just omitted them from my message. I got the error message "a valid date or time is required" on the Text form field options and on the Fillin one, it reads it as text.