Search results for query: *

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

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

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

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.

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

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

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.

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"...

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

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.

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

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.

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.

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

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?

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

Yes.

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

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

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