Search results

Bob, Thank you for the source code, I appreciate it.

Bob, I appreciate the fast response, though the date due back has to be in the table that the form connects to for record keeping purposes, so I need it to do what I specified earlier. This database was pre-built by the person who wanted it done this way and it is one of those things that they...

Okay, so I already looked at the other thread when someone had asked something very similar and the answer was not exactly what I was looking for, so I'm going to ask this: I have a form where a date is put in by the user who is entering the data. It's called Backup Date. On the same form, I...

Brian, Thank you again for all your help. It was a matter of putting select then distinct after it which seemed to fix the issue. Also, I'm sorry to hear about your wife. My prayers go out to you in this difficult time.

Now here's a new one. The query returns three items even though there's only one in the table.

Got the problem sorted. Thanks all for the help. Much appreciated.

Brian, That worked! Thank you! I had the syntax wrong so it wasn't calling it properly but it worked. Thank you so much. Edit: Hmm, interesting. It works, but now one of the populated fields from the input information is not working properly. We have a table specific for "Type of Backup"...

Brian - that is similar to what it looks like in the back end now. However, I still need to be able to query all the tape numbers with ignoring the leading zeros. Tapes look like this: 000001 or 000130 and everything in between.

jdraw - I did remove the semicolon after I posted that and realised that could have been the issue, however it seems to be a problem with the like statement rather than a semicolon issue now. "Syntax error (missing operator) in query expression 'Tapes.[Tape #] = LIKE "**"". What I want it to...

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