MS Access Help with a Query

[Marvinator]

I'm in the middle of creating database for my own use at work. IN it I keep track of the incoming backup tapes for storage for 30 or so other locations.

i have set up three tables.
contact Info
Tapes Received
Tapes Sent

Each table keeps track of just what it sounds like. once a month, I get the outgoing tapes out of the vault and use the database to note how many tapes are going out for each location.

At this point all works well. Now i want to print out a mailing label. The report feature also works well. Now all of a sudden, the entire thing seems to not be working. This is the third month of using it and each of the previous months everything worked fine.

when I make up a query to find the tapes going OUT I get either NOTHING or I get a label for every entry in the Sent Items Table. Fishy yes?

Ok, here's how I set up the query. I use all the information in the Contact Info table (for the mailing label) and I also use the Tapes Sent Table for DATE. Now, at this point if I run the query, it should give me a list of every item in the Tapes Sent Table, but I get nothing.

Thinking I need more, I use teh DATE field and enter in an input device [Enter Date]. Ostensibly,, when I run the query, it will ask me for the date, I will in put the current date and it will give me a label list for those tapes being sent out today. This is pretty simple stuff. BUT when I run it I get nothing again.

Anyone out there know where I messed up?

[U-96]

Marv, what regional settings do you use?
There is a big date handling issue in Access that you may not be aware of, espeically if you are used to date in the "everywhere-but-the-US" style of date-month-year.
You might try to see if the date is getting mangled along the way somewhere.

Also, have you ensured that the "Date" field is set to the Date variable type? Dumb question I know, but it pays to cover the basics

[Marvinator]

Quote:

Originally posted by U-96
Marv, what regional settings do you use?
There is a big date handling issue in Access that you may not be aware of, espeically if you are used to date in the "everywhere-but-the-US" style of date-month-year.
You might try to see if the date is getting mangled along the way somewhere.

Also, have you ensured that the "Date" field is set to the Date variable type? Dumb question I know, but it pays to cover the basics

Yep, checked all the variables and even took out the mask to see if that was the problem. I keep thinking the problem is in my relationships. Somehow, when I do this query on JUST the Tapes Recieved table, I get exactly what I am supposed to get. If I add in the contact info table, which has the addreses etc, then I get NOTHING. I don't get it......