Recent content by nonrev1

truncation I thought it was being truncated due to Excel's character limitation but I'm not sure. There are not thousands.... maybe a hundred or 2 at the most.

I have a report that I have grouped by [AccountHome] . Some accounts are single but some "AccountHomes" include several branch accounts. In my Group footer I have written an expression to give me total sales for each group. It has hundreds of pages. I would now like for it to sort the whole...

Thanks so much! That did it. I was on the right track... just to many () and not enough ""

I have a table with several thousand accounts. They include some national accounts that have many branches. Each national account has an account number called [Natl Home]. Each branch has a separate branch account number called [branch]. Each record also has [Account Name] but it is the name of...

I have a table with id numbers [id] by account. The table also has a field for the [date] and [time] that represents when the information was entered. I would like to build a query that will display only the most recent entries - so where [id] is duped show only the most current record based on...

THANKS! We got it to work. I am sure the information that we gave was probably not complete enough but by your replies compared with some other expressions we did we came up with this: (>=[Forms]![Switchboard Criteria Form]![blue_min] Or ([Forms]![Switchboard Criteria Form]![blue_min]) Is...

Pat, Thank you for you assistance... I think we are on right track, however, we can't seem to make it work. We are confused by the "Yourfld" part of the expression? (YourFld >= FormFldMin OR IsNull(FormFldMin)) AND (YourFld <= FormFldMax OR IsNull(FormFldMax))

Hi John K, Thanks for your reply. There are two fields blue_max and blue_min. It is currently working if both fields are given a value. If either field is left blank, we get error messages. We would like it to work if one of the fields is given a value and the other is left blank. So if...

Using the below expression a user can retrieve revenue values typed in the blue_min and blue_max fields. >=[Forms]![Switchboard Criteria Form]![blue_min] And <=[Forms]![Switchboard Criteria Form]![blue_max] However, in this case the users wants all values equal to/greater than $100,000 or...

My report is already producing a column [Lvl] that is displaying level 1, 2, and 3 accounts. I made it count all of them but what expression can I use to specify a count of only level 1 accounts? I've tried a hundred different ways :confused:

Thanks antomak! Number 2 worked like a charm. It just took me a few minutes to realize Format had to be capitalized. I am brand new with these expressions.

I have several thousand records already in a table. Each record should be identified by an 8 digit number but many began with a zero which was dropped so that those now show as a 7 digit number. Can I do an update query that will add a beginning 0 to all of the numbers that are 7 digits? If so...

I have 8 digit account numbers. I receive my data from another department in Excel which has dropped the 0 from many of these account numbers that begin with a 0. I know that changing the data property to text will prevent this in Access but since the 0 had already dropped prior to import into...

Hurray! Thanks so much! That worked. At first glance it looked like it was missing an argument. By placing the 2 at the end is it displaying 2 for everything else not covered in the first 2 arguments? Can you recommend a good source for learning these operators with good explanations and...

Hi, I am just starting in Access. My [Territory Code] field consists of a code with 3 alpha characters(first) and 3 numeric characters(last). I would like a new calculated field to display a 1 when the 3 numeric characters are greater than 899. I would like it to display a 2 when the numbers...