Search results

If I want to sum the percentages from April, May and June only if a column is Not Null, how would I do that? example Tbl 1 PK, Month Percent Tbl 2 FK, Month Enrolled Qty of Rx in the 1st month enrolled Qty of Rx in 2nd qtr Base (if Qty of Rx in 2nd Qtr is null then Qty of Rx in 1st month...

Pat, thank you soooo much, that was such a big help. one more question. how do I tie the RecID from tbl1 to tbl2? Do I need to join the table using the old PK?

Hi all, I have searched hi and low for this solution and I cant find it. so here goes. I inherited a spreadsheet that uses an Index(Match formulate to return a value. I want to use Access to manage the data going forward. I am just starting to build my tables in Access so I have some flexibility...

Hi all, I am new to this group and to forums in general. I currently accepted a position at work where I need to use Access to convert large excel models into a more usable format. I havent used Access in over 7 yrs but I was a basic user of the app. I am hoping to save hours of frustration by...