I am working on a data base for a construction company.  We have main
products (A,B,& C) which are made up by a group of assemblies (1,2,& 3) which
are made up of parts (X,Y,& Z).  Is there a way for me to make an Order Table
so that if we sell 3 units of product A, Access will ...

I've built a report in a horizontal format..when i'm going to print it it
goes in a vertical way, and sometimes, it depends, don't know about
what!?..when i see it..closing and restarting the database that contains
it;i'd like to know if it's possible (and how) to fix the output ...

I have a main table of suits and another table of
estimations. In the estimation table, I have paragraph
number and amount and of course the suitID - so it will
be related to the main table. I have 5 possible

I am developing a simple report from a table that may or
may not have data in various fields.  How can I prevent
the label and corresponding text field from showing up on
the report?  Thanks for your help

The situation:
I have created a query which is to be used as the basis
for an Access report.  The query has 3 parameters
(StartDate, EndDate and Type) that limit the data returned

Does anybody know of a tutorial on Access reports running
from novice to intermediate to advanced? Whether
downloadable off the net or available to buy in the shops?
Advice from this site is great but I need to learn more

What I am trying to do is take data from different tables and
write a letter.  For example, I have teh clients name, age, and address in
Table A.  Table B has information on there previous orders.  Table C has
information regarding orders from the sales department.  Table D has

An amount in my report shows a blank when the source is null.
I want to show a zero.  So I guess the quextion is ,,, what is the function
that would set an expression to zero if the source expression is zero but
would set the expression to the value of the source expression ...

I have one table and 3 join tables based on that first table.   I need to
have a report that pulls information from all 3 join tables but eliminates
the duplicates.  These are one to many tables.  I have tried the "Hide
Duplicates" property but does not help me any.  

I have a report bound to a query qryTest with field
tfTest. If I put a checkbox on the report bound to this
field I can use expressions such as:
if (me!tfTest) then.....

I have a service call database, and have created a report which shows the
calls for each site.
I want to report only on those sites which had multiple calls as I am trying
to review the number of repeat calls to solve the initial problem.

Is it possible to programatically save a certain image from a certain web
page?
I  want to automatically get a specific graphic from a specific web page
programatically so I can automate the task. I know I can NAVIGATE to the

Is it possible to have a text box shaped like a rectangle with a corner cut
out of it?  I have a field where the rectangle is just big enough for two
lines.  However, that includes the space for the field label.  If I position
the label over the text box, will that force the text ...

1) i hv to export few reports daily to a certain location on my company's
network.. can i set something to let access do it automatically itself?
2) i hv a report which contains fifty something pages, and i need to export
each page as 1 file (i.e. 5X files).. can access do like that ...

how do you create a report that displays a field in the detail section in
multiple columns.
ie 9 items
items 1 - 3 in column 1