My 1st table consists of Acct # and Names.  The 2nd table has the deposits
and charges entered. Each account has a beginning balance, but I am not sure
which table to enter that in.  I want a report that lists Accounts and their
transactions per dates I enter and will list the ...

I am liking to a SQL table that is has the following data.
id    name  period   stdvalue    extvalue    bilvalue   colvalue
22    test1    1104    100           150          125         100
22    test1    1204     20             50             75           75

I have created a report that groups multiple fields and displays in a tabular
format.  I have also inserted a horizontal line within the grouped fields
footer to clearly separate these groups.  The report currently shows two
lines where one group ends and the next begins (see ...

Can you copy a calculated field from one report to another?

I have a report that has a segment called Order header.  The footer does not
appear for the header and I can not figure out how to make it appear.  
Thanks for your time.

Wihtout using grouping or forcing a new page or the page break control in
report design mode, how do you force a new page in the vb editor?  Depending
on certain conditions, I want the code in the report to insert or start on a
new page right then and there.  The closest thing I ...

Can anybody help me on how to fix the reports page margins and paper size?
Cause everytime I change printers or modify the program in another computer
the page margins goes back to its default printer margins. So as the paper
size.

I would like a parameter pop-up to appear when a particular report is run.  
How do I do that?
For example, I have a report based on a crosstab query.  I want the report
to only show the results from the query for a selected date.  I want the date

How do I copy a calculated field from one report to another report?  Thanks.

I previously posted this but thought it would be better to start a new
thread. I'm trying to get my criteria to ascend straight:
Here are the two tables and pertinent fields I need to report:
tblFinishedGoods

I am running a report from a criteria form thus
docmd.openreport Name,Preview,,Criteria
the report appears twice on screen and in the windows menu.
Help please!

I have a report based on a query (which has several criteria in it).
Is there a way for me to create a label on the top of this report,
indicating what the data actually is
vs the report name?

Day 2, and I am looking for a tip or two. I have a ODBC link with a VFP
table. There is a Date/Time field that will show either 12/30/1899 as a
date, or 12:00:00 AM if not a date. I tried conditional formatting, Also
IIF([adate]=#12/30/1899#, "TEXT",[adate]) i get #ERROR. I would ...

I am currently using a text box with
Control Source =1
Runing Sum Over Group
I did this to create a count for the report, and it works great until the

I have a large data sheet with mulitible entrys with the same id#
i have hidden out the repeats on a report, however the rows show blank
i dont want them to show at all, so with all the blank rows my report is
like 27 pages,, but if i can get the blank rows out of the report it ...