Using XL type stuff in Access???

[cal lee]

I work for a structural steel fabricator. We estimate jobs and their cost, then provide our "number" to the general contractor. If our "number" was what they were looking for, then we are awarded the job. (History for question)

I have a DB that keeps track of all my job info (e.g. cost, hrs, etc...). I have to track of said info weekly and turn in a report to the CFO providing est cots, est hrs, act cost, act hrs, and then the percentage of each based upon est vs cost (have I lost anyone yet?). Anyway, I have this worked our in XL, but I have to find the data in the DB, then put it into XL, then XL computes what I need.

My question is this: Is there anyway to extract the data from Access into a rpt form and have the calculations done automatically?

Thanks for the help,
Cal

 

[mdmilner]

Absolutely yes, but it's going to look a bit different from the Excel technique. You should take a look at queries. Queries allow you to create calculated fields which can be mathematical formulas, or concatenation which would be grabbing portions of multiple fields to stuff together into a single field.

And the really awesome thing is, anything you can do with a table, you can do with a query.

Mike

 

[Andrew Fergus]

I agree with Mike 100% - provided the data is there then you can do any (well almost any) Excel calculation in Access. You can even calculate the percentage complete on the report itself rather than through a query. If you post a description of your table (the field names etc) and if you could elaborate on the report layout, then someone here will help you create the report using Access.

Andrew.