Search results

I have a worksheet with a range of A1 to D501, with row one locked. Column B (a named range "Need") contains Option Buttons. I reread this and decided there may be some important information: Columns B and C contains Grouped Option Buttons by row! After clicking the Option Button on the...

Elegant! I think one could change the array to accommodate fiscal years that are not January - December.

Well, there is something wrong! For some strange reason, when the If calculates to March, it shows an end date of 3/28. Really odd. I think there was another month that did not calculate correctly, I think it was July, showing as 7/30, but that seems like ages ago. Because I probably need to...

Thank you both for your input!! I was having my midnight snack when it dawned on me why theDBGuy's plan was not working. It sounded to me like the correct answer. The If statement should have done what I wanted. I realized that the If was being confused (It always added a year, no matter...

Oops! I had put them in Lost Focus. I have changed focus. Nothing.

I put the following in the After Update of both the "First day..." and "Interval" unbound text boxes: =IIf([balance_interval]="Mo",[last_day_of_interval]=DateAdd("m",1,[first_day_of_interval]), IIf([balance_interval]="Qtr",[last_day_of_interval]=DateAdd("q",1,[first_day_of_interval])...

On this form, I would expect the user to enter a date in the "First day..." and choose month, quarter, or year. I would like to show the resultant "Last day..." on this form AND on another form along with a text "is the last day of the "& Interval. I am thinking I need a Case attached to...

Another simple solution would be to short-cycle: call a month 4 weeks; semi-annual, 26 weeks; quarterly, 12 weeks, etc. Adding 4 weeks to an item that is serviced on Monday, will be due on Monday.

In my experience, if an item actually (critically) needs an inspection or service on a given date, extending the date is not an option. If the inspection is due Saturday, the inspection needs to be done before Saturday, to use the item on Monday. Surely you use this information entered in the...

Pat, The original post states they are using name as an entity, not first, middle, last. From Golo: "I have a table with 3 fields: Customer ID (Primary Key and Autonumber), Customer Name and Customer DOB." I am not working on making a genealogy database, it was an example about the ambiguity...

I would suggest you need more data (Probably from a different table.) to make (Allow the user to make) this decision. I have been doing quite a bit of genealogy recently, and can tell you there are people with the same name and dob. Display customer addresses for the name you have entered...

Thank you. I could have used that advice earlier! I had a couple other fields sorted in the query earlier, and the report was really whacked then. I had a birthday from January, followed by an anniversary in September, and on and on. Did not seem to be to have any sort order whatsoever.

I think it would be good to know why this works the way it does, but it now works correctly. I made a display_month in my underlying query with MonthName function, and put that field in my Group Header section to replace sort_month field that I had before. Thank you, Minty and CJ_London for...

I have the Format for sort_month as "mmmm" for the Report, for display purposes. It is numeric in the table and the query. I changed it to "m" to try your suggestion. The results were: 12, 1, 1, 1, etc. to the end of the report. In case you read this and assume I have sort_month in the...

SELECT Contacts.birth_anniversary, DatePart('m',[birth_anniversary]) AS sort_month, Contacts.last_name, Contacts.family_id, Contacts.ID, Contacts.first_name, Contacts.email, Contacts.job_title, Contacts.phone_one, Contacts.phone_two, Contacts.phone_three, Contacts.phone_fax, Contacts.Address...

As you can see from the picture, the months and days of the birthdays and anniversaries are sorting and displaying correctly, but the group header is not displaying the appropriate month. Initially, I had names in the list without dates, so the first header displayed nothing, so I checked for...

Your input has made me recognize a different problem in my DB which I can now fix!:)

I knew it was a mistake to use a holiday date. It has become a red herring. In the actual use or application of the schedule during data entry, I can see the point of adding records as they occur, but the schedule needs to be published for members of the league to see. The table with game...

That is, essentially how I made the schedule in the first place, but I do not see that it accounts for starting somewhere other than the beginning. In the example I gave, I changed the date for week 18.

I have tblSchedule. If one of the dates does not fit into our schedule it can be changed in the frmSchedule. In the uploaded DB, BowlWeek 18 was Christmas, so I updated it to the following week date. It could be changed to January 8, since January 1 is obviously a holiday, as well. (I know...