Search results

Is it possible to replace a cell value with text using conditional formatting. For example, a cell has a value of 94.75%. I would like to create a conditional format that will replace the value of 94.75% with the word "Green" if the value in that cell is Less than 101 and greater than 94.00. If...

Trying to create a conditional format that will change cell color when the date in the cell is greater than today and less then 7 days from today And the word "yes" does not appear in D2. For example date in cell B2 = 2/6/2014, and today was 2/5, and D2 is blank the cell would be orange. Here...

Please help, I have wondered this forum and the internet for help with no success. I have a button on a access database form that runs a query and exports the data to an excel sheet that remains open. I am ok with this. What I would like to do now is format the sheet and then save it as a file...

I hope this is the correct forum for this. I have an access database that is used to store records of requests for for items. Example, ID, WhoRequested, CustomerName, Date, address, phone, WhatRequested, amt. I take this data and export it to an excel spreadsheet and send to another area for...

Is it possible to create a conditional format that will change if the cell is updated after the original date the sheet was created. For example, this is for a employee schedule. There are codes for each shift and what happens is that associates trade with one another. I need to be able to...

I am having a problem with datepart or format functions. I have a table that only has one column that houses date/time data. I want to pull data using this column, but I only want the date portion. I dont want the time. For example, I am using this query: SELECT...

I have a database with a form where someone will be entering the received date and the received date and time. This is necessary to simplify the reporting as they wanted a Turn Around Time by Weekending Date. So I use the received date to determine the weekending date and the received date and...

I have a very large report that I am trying to create, but having issues with formatting it the way I want. I am able to format the report by Weekending date like this: Weekending Reason1count Reason1amt Reason2count Reason2amt In this report, I have 20 reasons which means the...

I have a database that keeps track of the number of days an inquery is with an employee. I use a function called fNetWorkdaysDecimal that counts the number of days between 2 dates. This has been working great. Unfortunately, the dept now has a research team that will take an inquirey from an...

I am trying to write a query that will sum an item with 2 criterias. I have a database that has a table called tblIssues with columns that have IssueType and FBCS. IssueType is a combo box with 3 choices, 1=true Pres, 2= Verbal, 3= CRL. The FBCS column is a Yes/No box. I need to sum the...

I have read several threads related to this problem and have tried them all. From DateValue to CDate, to others. None have worked. I need to create a query that will count the number of items that meet certain criteria. This is what I currently have: SELECT Count(*) AS [#Closed Debt...

I have a table of data that has a column that uses Date/Time of when received. This table is in a SQL database. I have linked the table to an access database so an associate without sql skills can pull reports. Problem is the form to pull the report requires to enter the begin date and time...

I have asked for help in the NullToZero function before, but for some reason I cannot apply what I have learned to a new situation. I need to create a report that will show records for weekending date even if there were no records recorded for a week or 2. I have attached a copy of the sample...

I have a main report that shows an associates peices per hour worked (PPH). The associate is rated based on a scale that is determined by the departments average PPH. I have created the scale as a subreport on the main report. Example of scale= Associate receives a rating of 3 if their pph is...

I have a report with 4 columns that contain dates. I need to write an iif statement that will return the oldest date of the 4 clumns. I have tried =Min(expression), but this only allows 1 argument. I have 4 arguments. The column headers are TruePresOldestDate, BBBOldestDate, VerbalOldestDate...

I am trying to write a query that will provide the oldest date by weekending Date. I have a report that goes out weekly that lists the #received, #Completed, #Pending, and oldest date. If I only do one week, it is easy. But once I add the 2nd, 3rd, and 4th week, it becomes difficult. Attached is...

I am having trouble suming the results of a query. I have a query that determines the # of Workdays between 2 dates and is returned as days, hours, minutes. I need to sum these to get total and then divide by the number of issues to determine an average Turn around Time. Her is what i have so...

Help, I am having nightmares about this report. It is called a Standing Report and a sample that we are currently using in excel is attached. I need to try and build this report in access. I have the queries built that will pull the data, but the report will only show 1 week at a time and I...

OK, I have a form that is created form a query to pull data on an associate. Currently, when you click on the form, you have to enter the associates last name to pull the data. Instead of typing in the last name, I want a dropdown box so all the auditor has to do is click on the name of the...

I am having trouble creating a form that will updatee several queries at the same time. Does anyone have any suggestions on how to do this? On one form I will need to enter a start date and an end date and on another form, the start date and end date will be the same day. ANy help is greatly...