Recent content by Terri

I need to do a random selection of data. Can anyone help???

I need to pull the data after the @ symbol on email addresses. Example test@hotmail.com I want to pull only the hotmail.com. Any help would be appreciated. Thanks!

Looking at my data closer I have a problem. I use Access with an ODBC connection. The data comes accross backwards. So basically my sales come through as negative and discounts come through as a positive. Therefore my sum does not work correctly. HELP!!:confused:

I am trying to do a sales report. I have positive and negative numbers with the Abs the return is all positive numbers. How can I get it to return correctly?

Abs() before Sum() I know this is a basic question, but what does Abs before the sum function do? Also, I want to pull data from email addresses after the @ symbol. Can't quite figure out how to do this. Any help would be appreciated Thanks in advance!