Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. micereza

    Microsoft Excel Multiple Filters with Multiple Subtotals

    Thanks, figured out the problem with a fellow co-worker.
  2. micereza

    Microsoft Excel Multiple Filters with Multiple Subtotals

    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...
  3. micereza

    Can I increase the number of viewable pages on a report?

    The question you asked prompted me to take a look at the query. The joins were all wrong that's why only five records were being returned! :~/ Thanks!
  4. micereza

    Can I increase the number of viewable pages on a report?

    The report is based on a query that returns 5 records. I'm not too sure why it is only returning the 5.
  5. micereza

    Can I increase the number of viewable pages on a report?

    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...
  6. micereza

    Powerpoint - Merge 4 Presentations into 1

    TJ, Thanks for the info on the PPT inquiry. It was exactly what I needed to complete the project.
  7. micereza

    Powerpoint - Merge 4 Presentations into 1

    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?
  8. micereza

    Cross Tab query question

    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).
  9. micereza

    ACCESS - Non Functioning List Box

    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...
  10. micereza

    ACCESS - Non Functioning List Box

    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...
  11. micereza

    Why does this statement produce an indented line?

    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]) &...
  12. micereza

    How do I create a list?

    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...
  13. micereza

    How do I format one specific field in a large expression?

    Bob, Thanks for the prompt response. I'll test it out and get back to you. Take care MC
  14. micereza

    How do I format one specific field in a large expression?

    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] = &quot...

Part and Inventory Search

Back
Top