Search results

I'm having difficulty linking these two tables' date fields in the query qryDivVolShiftCount - could someone please tell me what I'm doing wrong?

This is really bizarre... basically I've got a table which I've pulled a few columns out of, and grouped. Without any specifying criteria, the results are fine... but if a criteria is specified, one of the columns will return garbage values, with Wingdings and Chinese (literally). I've tried...

In a continuation of this thread here, I have a table which has a date/time field which contains a timestamp (which I can omit, if someone can tell me how to do so with a linked table...) I want to do date-based queries with this, i.e. between Now() and Now()-28, but because it's a text field...

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

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

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 :)