Search results

I have a spreadsheet with almost 4000 rows and 200 cells which need to have their value changed to "0" if the adjacent cell has an "X" in it. John 50 active John 50 closed X Sue 40 active Mike 80 closed Bill 52 active Bill 52 closed X If the row has an "X", I need to change...

I need to lookup a value on a spreadsheet that contains merged cells. I have the following information: Row number 2 contains the date which is in a merged cell over 2 columns. The other data is on rows 47 & 48 which does not contain any merged cells. I have a table that needs to populate the...

I have a list of names and the same name may apprear multiple times. John Bill Bill John Jack John Jack Bill The names in the list are different each day. I need to sort this list and then color code each name. The color for John does not have to be green everyday, I just need every instance...

Can some please advise how I can lock an access 2007 database so that a user cannot get into the tables,queries and certain menu items. In access 97we could disable several options on startup. It seems you can disable some stuff on startup but the option to allow access can be changed by...

Is there anyway to tell who is linked to your database and what tables they are linking to?

Is there an easy way to find out which queries are linked to a specific table? I have a database that has approximatly 1100 queries and need to know if a certain table is actually being used but I don't want to go through each query. Thanks.

I am using Access 97 and I cannot compact as it shows people are in the database. Is there any way to force users out of the database? Thanks.

I'm using a database which currently gets updated nightly by our overnight staff if they don't forget. Is there a way to have this run automatically? When the form opens there is an update button which needs to be clicked in order for a certain class module to run. This runs approximately 25...

An employee that created a database left our company and now I have the fun of maintaining it. I have noticed that there are several table that were created which are not linked to another database but have lots of information which will need to be updated manually. This information could have...

I'm new to working with databases and now I have 2 which I have to manage. There are probably anywhere from 10 to 30 people using these databases at any time and I would like to have a list of the active users. What's the easiest way to create a report of the active users?

Is it possible to create a formula with more than 7 If Statements in Excel? If not, what are my options? Thanks,

I'm trying to convert times to report how certain Employees are doing on their key performaces. How can I subtract 13:00 - 14:00 = -1hr, when doing this all I get is ######? I need to have a value as an answer instead of ######. Thanks,

Is there a way to convert a time, 12:30 AST, using a formula so that it would show 11:30 EST? Need to run several reports and need to look at several different timezone according to when information was received. Any help would be greatly appreciated....:) Thanks, Scott

I am currently running a query which shows a date and time for several products: Product 1 Product 2 Product 3 Product 4 01/01/07 12:00 01/01/07 15:25 01/01/07 15:25 01/01/07 17:36 From this information I need to count each Product unless the...

I'm trying to run a query with an expression so that the number of occurances with a date time field are counted but I keep getting an aggregate values error. Prod 1 Prod 2 Prod 3 Prod 4 Count Feb 1 12:01 Feb 1 13:56...

I'm trying to write a query to figure out the time something was delivered. I have the following information to work with: Estimated arrival time: 13:00 Loaded Time : 14:00 Trip Time : 2.5hr - - how do I conver this to Hr's & Min.? I need to subtract the ETA...

I'm trying to run a query that has a 3 expressions within the query. I'm using the following: Exp2-Exp1 this would be the results for Exp3. The problem I am having is that I only need the results for Exp3 to be returned if they equal "0". Any help would be appreciated.....Thanks

I need to know if there is any way to password protect a single query. I currently have a database and there are several users that have access to run queries but I need to have some security as others are making modifications to queries that they shouldn't be.

How do I run a query so that I do not have to keep changing the date. I want to run a query everyday but want to use the date from the day before. I want to use yesterdays date for today and then todays date tomorrow. Thanks.

I am running a query which returns daily sales numbers a also calculates a percentage increase. The query works fine until I try entering criteria to give any percentages that are >150 or <50, when running this no results are returned. Any help on this would be greatly appreciated. Thanks.