Here is what I want to accomplish:
I have a button that imports data from an Excel spreadsheet. This spreadsheet is updated by numerous users from different locations. I want to be able to import the data from the spreadsheet into Access and then delete the data (keeping the column headers)...
Thanks Joe, but this doen't solved the problem. Here is what my Crosstab query looks like:
Field Table Total Crosstab Criteria
Contractor Inspect Group by Row Heading
Technician Inspect Group by...
I have a report that is generated from a Crosstab Query. One of the fields (Category) in my table can contain values of: A,B,C,D,E or blank.
My report Looks something like this:
Contractor # of # with #of #of #of #of #of
Technician Inspects 0...
Get Parameter Into a Report for Calculation
From: John H
Category: OTHER
Date: 27 Jun 2001
Comments
I have a Report created from a Crosstab Query. What I need to do is add a field in one of my sectiion footers to calculate a
value.
Example: =[Number of Faults]*15/[Sum Of Total...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.