Search results

Okay thanks man

We are running the report through a query so we can not change the fields on the report. When the absolute value is added to the query, it changes all the negatives to positives but does not keep the negative value.

I am making a financial statement. We need the expenses to hold a negative value and show up on the report as a positive number. Using the Absolute value function changes the number to a positive number without holding its negative value. Thanks

Hey Pals, I am trying to have a number that is negative hold its negative value but show as positive when it is displayed on a report. Any suggestions? Thanks!!

What did you change in the database? I am looking at it now and can not find what you changed. I understand that the subform is only showing the name related to the field, but where did you edit this field to do that.

That is what I am looking for. I wanted the subform to show the inputter how many customers they have. It is kind of hard to explain but this is what I am looking for. I do appreciate you time a lot Bill. Thank you!

Billmeye, thanks again. I can see you have a good understand of access. I am impressed. Ofcourse I have another issue, not sure if its possible but thanks. If you check out the assigning the reviewer form. I have added a subform of the table you created, which was exactly what I was...

Haha thanks again. I am actually working on it now and what you created got me almost there. Now the new table will show the following when transposed: ColName ColData Name Adam - Adam - Adam - Adam - Jon - Jon Customer xxx - yyy - zzz - aaa -...

Thanks Bill!!! Did not know you could do that. I really appreciate it. I am going to leave this thread open for a couple more days because I have some questions. Thanks again.

Thanks Bill. It seems like you did what I was looking for but I am not familiar with modules. I would like to create a button on a form with the module. How would I go about that? Thanks!!

Here you go. Thanks

No, in your example we would have 21 columns. Customer Name Bill Rate Reviewer 461 John 250 Carol 462 Mike 300 Bill 463 Jeff 450 Bob 464 Bill 100 Ben 465 Carl 235 Larry 466 Dan 90 Derek 467 Josh 100 Jon...

Hello everybody, I have been struggling with this for awhile now. I am trying to convert a table that looks like the following... Customer Name SumofSum of Bill Rate Reviewer 000462 John 500 Mike 000224...

Hi, I am looking to export a table to excel from access. I would like to order the transaction category column in a specific order(round trip air far, parking, lodging etc),. I have a button that runs a make query table and exports it to excel. I would like the rows to be in the order of...

Hi, I am looking to export a table to excel from access. I would like to add a column with a header of RefNumber and it will add one every row until the last row of data, starting at 1 (1,2,3,4 ect.) I have successfully added the title and have been able to find how to calculate getting the...