Recent content by jweeda

Im working with Legals (Townships, Ranges, Sections and quarter sections). In my data base I have each individual 1/4 section in a field. for example: column a = T12N column b = R42W column c = 05 column d = NW the next field is this a = T12N b = R42W c = 05 d = NE What I want on my report...

Oh...sorry, Im a newb when it comes to this so I didn't understand that!!

Ok, I added that box and I put a label on it so it looks like this: Total: =Sum([MaxOfCharges]) Now, when I view the report, it shows the Total: on the bottom of the pages like it should (except its on all pages) and then on the last page it shows: Total: #Error I do have it set to do a...

Hmmm. I have 5 pages of accounts that show there charges for the year. I a total of all the accounts charges at the end of my report. How would I do this? Thanks! Jim

I need to print a report but I need to do it in a specific way that I have NO idea how to get. I have 4 columns with the data in them. Column A needs to be sorted in ascending order. Column B needs sorted in ascending order after Column A. Column C needs sorted in ascending order after Column...

HAHA OOPS!!!! :confused: :D I was messing around in the query and found out what you meant by the grouping! All I did was insert the ACCOUNT, the PERIOD (i guess this was the date), and the UNITS and I grouped by the ACCOUNT, set the PERIOD to Last, and did a Sum on the UNITS. It actually...

How would I do the grouping? Is there quick method to do that? My customers are listed by account number. Is there a way to sum up the totals by taking all the values for the account numbers? Just wondering because I don't actually have dates listed. I just had billing send me the usage for...

Howdy... Ok...heres from a total n00b!!! I work for a Rural Electric Company and I need to build a report that adds 12 months of usage for 1 customer and puts it in a column on the report. There are about 150 customers and I want to show only the TOTAL usage next to the account number and not...

LOL Told you I was a total n00b! :D Thank you SO much for your help and your patience! I wish I could return the favor by helping someone else but I won't even begin to think that Im qualified! But kudos to this forum and to you Fofa! Thanks again! Jim

I think Im missing something! I go to the queries section, pick a new query, go to design mode and add my table. I go up to the query button on top and change it to an update query. Then I drage my ACCOUNT column down to the "table" below and where it says Update to:, I put this in, SET...

Oh...would the fact that this is text have anything to do with that? I set the values to text instead numbers because of the leading zeroes!

Ok...I tried that but it set everything to just 0. *sigh...I wish I weren't a noob at this!:(

My apologies! I imported this data into a table and I want to update the whole column in that table.

Well, it looks like we're getting somewhere! Only when I said I was new to Access, I really meant it! Where would I enter that string? Thanks!! Jim

Hi...im new to these boards and new to MS Access so Howdy ya'll. Ok, I'll try to explain this as plain as possible. Our billing system creates customer account numbers with seven digits (i.e. 0001500) The last two digits indicate how many times the account is deactivated and reactivated. So...