ContributionsMost RecentMost LikesSolutionsRe: Report Filter Not WorkingThank you so much!! That helped. ------------------------------ Brandy Nunes ------------------------------ Report Filter Not WorkingI have a report that filters on specific fields, so that when the record is ready to go to the next phase of processing, it shows up on this report. I am having issues with records that don't meet the requirements, but are still showing up. Below is a screen shot of my filter. So if a record has a job number, is not 100% billed out, but is 100% complete and has contract terms of A. 100%, then it should appear on my report. However I have records that are 100% complete and 100% billed out showing up. Please help! Thank you, Brandy ------------------------------ Brandy Nunes ------------------------------ Count function helpHello, I currently have a text box to show the request number. I would like to make this automatic. How can I do this? Right now, each user has to look at the report which shows how many have been entered, and they have to fill in the next sequential number. Thanks for the help. Brandy ------------------------------ Brandy Nunes ------------------------------ Re: check a box after 24 hrsAwesome!! Thank you ------------------------------ Brandy Nunes ------------------------------ Re: check a box after 24 hrsI also tried the formula you provided and I get an error that says: "The operator '<' can't be applied on types datetime, date Does this mean I need to change my field type to just date? Thank you, Brandy ------------------------------ Brandy Nunes ------------------------------ Re: check a box after 24 hrsI do have two boxes, one for 24 hours and one for 48. is it possible to do something that says the following for one box: IF(Today()-1Day = [Sent to Sales], true) and the following for the 48 hrs IF(Today()-2Day = [Sent to Sales], true) ------------------------------ Brandy Nunes ------------------------------ Re: check a box after 24 hrsI want to use the check box as part of a formula for color coding. ------------------------------ Brandy Nunes ------------------------------ check a box after 24 hrsI have a box that I would like to have checked 24 hours after my date field "Sent to Sales" is filled. Can anyone help with this formula? Thank you, Brandy ------------------------------ Brandy Nunes ------------------------------ Error says Field cannot be UniqueI have a formula that I am getting an error on. The error says: This formula is incompatible with this field being marked unique. Please change the formula or uncheck the unique checkbox. This is my formula [Invoice #]&" - "&[Subcontractor/Supplier] I am combining two fields so that I can require the field to be unique. What am I missing? Thank you, Brandy ------------------------------ Brandy Nunes ------------------------------ Re: Anniversary Date FormulaHow do I show the next anniversary date once the anniversary date has passed? Current formula: var date HireDate=[Hire Date]; Date(Year(Today()),Month($HireDate),Day($HireDate)) ------------------------------ Brandy Nunes ------------------------------