Search results

to NBVC: Thanks again! Referencing cells for the start and end dates is ideal. Regards, Irma Wesselbaum

Hallo NBVC, Thank you very much for your prompt and detailed reply. The last formula: =SUMIF(H2:H572,">="&DATE(2009,1,1),I2:I572)-SUMIF(H2:H572,">"&DATE(2009,6,30),I2:I572) works perfectly! With this formula I can now extract sums for any date range. Regards, Irma Wesselbaum

Is it possible to have a DATE RANGE in the criteria part of a SumIf function? My formula =SUMIF(H2:H576,"<31/12/2009",I2:I576) correctly sums up all payments in column I where the payment date in column H is before 31 Dec. 2009. However, it would be very useful to be able to sum up payments...

Dear Brianwarnock, Thank you for pointing out the difference between blank and empty cells. The data I got contains empty cells, so the formula received from Kiwiman works perfectly: =IF($B2="","",IF($A2<>999,"0"&LEFT($B2,1)&" "&MID($B2,2,4)&" "&RIGHT($B2,4),$B2)) Thanks again, Irmgard Wesselbaum

Good Afternoon, Kiwiman, I was very happy and surprised by the quick and absolutely perfect solution to my problem - which I only posted this morning. Please accept my sincere thanks for your help. Best regards (from Melbourne, Australia) Irmgard Wesselbaum

Hi, I am trying to complete a nested If function, but have not been successful --but at least it partially works. The attached spreadsheet shows what I want to achieve in column C, i.e. If Column A contains any number except 999 and Column B is not empty, then concatenate (put in spaces) If...

Hallo Mark, Thanks a million for the fast response. I have changed the code as per your suggestion, and it works perfectly! Regards,

Hi, I have a mailing label report with a text box (txtAddress) containing: =[Suburb] & " " & [State]&" "&[PostCode] which works fine. Most postcodes in the database have 4 digits, but a few of the addresses only have a 0 (zero) in the Postcode field. My question: is it possible to suppress...

Problem solved with 'Switch' function Hallo again, I thought it may be of interest to some members to see how I (with lots of help) got Access to assign categories to customers according to the total amount spent. In a query I put the following code: Category...

Thank you for quick reply Hallo Wayne, Thanks a million for the prompt and detailed reply. I will give it a try first thing tomorrow as it is too late here (Australia) and I am brain-dead at the moment. Regards....Irmgard

Unbound field in continuous formfield to evaluate GrandTotal ----- The above is close to what I am looking for, but I can't get it to work. On my form I have a field 'GrandTotal' which shows the total amount of all orders for each customer. In an unbound textbox 'txtCategory' I want to show...

Compare/find value Thank you very much, Shadez, The problem has meanwhile been solved in a different way, because I found just the right list on the Australia Post website. This list (approx. 13000 locations) includes the corresponding Postgroup numbers (approx. 70). So now I have a new...

Dear Access Gurus, This is my very first post, but I have searched the Access Forum for a few months and found many valuable tips and solutions. Perhaps someone can help me with the following problem/challenge: In a MEMBERSHIP database, I have a table named POSTCODES, which has the following...