Search results

I am so new to this I have no idea what you are speaking of. Basically I want to select a date on the calendar object and go back 75 days only see Tue. Thur. & Sat. dates in rows on a worksheet.

I am using Calendar Control 11 inserted as object in the worksheet. I want the results (dates) displayed in cells on the worksheet. Thanks again.

I would like to select a date on a calendar and go back 75 days from the date selected and show every Tuesday, Thursday and Saturday in the 75 day range. I would like to see the actual date of each Tue. Thur. & Sat. Please advise and thanks. I am using Excel 2003.

Brian, Blessings to you and I thank everyone for their help. I did miss the word Between when I copied and pasted into my query. My Bad. It seems you missed something earlier when I posted earlier about the 3 solutions I had received. The one you are asking about I had said earlier worked...

They all three worked but the one allows me to type in days on the fly! I want to thank everyone for their help!

I experimented around and just added "Between" before the string and it worked. Thanks for all of your help.

Here are the 3 helps I have received for this: This one works: Between Date()-75 And Date()-50 This one works: DateAdd("d",-25,Date()) And DateAdd("d",-75,Date()) This one returns no data but I would love to have the versatility of putting in my days on the fly. Hope you all can tell me why...

I have tried the above and no matter what numbers I put in it brings up no data. From: 25 To: 50 is an example of numbers I am putting in. I have put this in the criteria field of my PlantStartDate field. Please advise!

Thanks everyone, I will give this a try.

I am wanting to use criteria in a query that will allow me to filter data based on a date range like: >25 days but <50 day. I possibly would like to see data that is more than 25 days old but less than 50 or more than 50 and less than 75, etc. This would be based on a "StartWaterDate" field...

Thanks for your help.

I am trying to track vegetables that I will be planting in my garden. I will plant some vegetables. I have a StartDate and HarvestDate and EstimatedHarvestDate Fields. I also have a field named GrowDays. This field states how long it takes for each vegetable to mature i.e. 75 days or 58 days or...

I have Office 2007 so I installed that and will give it a try. Thanks so much for your help.

Thank you so very much for the zip file. I am really excited to check it out. I only have Office 2003. Is there any way you can convert this for me so I can try it out? Thanks again.

I am a tennis coach at a local college. What I am trying to do using access is: I want to enter my players names, classes and class time. That way I can find out when a player is available for practice. I do not know how to accomplish this. Classes start at 8am and end at 5pm. They are usually...

I need to create a table to store tennis match information. I then need to create a form to enter the data. I can do all of this but I am having some issues with my thought process. There will be multiple matches (10?) during the season. For each college match there will be 6 singles matches and...

The code below is in one of my Query fields. I would like to do the following or something like it: If "out of stock" is null then "Pct No Faults" 100% or if "out of stock" is not null then the code below. Anyone know how to write that? Also, if "out of stock" is null I would like a zero to...

Thanks pbaldy, That will give me each date but will not put 100% in the field if "out of stock" is null. I am looking to show a zero if out-of-stock is null and add 100% to the "Pct No Faults".

The SQL Code below is a combination of 3 queries. The 2nd SQL Code below is one of the 3 queries that make up the 1st SQL Code. The PossibleCause Field of the 2nd query criteria is "out of stock". The combined query below is based on a date range. I have been asked if the dates in the...

Below is the SQL code I am using on a query. This query is counting Safes, UnSafes, Totals and then giving the pct of Safes. It kind of works. My issues are as follows: Everthing that is being counted are yes/no Check Boxes so the totals are showing up as -17 or -22 etc etc. I would like for...