Help with issues

[Trisha_70]

I have a table with all client data including 1st units, 2nd units, and total
units. This is used for billing. I have a form set up so I can input client
hours which takes info from a billing query. We do billing 2 times a month
hence 1st units and 2nd units. I am trying to get the total units to add
together and print out in a report. My control source for total units is
=([1st units]+[2nd Units]), this adds the two together however it doesn't
place the units in my total units and will not print. Can anyone please help
me with this.

 

[Fred]

Let's split this into the two problems that you described:

"Doesn't place the units in my total units". What do you mean by "place
into".....if you mean the equation in your report isn't placing the result
into your table, that's not a problem, it's correct behavior. Reports print
out informaiotn, they aren't supposed to load information into your table.

BTW for 99% of applications "total units" should be just calculated when
it's needed, and not stored in the table.

"will not print" What are you getting; a blank, and error message? What
is the NAME (name property, not "control source" property) of the control
("box") with that equation. If it's "1st Units" or "2nd Units" (which would
be the default if you created it by dragging one of these down from the field
list) that that is your problem. (a mistake that I have mad many times"
You have to change the NAME (not control source) to something else.

 

[Trisha_70]

Hello thanks for the response
The name is total units, In forms the 1st and 2nd units are calculated but
it doesn't print in my form. I assumed since the other amounts go into the
table when I put them into the form that the total units would also but this
is not happening and this is what I need. When I print the report unless I go
in and changed the total column in my query I get the same numbers from the
last month because I input the calculated total instead of Access doing it
for me. I am not very familiar with access this is something my boss just
wants me to get figured out. Thank you for the help I am beginning to think
this is hopeless and can't be done.

Let's split this into the two problems that you described:

"Doesn't place the units in my total units". What do you mean by "place
into".....if you mean the equation in your report isn't placing the result
into your table, that's not a problem, it's correct behavior. Reports print
out informaiotn, they aren't supposed to load information into your table.

BTW for 99% of applications "total units" should be just calculated when
it's needed, and not stored in the table.

"will not print" What are you getting; a blank, and error message? What
is the NAME (name property, not "control source" property) of the control
("box") with that equation. If it's "1st Units" or "2nd Units" (which would
be the default if you created it by dragging one of these down from the field
list) that that is your problem. (a mistake that I have mad many times"
You have to change the NAME (not control source) to something else.

I have a table with all client data including 1st units, 2nd units, and total
units. This is used for billing. I have a form set up so I can input client
hours which takes info from a billing query. We do billing 2 times a month
hence 1st units and 2nd units. I am trying to get the total units to add
together and print out in a report. My control source for total units is
=([1st units]+[2nd Units]), this adds the two together however it doesn't
place the units in my total units and will not print. Can anyone please help
me with this.

 

[Fred]

Hello Trisha,

As you said, you are new with Access, and your posts indicate a lot of
confusion on the fundamentals. It also is making it difficult for you
write posts which select and include and clearly communicate the informaiton
which is important for someone to be able to help you. This would include
the nature and structure of your tables, or of the information that you are
trying to database.

If you really want to do this right, allow yourself some time. Describe
the nature / structure of the information that you are databasing in the
Access database design forum, and get help on a good table structure (or
confirm that yours is good.) At this/that stage, don't even use the words
"form", Query" or "printout" or "report" Once you have that necessary
foundation in place, you'll be in good shape to get where you need to go.


I suspect that you would need a few hours of help there and then, after
that, your specific question/ issues could be done and solved in one minute.

Sincerley,

Fred