Using Access auto tabulate

[theycallmewillie]

Hi everyone,

I need help with a work project I am having trouble completing. I have two Access tables, one is set to list information about students (student name, whether in-state vs out-state, campus, # of credit hours) the other list combines this information into a cost (ID one is for in-state, on campus, 1 credit hour/ ID two is out-state, on campus 1 credit hour. etc)

How can I run a report that will auto tabulate these two together?

My apologizes if this is hard to understand, I'm unfamiliar with access and not sure on a lot of the vuncular.

[ajetrumpet]

what does auto tabulate mean?

[theycallmewillie]

Sorry. English isn't my first or second language obviously, let me try to re-explain the issue. I think the question is actually a macro question and not a report...

I want to use Access to complete an auto-tabulation (auto fill in) for me and need help. I have a table with student information, I am trying to use the information gathered to auto fill their tuition for a semester. In order to do this, I need to pull information from three columns: RESD_DESC (in state, out of state, military waiver) CAMP_DESC (On campus/off campus) and LEVL_CODE (Undergraduate or Graduate)

How can I use access to auto complete the final column which I call TOTAL_COST? Is there a way to use a macro to tell it if it is on campus, in state and undergraduate tuition should be $100 and everything that matches that criteria it automatically puts $100 into the final column labeled TOTAL_COST?

[ajetrumpet]

you reference bound fields on a report by enclosing the field NAMES in [] braces. So, make a new control, and write this in the control source:

[field1]+[field2]+[field3]

or write whatever expression you want in it.

Does that make sense? Do not write the control names, write the actual field names, that come from the source table that the report is bound to.