Is there a way to filter multiple columns along with multiple subtotals. Subtotal function only allows for filtering one column with multiple subtotals.
Columns I want to filter are:
User Name
Member Type
Columns I want to subtotal are:
Quantity
Quantity %
Total $
Total $ %
To create one...
I have a physician summary report. It is supposed to print out a summary of info for each practice in the database (90+) and the page length varies per practice.
For some reason, I am only able to view/print 15 pages (5 practices). Is there a way to correct this so that I can view data for...
Hi People,
Is there any way to easily merge multiple powerpoint presentations with different backgrounds and formats into one document without loosing the formatting of each individual presentation?
I'd like to essentially have 4 presentations in one. Is that even possible?
BenTitus,
We are having the same problem that you had... How did you enter Between [Start Date] and [End Date] as a parameter in your crosstab?
Note: We are intermediate Access users (no speak SQL).
Here's the run-down... I have two tables, TABLE1 and TABLE2. I have two fields name1 and name2 in TABLE2 that are list boxes drawing information from TABLE1.
The problem, the name2 field keeps drawing information from the column for the name1 field. I have changed the bound column setting to...
Here's the run-down... I have two tables, TABLE1 and TABLE2. I have two fields name1 and name2 in TABLE2 that are list boxes drawing information from TABLE1.
The problem, the name2 field keeps drawing information from the column for the name1 field. I have changed the bound column setting to...
I've created a statement in my report that pulls from multiple fields and removes unecessary spaces. Example:
=IIf(IsNull([English Speaking]),""," " & [English Speaking]) & IIf(IsNull([Spanish Speaking]),""," " & [Spanish Speaking]) &...
I would like to create report that creates an index that pulls from two different fields in one table. For example:
(Topic) (Page Numbers where the topic can be found)
Housing 1,34,56,77,79,90
Currently the report allows me to do this:
Housing 1
Housing 34
Housing 56...
Help I've got a huge problem that I've been trying to figure out for weeks.
Let's say I have an expression like this in my report:
IIf(IsNull([AddressLine1] Or [AddressLine1] = " "), "", [AddressLine1] & vbCrLf) & IIf(IsNull([AddressLine2] Or [AddressLine2] = "...
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.