Search results

Can I send you what I am working with so you can take a look at it?

I just checked and I don't see anywhere that I have a "Year" name or function other than this one, unless it shows up in vb.

Hello, I am trying to figure out why my year expression won't work. I have this expression in a query and it keeps saying undefined function 'Year' in expression. I have also disable sandbox to see if that would release the function. IIf(Year([EXPEDITE RAW]![PO...

OK thank you for all your help.

I tried the simple query and it is giving me the same error

That is the only one

Ok it says that the Microsoft DAO 3.6 Object Library Name conflicts with existing module, project, or object library

There are 4 sorry: Visual Basic for Applications Microsoft 12.0 object library OLE Automation Microsoft Office 12.0 Access database engine object library

Do you happen to know what reference library it is in? There are only 3 checked in references.

It says File Not Found. I am also on Access 2007. Would that make a difference?

Brian, can I send you what I have so you can take a look at it? I am very perplexed on this one and as I said I am a fairly new user to access other than basic functions. My AOL screenname is Lilsiskin if you have IM.

I changed it to Bob's format and I still get the same response. IIf(Year([EXPEDITE RAW]![PO Date])=Year(Date()),Format([EXPEDITE RAW]![PO Date],"mmm-yy"),Year([EXPEDITE RAW]![PO Date]))

OK so here is how it shows: IIf(Year([EXPEDITE RAW]![PO Date])=2009,MonthName(CStr(Month([EXPEDITE RAW]![PO Date]))) & "-" & Year([EXPEDITE RAW]![PO Date]),Year("PO Date")) It is giving me a message that says: Undefined function 'year' in expression.

So can I break them out that way. For anything in 2007 use the year only, same with 2008, and in 2009 use date and year? How would that look in a query? Thank you for your help. I am a semi-new user to Access and have not gotten into sql or VB yet.

I have tried that. The only problem is for the current year, I have to have the month as well. That is why I was trying to do the dlookup function.

I am trying to build a column within a query with a dlookup and can't seem to get it right. Here is how it is set up: Expedite Report Raw table has field PO Date - I need to format the date within this field on another field in query Expedite Report Raw. So what I did is create another table...

Aaahhh. Thank you!

Well, I need to create a pivot table from the date field. I have a query that drops into access with a date on it. I need to create a pivot table from that date, but I don't want my pivot table to show every date in the table. I only want to show the month. For Example: Delivery Date...

I have a query from a table that I need a dlookup on. I also have a table with the date range that I need the info from. Here is what I have created so far: =dlookup("[month]","decoder","po_date" = "[date range] between [1/1/2007] and [12/31/2009]") I am trying to pull the "PO Date" from a...