I switched the link fields to DetailID and it now works like it should. Can't believe it was that simple!! Thanks!
-- яДGЄРЯΦ --
I have two tables. My forms are set up so I have one form embedded into another each form using a table.
tables:
SYSTEM - contains general system data
DETAIL - contains individual discrepancies by date
forms:
SYSTEMF - contains SYSTEM table with DETAILF form embedded
DETAILF - contains DETAIL...
Jason, more than one LIKE seemed to confuse it and it would return nothing. One LIKE worked of course. Thanks for the idea though!
clarkin, your's worked GREAT! Thanks a lot man!! I had actually thought doing it that way and didn't think it would work... I should have tried it anyway, huh...
I am having some trouble applying extended queries in an ASP environment. I'd like to use the following:
SELECT Name, alphaOrder =
CASE
WHEN (LEFT(Name,2) LIKE '[a-d]') THEN 1
WHEN (LEFT(Name,2) LIKE '[b-c]') THEN 2
ELSE 0
END
FROM table
ORDER BY AlphaOrder, Name
I've tried...
Hello,
I'm trying to output my database by column 'CompanyName' in alphabetical order. Too simple. Now, here's the kicker, I want to start not from A, but from a predetermined letter, say L and have it loop back around to K.
Is this possible with just an SQL query? Or do I have to write a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.