Search results

Boooya :D :D It is working, @CazB your code worked... The opening parameter statement and adding it at the end of the "WHERE" statement is what did it...... Again thanks to you all..... John

@Mile-O, Thanks for your help... I don't think the format is the issue, I feel I need to clarify... I believe I may have misled everyone... The formula ReInvestDate...

Thanks for your help on this, I have identified them as "DateShort" and enter them as MM/DD/YYY..... John P.S. I have a blank version with around 50 randomly generated names I can post if it helps...

I have a report that is based on a query, I have tried to add the “Between [Start Date ] And [End Date]” in the query and it returns a blank report (headers no data)… I have been able to get this work using the manual method “>#1/1/2013# And <#6/30/2013#” but not the user interactive method…...

Thanks to both of you for your help, @EteralMyrtle, I understand your point about the extra work.. I did take a look at the linked article, it wasn't really pertinent to my situation in that it talked about catenation across a one to many relationship (two tables). In my situation I am dealing...

All, I have a post in the general area, I didn't know if it was better for here or the Reports area (didn't want to double post)... If someone wants to take a crack at it great, if so could you move it to here if it applies... Thanks

I am putting this post here because I am not sure if the best tool is a repot or a form. I have a database with employee folders containing various bits of information. My intent is to have a “main” page with a sub report or from containing employee names. Instead of the names being displayed...

Thanks for your help on this.. I understand your comment about adding additional Iif statements, however the Ts, S and SCI are the only Eligibility types that are used for the calculation in the query and these won’t change… Your suggestion of moving the “years” to another table sounds good...

A quick update: The second query works using the >#XX/XX/XXXX# and <#XX/XX/XXXX#... However using the Between [Start Date] and [End Date] does not work... To me this seems to be a case where the "Between" action may be trying to happen before the date calculation.... Don't know... John

The Title is a little misleading because I didn’t know how to present it… I created a query based on a table that contains several fields. The fields that drive the query are a date field “PrevInvestDate” and type field “Eligibility”.. The objective was to create a “ReInvestDate” based on the...

My VBA code skills are not that good.. John

I see how this works however I don’t know if I can fit it into my expression: ReInvestDate: IIf([Eligibility]="SCI",DateAdd("d",+1825,[PrevInvestDate]),IIf([Eligibility]="TS",DateAdd("d",+1825,[PrevInvestDate]),IIf([Eligibility]="S",DateAdd("d",+3650,[PrevInvestDate])))) I tried this...

I may have found the answer, if the result of the expression returns the date as text I believe that will cause this issue…. If so can I fix this? John

Sorry, here is the skinny of what I am trying to do…. Referencing the attachment, attempting to produce a report based on this query. The report lists employees based on their next investigation date. This date is affected by two factors one causing a result 5 years and 10 years in the...

I guess the real question is; can you derive a date range where the date only exists in the query? If I can sort by this date than logic dictates I should be able to apply the “Between [Startdate] And [Enddate]” to the Criteria box. Of course logic may have nothing to do with it. John

I have a query that I want to “filter” based on a date derived from a Build statement (Expression). The Build statement works I can even sort by “Ascending”.. But when I try to add a “Between [Startdate] And [Enddate] statement in the Criteria box, returns nothing…. Build statement ...

dohh.... Thanks for the easy button, I guess if one looks at it to long the simple answer can elude you..... :banghead: :o All better now... Thanks... John

I am trying to create a query that returns records whether a field has data or not… There are three fields in question, SSN, DOB (this is a date field), POB (this is a foreign key representing a state in the query shows the actual state). Now unless the criterion is different then I just need...

All, I wanted to thank everyone for their help on this issue. After talking with one of my engineers I have decided to simply use a default entry like ‘N/A” or “Unknown” instead of having to deal with the null values. I did do some reading on the subject of multiple left joins and access and...

All, Here is the query, it is find of long so there is two parts... Also here is an example of the Contract filter: Contract: tblContract.[ContractName] & " - " & [ContractNumber] All of the filters are similar..... John