Search results

Thanks, seems to have worked!

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 solution worked for me. I had issues with double-clicking an Access form query.

Stuck between a rock and a hard place... :(

Thanks for that. Sometimes I use the actual date and other queries use periods or weeks though. I guess the reason i've left the dates as it is, is because a lot f the other reports are just linked as CSV files and not imported into Access. I know if I were to import then i can change the...

Thanks guys for your input - indeed it was because of the memo field. Changed it to text and all is well. Galaxiom: the reason the table is there is because the CSV that I use to append includes this field. If I were constructing the table from scratch, I would definitely have the field linked...

btw, Claim Rate Type field type Memo.

I tried changing the SQL code but same result. Here's the SQL code. The strange thing is, it was working fine on Friday, but today it no longer works after I appended today's CSV - I've checked the table contents and nothing looks corrupt? SELECT CLMS004.[Site Cd], CLMS004.[Claim Rate Type Cd]...

That's how it was in Excel; in Access the SQL is HAVING (((CLMS004.[Claim Status Cd])="APPR" Or (CLMS004.[Claim Status Cd])="PEND")).

I've attached an extract of the table and the query.

I've included a copy of the output, a filtered and unfiltered tab in a spreadsheet. The criteria I have specified is on the Claim Status Cd column to show "APPR" and "PEND" results only.

This is going to get interesting, short of me posting a copy of the table and query (is that possible here?) Basically the table is constructed by a CSV, which is appended daily. The field which gets corrupted, and also the field which I am specifying criteria to, is a text field.

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

This worked, win :D thanks. +rep.

That's the strange thing - there are no blanks in the dataset, I tried. As another approach, I used the DateValue() function and that allowed me to convert the text to date - however I think because Access thinks that the field is text, it won't allow me to use date functions to specify query...

I tried it and if I try to give criteria, it tells me "invalid use of null".

It won't work that way, it will treat it as between Now() and Now()-"28" automatically.

Do I do this inline or does it have to be run to convert a table column first?

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

Thanks Kiwiman, sadly those solutions don't look as if it would work if I had a linked table and no import involved at all (i.e. query run on top of that linked table directly)