Search results

I am having the same issue. I have attached an image of the code with a breakpoint and it shows a date being stored. But when it is inserted into the table, it appears as 12/30/1899. I am not sure where to put the # signs. The date is entered into an unbound form, then moved to the table via...

Thank you Isskinit for your response. I agree that it may not be possible as I have been all over the internet regarding this. I did see one page where they talked about using visual basic to accomplish this. Anyway, the cell value represents a percentage of staffing. We consider it good to...

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

Thanks for the quick response. I tried your suggestion and unfortunately, it did not work. I thought it did not work because we have other rules as well and that the other rules were affecting it. I am attaching a sheet with some example data. The rules that we need are: a.) If the date in...

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

This worked, thank you so much. David V.

Thanks Mr. Larson, I have tried that as well, but still get the result above. I need to remove the time portion from the date/time field in the query. thanks

I guess that was not a good example of what I am getting. Here is a better example: RcdCreateDateTime #Of 8/26/2012 12:15:48 1 8/26/2012 12:18:28 1 8/26/2012 1:15:16 1 etc Thanks

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

Thank you both (pr2-eugin and Pat Hartmen). I tried both examples, DateValue and Format, and did not work. I tried entering these in the Default Value portion of the text box. The date I put in the ReceivedDateTime field did not populate. For Pat, the reason I have 2 fields is it is...

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

Oh, and I forgot to mention that the calculation cannot include weekends. That is why I use that fNetWorkdaysDecimal function that is on the database. Again, I do appreciate your help. Thanks David V.

Thanks CBrighton. This seems to work, however, I need the result to be in decimal form. This is returning whole days, when actually they only have it for partial. But I do appreciate the help and will try to make this work. Thanks

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

Perfect. I cannot believe it was that easy. I guess that is why I am a rookie and you are a pro. You are the best.

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