Search results for query: *

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

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

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

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.

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?

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

I have some aged time queries for current, 30-60 days, 60-90 days, 90-120 days and over 120 days. I am currently using Between Date() and Date()-30, Between Date()- 31 and Date()-60, etc. However, we would like to run the reports with as "as of" date - for March 31, or whatever month we are...

We have client numbers and matter numbers. I need a list of only the client numbers that have more than one matter number.