Recent content by daclown81

It worked!!! Thanks a million guys

No it doesn't work........ It's like if you make a query and you have a coulumn with several numbers.....I want to total those numbers in that column and have them show up on my report. Now I've found that I can make a query of that query and use the Sum and that gives me the total of the...

I've made a query and I've got a field called AMOUNT that gives several dollar amounts for the records I've looked up in the query. Now how can I add all those Amounts up (those from the query) and get Sum that equals the Total Amount for the records I have in the query? I'm trying to put a...

No, I've tried putting it in the footer, but I keep getting an error, or it just gives the last number from the query

I created a query to get results from 2 tables. One of the results I got was a numerical amount figure. Now in my report I can get all of the amounts from the query to show up in the details. How do add all those amounts and get a grand total in the report. Every time I try using SUM(Amount)...

Need to know where i can get some code to search my database and be able to give me records for 1 company between 2 dates: Ex: search by company between mm-dd-yy and mm-dd-yy Thanks

I don't really know much VB code. I need to find a way to create a form that will search my tables and give only specific info. For example: Service Records Table I need to know how to search for Service records from a specific Company between 2 dates and receive only the info from that...