Search results

did a few searches and majority of the searches were ones excluding weekends and holidays. so im trying to put together a query where I need to pull prior business day (mon-fri). where im trying to figure out is if I can do this in a query/SQL or in a module? basically I need to return prior day...

I searched around but did not find a solution or something similar to what i'm working with. what im trying to do is whether it would be doable in a query or better off in vba. the dataset i'm working with is a day old, meaning it'll always be yesterday's date and prior. and the work week is a...

hi everyone. fairly new to access and am in the process of capturing retail data where the work day is mon-fri but the weekend and holidays that fall on Mondays like labor day, the number o retails is totaled and considered to be Friday. I did a few searches and majority of the posts were...

[SOLVED]Struggling with If then Else Date I can't believe i'm struggling over something that looks so simple but :banghead::banghead::banghead: Function Check_BA_Local() strSQL = qry_ChkDate If strSQL = Date Then MsgBox "works" Else MsgBox "not today" End...

hi everyone. hopefully someone can help me on this particular issue. right now I have a make table query and one of the fields I created is just blanks. what I would like to do is after the make table, to have in vba coding to turn the one field, lets call it Plan/No Plan, convert it to a...

hey everyone. been a floater on this forum for a while but never signed up. most of the time its cause I was able to search on here for questions on various issues and was able to find my answer until now lol. i'll post it in the table section of this forum. hoping to learn more and more of...