Recent content by gilinnc

I got it guys...it appears I have to place the 'sum' field in the line 6 of the report to get the proper totals. Sorry for asking...just had to play with it...more...

I hit a brick wall on this (:banghead:)... I have a report that is created wit the following group: Group (A) Group (B) On Report Design is as follows: 1 =>Report Header 2 =>Page Header "Title Heading" "Group A Title Heading" 3 =>Group (A) Header [Group (A) Field]...

Thanks, that last one does it. I was not thinking as well as I should. I figure that if it was January and now()-1 equals to Zero, Access would not think to refer it to December of last year. I have to redo all my Access stuff to make special consideration on the 'year' change...ugh...

I get a #Func! error on my today report. What I am doing is that I am putting the last month name on the top of the report. Since we jump from 2012 to 2013, I have a feeling that it is the cause and the current 'formula' does not work. Is there a good way to allways put the last month on...

Pat - I know I can link to the table. But what is preventing me to do this is the table is updated many times throughout the day and I was told that if I link the Access to the sql table, it will cause the program to freeze/lockup because it will lock a record. We have over 30 people using...

I am hitting a brick wall. I don't do VBA, but I will if I have to. I need tips on using Access 2003 to import records from a SQL table on a server, but instead of straight import (over 300k of records), I want to be able to select records based on dates. For example, for current year. Thank...

jdraw - thank you for that tidbits. Yes my report (created through wizard) links to the query that I created that select fields from 2 tables (one with account number & business info [address & mail-to], the 2nd table account number and amount column) Where in the query do I put this IIF...

Here is my first time posting (no head rubbing please). I have an account list (local businesses) with their address of businesses. However, few of these businesses have a secondary address to mail bills to. I've created a table that contains regular address and Mail to address. In my...