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!

Register Log in
  • Congratulations Rhinorhino 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: *

  • Users: sandora
  • Content: Threads
  • Order by date
  1. sandora

    Group record selection

    Crystal Ver 11, access DB - I hate to even ask this because I know it's my own stupidity. I have a report that is fairly simple. There are no formulas, only one group: vehicle_hitch, and a very simple selection statement: {00_Veh_Inventory.Current Veh Loc} = "4" and not...
  2. sandora

    MultiTable Group?

    V11, Access DB Is there a way to include 2 tables in 1 group. For instance I have two employees who split one deal and I need for both of them to appear in the group.
  3. sandora

    Splitting details between groups

    V11,AccessDB This is an example of what my report looks like now. GH1-Salesperson1-Mikey GH2-TrailerType-LQ Detail-Deal# Gross Commissions GH1-Salesperson1-Howard GH2-TrailerType-LQ Detail-Deal# Gross Commissions I have this report built and it works great, but now they've discovered that...
  4. sandora

    DB Linking Problem, maybe??

    V11,AccessDB This is an example of what my report looks like now. GH1-Salesperson1-Mikey GH2-TrailerType-LQ Detail-Deal# Gross Commissions GH1-Salesperson1-Howard GH2-TrailerType-LQ Detail-Deal# Gross Commissions I have this report built and it works great, but now they've discovered that...
  5. sandora

    split results

    V11,AccessDB This is an example of what my report looks like now. GH1-Salesperson1-Mikey GH2-TrailerType-LQ Detail-Deal# Gross Commissions GH1-Salesperson1-Howard GH2-TrailerType-LQ Detail-Deal# Gross Commissions I have this report built and it works great, but now they've discovered that...
  6. sandora

    Date Parameters in Report Titles

    Ver11, AccessDB. I have a parameter called {?DateRange} which returns the beginning date of the report, which always falls on the first of a month and the ending day of the report which always falls on the first of a month. But this is for accountants and they want the title to say something...
  7. sandora

    Totals of some sums????

    Ver 11, Access DB - Making a Balance Sheet. Here is what I have: (GH1) Assets (GF2) Cash 644,807 AR 573,803 Etc... (GF1) Total 21,161,638 (GH1) Liabilities (GF2)...
  8. sandora

    Freeform report formulas

    v11, accessdb. Not sure if this is the correct forum for this one. I'm building a Balance Sheet. I've summed each of the account catagories with a db query. For instance: cash 1231 sum of debits and credits 1234 sum of debits and credits Fixed assets 2234 sum of debits and credits 2335 sum...
  9. sandora

    field explorer dialog box

    In version 11, somehow I've gotten my field explorer dialog box out of position on the right and when I try to put it back it either goes all the way across the page or just sits on top of my report. I've looked it up in the help, but it's not much. Anybody?
  10. sandora

    not conditional

    CRV11, Access DB I have an income statement with groups for Revenues, COS, etc. I have the account numbers summaried and the groups summaried and a grand total. I now need to divide the COS summary total by the revenue total for a percentage. I can get Revenues to work with the following...
  11. sandora

    IF formula syntax help

    Ver XI, AccessDB This is what I have, but I don't know what the correct syntax would be to get it to work. These are trailer types and are defined in a formula 'trailer types' F,UF,LQ,UL = 500 NL,UN = 200 C,UC <2000 = 25 >=2000 and <6000 = 50 >=6000 = 100 I was thinking if, then...
  12. sandora

    Totaling SubReports

    I have 4 subreports in one main report. The subs are summaries for different companies and contain totals for each. I need to total all of the subs for a grand total. Can this be done and if so, how?
  13. sandora

    Copying report format

    Is there an efficient way to copy reports that have the same format but use different access databases? For instance I have a detail report that uses 2 different tables in one company's database, I have another company who needs the same report out of their database. I've tried removing the...
  14. sandora

    Group displays

    V11, accessDB, I'll try to make this clear, because it's confusing to me. I've built a report that will be a summary report. I've grouped and summarized by trailer type (GP2)and by salesperson (GP1). All looks well except that now they want to see a breakout of a particular trailer type by...
  15. sandora

    suppress part of string

    V11 - AccessDB - The value returning is a variable length string, it is, for instance 4444-01 or 44444*01. I want to suppress everything from and including the - or * to the right. Any suggestions?
  16. sandora

    Text to Number?

    V9, from AccessDB - The accessDB is fed by another program, not easily customized. The field that I want to use as a number is a text field assigned by the program meaning I cannot change the field type in the database. In my report I keep getting the 'string is non-numeric' error. I have tried...
  17. sandora

    Summary/Group formula

    I am writing a report that is an income statement. I have the account descriptions, account numbers and totals but I need to subtotal by account number where the account number is between x and x. The account numbers are a 7 character string. I can't figure out how to group them or summarize...

Part and Inventory Search

Back
Top