Search results

I now have a date field that I want to use. I really appreciate your help with this. :)

Hello EVERYONE! I need help writing a query to grab the Fiscal period based on my Fiscal Calendar table. I am not at all experienced with SQL and wanted to see if you guys have any pointers on where I should go with this. I need to create Month, Fiscal Year, Qtr, and Period columns to match...

Now all my queries won't work. There has to be an easier way, in Excel it is super easy to do an IF statement. But I can't seem to do this in Access. For example, in column A [Working Days] - the data is based on two dates (Req Approval Date and Req Need Date). I wanted to count how many...

The same message is still showing. I think it has something to do with PO_date, ReqApp_Date, and Work_Date. Because I have never called those values. This is the code that I have:

This is what I have in VBA. The query that I wrote was: TAT Status: getTatStatus([Check])

I keep getting the error message - "Undefined function 'getTATStatus' in expression". I think it has something to do with this line: Function getTatStatus(PO_date, ReqApp_date, Work_date) As String Thank you for your help thus far.

So for the ' logic now in query goes in here now' part? I put in the IIF statement? Sorry I am totally new to the technical side of Access.

Hello I am new to Access and have been struggling for the past few days with a query to call the data in one column that is within a data range. I have written both a nested IIF statement and a SWITCH statement. However, when I run it, it looks like it's not allowing a space. Is there a way...