New employee: Access qry won't bring back value?

gjgriffith · November 15th, 2011, 01:56 PM

Hi SunnySide,

Well, I'm thoroughly confused now too. The code you provided above is a "SQL Statement", which is much different than "VBA Code", which you also referred to in your previous posts...so hopefully you can see my confusion...you are asking one question, but what you are asking isn't what the real problem is.

I think we give this one more shot (...otherwise, I just may not have the ability to help you on this problem). My question is: Can you please explain (in as much detail as possible) exactly what you are trying to do here and why exactly you believe it is not working?

Thanks,

SunnySide · November 15th, 2011, 02:19 PM

I'm sorry I can see why your confused. I am not using SQL, only VBA in Access. I have a new database with one table that has the current date in a cell.

I created a table named MonthDate took off the Primary key, and changed the Field Name to CurrMonth, and in the Default Value I entered the Now() Function.

I created a Query looking at MonthDate, pulling field CurrMonth into the Query and made a second field called PrevMonth. I entered the formula Month(Now()) just to see a month in the second field and make sure it was working, but it didn't bring anything back. Instead it was blank or null. I'm expecting the Month 11 to come back. It didn't.

If you're not able to help do you know of anything I can try to figure out why it would return a null value?

SunnySide · November 15th, 2011, 02:39 PM

Okay....I think I figured out why this wasn't working.

I entered a Default Value - Now(), but when I created a second column in the MonthDate table and entered Dates in there it worked. I believe the data in the table has to be entered, it can't be a Default Value.

Thanks for your patience with me.

gjgriffith · November 15th, 2011, 07:45 PM

Hi SunnySide,

I'm just glad to hear that you got it figured out! Good luck on your Access endevours!

Thanks,