Search results

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

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

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:

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

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