Search results

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...

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...