Any one use Access Database?
Hopefully there are some that use Access as I am trying to set up a database and have a question. The database is CASSETTE TAPE COLLECTION. I have 20 columns starting with ID, TITLE OF CASSETTE, S...
Forum Discussion
If Access is like the others, an auto-increment field is going to do just that - auto-increment on inserts. Delete a row in the middle, and your OCD is going to scream because there's a gap in the ID sequence that's never coming back.
Using ID as the PK is a quick n' dirty way to do it. If you can't filter the ID out on a report (and I don't know why you couldn't) you may have to live with it.
SELECT
Title,Artist,SongLength
FROM
Cassettes
WHERE
(SongType LIKE '%Muzak%' OR Artist IN ('Kenny G') );
:)
PS: I don't know SQL very well!!!
Using ID as the PK is a quick n' dirty way to do it. If you can't filter the ID out on a report (and I don't know why you couldn't) you may have to live with it.
SELECT
Title,Artist,SongLength
FROM
Cassettes
WHERE
(SongType LIKE '%Muzak%' OR Artist IN ('Kenny G') );
:)
PS: I don't know SQL very well!!!
