null value

Hello, Is there a possibility to use the aggregate function such as the below and ignore a certain values (in my case 0) of the range investigated? =Aggregate(5,4,range) Thank you in advance. Shiro

Hello, I have the below Query Update (query name: Update Os) for multiple different fields from the same table: Field: Account Management Table: tbl_Current Week Closed Update To: Null Criteria: 0 The Query Update works if I'm only updating one field but once I add several more duplicate rows...

Hi. I have never had an issue with this before, but for some reason when I put my data into a pivot table, where I have split the year in H1 & H2, and the corresponding quarters; I am seeing headers for Q3 & Q4 in H1. Which there should not be. There is nothing in my raw data, and the values in...

Hello dear excel users. I have a problem regarding hiding rows in my excel book depending on the content of each cell. To begin with its pretty forward, hide all rows where the sum of all cells equals 0. But the tricky part is where i want the rows with cells that says something with total...

Does anyone know how to use vba to post a null value into a database? I have already tried assigning the value I send to the database to Null and vbNullString but not luck. Each time I go into the database the value is set to "0"not null.

Hello, I wish I could provide a screen shot, but I am new to the forum and am not sure exactly how to properly display my image. Issue: I have a Prepare by Section (cell C8) and a Date Completed Section (Cell C9) and I am trying to force the user to fill out these two fields based upon their...

Hi All, I am using the following module to calculate networkdays in Access: Option Compare Database Public Function Weekdays(ByRef startDate As Date, _ ByRef endDate As Date _ ) As Integer ' Returns the number of weekdays in the period from startDate ' to endDate inclusive...