I am attempting to write a query in SQL for the backend of a MS Access Database. I have several tables set up and a few forms which will use this query to pull and propogate data.
SELECT Tapes.[Tape #], Tapes.Status, Tapes.System, Tapes.[Backup Date], Tapes.[Backup Date Text], Tapes.[Backup Desc], [Type of Backup].[Type of Backup]
FROM [Type of Backup], Tapes;
WHERE Tapes.[Tape #] = LIKE "**";
The parts that are underlined is where I am having trouble. In these particular tables, specifically in Tapes table, I have tapes with leading zeros.
They look like close to this: 000001.
What I want to be able to accomplish with this query is to be able to put into the input box any number say 14 and then pull all the records that have the number 14 in them. The rest of the data will be pulled with them as well, but all of our tapes have leading zeros. Tapes from 000001-000130.
So I'm hoping someone can help. I've been trying to figure this out for a little over two weeks and have had no such luck. Any ideas would be most helpful.
Also, I get a syntax error with the last line saying "characters found after end of SQL statement".
SELECT Tapes.[Tape #], Tapes.Status, Tapes.System, Tapes.[Backup Date], Tapes.[Backup Date Text], Tapes.[Backup Desc], [Type of Backup].[Type of Backup]
FROM [Type of Backup], Tapes;
WHERE Tapes.[Tape #] = LIKE "**";
The parts that are underlined is where I am having trouble. In these particular tables, specifically in Tapes table, I have tapes with leading zeros.
They look like close to this: 000001.
What I want to be able to accomplish with this query is to be able to put into the input box any number say 14 and then pull all the records that have the number 14 in them. The rest of the data will be pulled with them as well, but all of our tapes have leading zeros. Tapes from 000001-000130.
So I'm hoping someone can help. I've been trying to figure this out for a little over two weeks and have had no such luck. Any ideas would be most helpful.
Also, I get a syntax error with the last line saying "characters found after end of SQL statement".