Search results for query: *

Skip,Blessings to you! With the attachment, how do I use the Table in the code. Where do I put it?

This is the code I have with my Object Calendar in the workbook. When I click on any date I would like to go back 75 days and show me a list of dates of every Tues. Weds. & Thur. Just several rolls of cells each with a date of a Tue, Wed. and Thur. of that 75 day date range. Sorry, I am so new...

Yes it could. Thanks

The Calendar is Calendar Control 11 inserted as an object into a worksheet. I would like the dates to be displayed in cells on the same worksheet. I hope that helps.

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 MS Excel 2003.

Thanks PHV, I will give it 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...

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

Thanks MajP, i will give it a go. Not sure I understand how to get Like PlayerId in the different tables.

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

When I try it this way I am still getting the same thing. SELECT ScheduleDate.Date, ScheduleDate.Day, TeamScheduleTbl.Date, TeamScheduleTbl.Opponent, TeamScheduleTbl.Time FROM ScheduleDate LEFT JOIN TeamScheduleTbl ON ScheduleDate.Date = TeamScheduleTbl.Date WHERE (((TeamScheduleTbl.Date) Like...

Below is the SQL code of a query I am trying. Is this what you mean? This only gives me the date of matches scheduled. It is not showing me dates i do not have a match scheduled. SELECT ScheduleDate.Date, ScheduleDate.Day, TeamScheduleTbl.Date, TeamScheduleTbl.Opponent, TeamScheduleTbl.Time...

I am a College tennis coach. I am in need of a query that will show me all of my scheduled matches for this Spring. I can do that with my "Team Schedule Table". What I really need is to be able to show all of may scheduled matches and then the dates that I do not have a match scheduled between...

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

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

Thanks PH!

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

I went this way and it works. Thanks everyone Private Sub DistinctBehaviors_AfterUpdate() If Me.DistinctBehaviors = "Eye Protection" Then DoCmd.OpenQuery "DistinctBehaviorsPPEEyeProQry" End If

Well, I would rather have a different query for each value in the Distinct Behaviors Dropdown to run. The one query already changes the criteria based on this dropdown but I need to select different fields for each value of the dropdown and not just the criteria.