Search results

Thank you so much for your quick reply. This worked perfectly.

I have 3 different yes/no checkboxes. I would like to create a calculated field in my query that looks at all the checkboxes and displays text based on which checkboxes are selected. Here are my fields SpecialSS SpecialDT SpecialSGT So if for example SpecialSS is checked off, I would like the...

Hi, I would like to use the fields TypeDisputeID and ResultID as foreign keys in 2 different tables. They are currently being used in the main table tblCase and they are both combo boxes. I would now like to also use these fields in another new table I am creating as explained above...

Hi, I hope this clarifies things. I would like to use the same tables tblTypeCase and tblTypeResultList as a record source for 2 different tables. Think of it as having a list of provinces in a table and needing to use that table as a record source for more than 1 table. Thanks again

Hi, I have a combo box in a table tblTypeResultList that lists decision results- example - awarded, denied, allowed and has fields ResultID, Resultdesc. I also have another combo box in tblTypeCase that lists types of case example - costs, jurisdiction, governance and has fields...

Hi, I have a combo box with a list of queries that I can choose and then run the query. I just have some simple code : Private Sub cbochoose_AfterUpdate() DoCmd.OpenQuery Me.cbochoose End Sub But now I want to add the possibility of reports as well. So I would need some code to say that if it...

Thank you very much for your answer. However, this goes above and beyond my capabilities and understanding. If someone can provide a simpler answer as to how to prompt for a year eg. 2014 and then convert this year to a date range of between 04/01/2014 and 03/31/2015 or if the person enters 2015...

The SQL statement that you provided namliam worked perfectly so Thank you.

Maybe this will make it easier. The date range that I am looking at is a fiscal year. Each fiscal year starts on April 1st and ends on March 31. Maybe I made a mistake with my example records. All I am trying to do is check to see whether the dates fall in this range. If the record has a...

This seems awfully complicated. Considering that my current query works fine except for the 1 situation, that I originally described, isn't there any easier way? Thank you

Yes, you are right about #5. The reason for this post is I do not know how to create the logic that is necessary. So I do not know how to add this logic to the function. Thank you

There are 2 types of cases regular and amplified. And depending on the case, there may be 1 of the 2 dates or both of them. In regular cases, there is only 1 date, the ReqReceived date. In my query this date has to fall within the date range. In amplified cases, we always have the date...

Hi, I have a query that is hard coded with a date range. SELECT tblCase.CaseId, tblCase.ReqReceived, tblCase.Letter_AMPI, FROM tblCase WHERE (((tblCase.Letter_AMPI) Between #4/1/2014# And #3/31/2015#)) OR (((tblCase.ReqReceived) Between #4/1/2014# And #3/31/2015#)) ORDER BY tblCase.CaseId; I...

Hi, I have a query as follows : SELECT tblCase.CaseId, tblCase.ReqReceived, tblCase.Letter_AMPI FROM tblCase WHERE (((tblCase.Letter_AMPI) Between #4/1/2014# And #3/31/2015#)) OR (((tblCase.ReqReceived) Between #4/1/2014# And #3/31/2015#)) ORDER BY tblCase.CaseId; I am looking for all records...

Hi, Thanks again. I have to admit that I just don't understand what you are trying to explain. I am certainly no expert, a self-taught Access user for the past 20 years. As for ages, since I am a certain age right now and I started 10 years ago competing, there are not that many age...

Hi, Thank you for your reply. I don't really understand your comment about the lookup tables. If there is no lookup table for example for the age group, this would imply that this would be stored as a lookup field in a table. There has been great discussion in these forums as to the fact...

Hi, I have built a database for my triathlon and running race results. My goal is to enter my swim, bike and run times and then calculate based on the distance of each, the time per 25m for the swim, the km/hr for the bike and the km/hr and min/km for the run. And if I just do a run, the...

The tblrace does not show any of the distances. This comes from the tbldistance which looks like this : Distance ID Distance 1 750m-20k-5k 2 1k-27k-8k 3 500m-20k-4k 4 5k 5 10k The distance is a text field. I am wondering if I should add more fields that are numeric only for the swim, bike and...

Hi again, Now that I have the formula correct, I realize that the formula has fixed numbers. Meaning that I have hard-coded the swim, bike and run distances as 500m, 20km and 5km. And I use these numbers to calculate the km/hr. Unfortunately not all the triathlons have the same distances...

It works perfectly thanks. But can you explain what the 86400 represents?