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 Chriss Miller 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. bmoberly8888

    Format negative numbers in report

    As soon as I hit "send" - I thought of that - but it was too late, the question had already been sent. I have gotten help several times from Tek-Tips - and other times the answers maybe didn't work exactly - but put me on the right track to figure it out myself. I don't expect other people to...
  2. bmoberly8888

    Format negative numbers in report

    Thanks - that worked, and I'm sorry if it was a stupid question. I would have played around with it and might have figured it out - I had never messed around with formats that weren't already listed. What I don't understand is the attitude that you're doing other people's work for them - you...
  3. bmoberly8888

    Format negative numbers in report

    That worked - except now it's giving me both (-98.0) How do I get rid of the minus sign?
  4. bmoberly8888

    Format negative numbers in report

    I have a report that has a calculation that is showing negative numbers as -98. I would rather it use parentheses, (98), but can't figure out where to change how negatives display.
  5. bmoberly8888

    Totals from Report and SubReport

    I have a report that I have added a subreport to but need a grand total. The main report is fees and the the subreport is expenses. I need to have a total at the bottom that will include both. Originally I had this all in an append query -(and created a table) - which worked pretty well -...
  6. bmoberly8888

    Union Query - how to add prompts for fields

    Here is the SQL - thanks for your help. SELECT [WrkTmkpr], [CliCode], [MatNbr], [CliReportingName], [MatReportingName], [Date], [Hours], [Rate], [Amount], [Narrative] from [WORKED_TIME_BILLED_WITH_NARRATIVE] WHERE CliCode = [Enter Client Number] AND MatNbr = [Enter Matter Number] UNION ALL...
  7. bmoberly8888

    Union Query - how to add prompts for fields

    Do I need parentheses anywhere? I put in that code - but after I put in the client number and matter number I got an error that said ODBC - call failed. I'm not sure what's wrong. Thanks.
  8. bmoberly8888

    Union Query - how to add prompts for fields

    I have a union query for 2 queries - Billed Fees and Unbilled Fees. However I want to put a prompt in for a client number and one for a matter number. I'm sure I need to add WHERE... - but am not sure of the syntax. My fields are CliCode and MatNbr - and I want a prompt "Enter client number"...
  9. bmoberly8888

    Need to sum two fields from different tables

    I have two tables - cash and trust - I need to be able to add the cash amount to the trust amount to get one total. I also have a prompt for a date range so users can enter a date range and see their cash receipts. I keep getting an error when I try to run it. The Cash report runs fine on its...
  10. bmoberly8888

    email Access report

    Sorry,I don't understand what you mean. I know there's a lot of Access that I don't know about - I use Access a lot and create a lot of reports - but this is obviously something beyond what I've worked with and will need more information about how to do. Thanks.
  11. bmoberly8888

    email Access report

    I want to know if there is a way to distribute Access reports to individuals using their email address (or some other criteria). The whole report would have many timekeepers - but I want each timekeeper's report to go to him/her and not send all of the data. Also, if these reports could be...
  12. bmoberly8888

    I need to create a column based on the value in another field.

    That's great! - but I just found out I need 3 values - 82, 75 or 40 - so if it's B1 or E1 or T1 the value needs to be 82, and if it's B2 or B3 or E2 or E3 or T2 or T3, it needs to be 75, and if it's B6 or E6 or T6, it needs to be 40.
  13. bmoberly8888

    I need to create a column based on the value in another field.

    I have a field - PrsTypCode and the values of that field are B1,B2,B3,E1,E2,E3,T1,T2,T3. I want to create a field called "Cost" and if PrsTypCode = B1 or E1 or T1 - I want a value of 75, and if PrsTypeCode = B2 or B3 or E2 or E3 or T2 or T3, I want a value of 40.
  14. bmoberly8888

    Can you or how do you increase the size of a memo field?

    It is a memo field - but I don't know how to increase the size to more than 255 characters.
  15. bmoberly8888

    Can you or how do you increase the size of a memo field?

    We have time entries with narratives. I am writing a report and need the entire narrative - however if the narrative is longer than 255 - it just stops. Is there a way to increase the field so I can get the entire entry?
  16. bmoberly8888

    Format columns in Access Report

    I am wanting it to wrap to the next column within each Practice group - so if there are 3 practice groups on the page - each one might have 2 columns depending on the number of names. Like this: Appellate Group John Doe John Smith Mary Doe Mary Smith...
  17. bmoberly8888

    Format columns in Access Report

    Yes.
  18. bmoberly8888

    Format columns in Access Report

    Yes I have - but that formats all of the information - not just by each section.
  19. bmoberly8888

    Format columns in Access Report

    We have 21 Practice Groups with 6-30 people in each. I am trying to create a Report by Practice Group but I need to have 2 columns for names if there are more than 6-8. I need to have 2 columns (if necessary) for each Practice Group - not the entire list (if that makes sense). They also...
  20. bmoberly8888

    How do I write Aged queries for a specific "as of" date?

    Thanks for your help - that is exactly what I needed!

Part and Inventory Search

Back
Top