Search results

Could I be having problems due to Date Won actually being: field name: Date Won is the space an issue?

Date Won is: Date/Time Format: Short Date Input Mask: 99/99/00;0 Anything else I can check?

SQL As requested, this is what it's putting in: For: >= Date()-60 SELECT [Listener Database Master].FirstName, [Listener Database Master].LastName, [Listener Database Master].Address, [Listener Database Master].City, [Listener Database Master].State, [Listener Database Master].PostalCode...

Oh there's no need! I'm just trying to understand why that would help to make it work - since its a lot more work. This is an internship and it's an added thing i took on my own =) If it'll make it work I'll do it - I just don't see the logic as to why it would!

Thats all I'm doing. I have a query that has FirstName, LastName, DateWon and PrizeWon In the query designer, in DateWon, I'm cut and pasting the suggested entries into the Criteria for DateWon I then preview - and get all records..... I'm not using any code or SQL - what shows up in...

Thank you for the suggestion. I mayh compress it and bring it home and attempt that. However given the amount of time there etc I'm not sure this will really be a viable solution. There is no way to do it short of overhauling the database? They don't even track the name of the contest that...

I tried both of these, as well as using Between... Both of these give me 4096 returns.. which is every return, including dates from the year 2000.... The date field in the table is ShortDate... an other ideas how to fix this? thanks!

Thank you! =)

Greetings, I need some help with a date function, if anyone is able. I have a database, and held within its contents is a list of contest winners. One of the rules however is that one person can not win more than one contest every 60 days. Unfortunately, people still enter ;) To this end...