Forespørgsel mellem 2 felter

You can with something like this (NOT TESTED)

SELECT * FROM tbl1 WHERE [Serie Start] <= [forms]![NameOfFormGoesHere].[txtSoegfelt] AND [Serie Slut] > = [forms]![NameOfFormGoesHere].[txtSoegfelt]


Not sure about the LIKE

Hey Terry

I already tried that one, but it doesnt find anything when i type a number that should show at least 1 result

any chance of seeing your dB (table/data)?

ekspertenATsanthell.dk
AT = @

This query is directly on the tbl_serie and returns what you want. The reason it didn't is very likely because there are spaces in the numbers so there must also be spaces in what you're looking for.


SELECT tbl_serie.[Ordre-ID], tbl_serie.[Serie Start], tbl_serie.[Serie Slut]
FROM tbl_serie
WHERE (((tbl_serie.[Serie Start])<="45 45 18 00") AND ((tbl_serie.[Serie Slut])>="45 45 18 00"));


And here it is taking the values from the form (with spaces 45 45 18 00)

SELECT tbl_serie.[Ordre-ID], tbl_serie.[Serie Start], tbl_serie.[Serie Slut]
FROM tbl_serie
WHERE (((tbl_serie.[Serie Start])<=[forms]![kunder]![txtsoegfelt]) AND ((tbl_serie.[Serie Slut])>=[forms]![kunder]![txtsoegfelt]));

Thank you Terry.
I changed it a bit to pick up the data from the query, but everything works fine.
The worst thing is that ive already tried this setup, but not with the spaces in the number..

Thank you very much for helping Terry.

tak og god weekend