Search results

haha see? told you so :D I've linked it as a text field now, is it possible to link that field to another table's date field without doing anything else? It give sme a data type mismatch at the moment, but if there's a way of doing it, that'd be great...

I've added an extract of the CSV file to the first post. It's taken me a bit longer to remember than I hoped!

Done that too :) I learnt from previous CSVs which had ""s.

Nah, not dd/mm vs mm/dd. Both date sources are normal (dd/mm) for my region :)

Yep, will do it tomorrow at work. I hope I remember. :p

Definitely did have date/time as the field data type :) My current workaround is linking it as a text field, it's cumbersome but it'll do for now :(

No, they're the ones with dates. The null ones are fine, blank.

Thanks David, I don't think the file contains a footer at that range, I know it contains one earlier on. However even if it does, the values with a valid date should still show up, right? That's the weird part. I'll get a sample of the CSV and see if it makes more sense that way.

I need some help with a linked table in Access. I have a linked CSV file, in which some columns are date fields. I import it as a date/time and when I try to open the table (or run queries) it returns #Num! . The text field in the CSV file is like this (opened in Notepad): 21/07/2009 12:00:00...

I found out that there's a wizard function which does exactly what I was looking for... LOL

First post updated, to make things slightly clearer - I hope.

wow, that was quick :D I was hoping I could slack off work a bit more until I got an answer...! haha. Is it possible to do it in the design view at all? Or is it only in code? I'm not very confident in creating code :) If it helps, the query is like this at the moment. The query has the two...

[SOLVED] Excluding items from a linked table? Hi, So I'm trying to build a query here, and I know you can link fields in different tables to limit the results... but how do I link a field so that it is NOT in the list of results? i.e. in TableA, there's a field "Requester name" with results a...

Thanks Bob, it worked :) I tried that one earlier, but for some reason it didn't seem to like it. Not sure why, but oh well.

Hi, I'm looking for help on how to structure an argument in a query to extract just the month and year out of a date field. i.e. I want to take dd/mm/yy only. Any help would be appreciated :)