Recent content by tboles

Thank you for your response! The statement you provided does work as well, it provides the calculated expiration date for all of the entries that were previously there. Unfortunately, when I change the issue date the calculated expiration date doesn't change with it. And if I add a new card...

At the risk of me sounding silly, I'm not sure what more I can show...I'll try There is field call card type issue that is a drop down of PIV, Non-PIV, and Flash and a field call Issue Date that is the date the card was issued. I am trying to calculate the expiration date based on the type...

Hello All! I've never experienced this issue and it is driving me nuts. I'm not super experienced in Access, but thought this was a pretty easy iif statement. I have a query based on a table that has a column called Calculated Card Expiration: IIf([Card Type Issued]="PIV",[Issue...

Good Morning! I am very new at SharePoint and with Access/Access Web. We have a SharePoint list (I guess you would call it the front end), that multiple people enter data. I have it linked to Access so I can create reports etc. However, using the Access Web, trying to create an web query, it...