Recent content by torf66

([Date field] Between [forms]![frmSelectResolutionRpt]![RevDenDate] And [forms]![frmSelectResolutionRpt]![RevDenDateThru]) Or IsNull( [forms]![frmSelectResolutionRpt]![RevDenDate]) Or IsNull([forms]![frmSelectResolutionRpt]![RevDenDateThru]) I get an error that states Join Expression not supported.

I have this in my SQL View(I found it by the way) but I get an error join expression not supported any ideas? SELECT tblResolutions.[Resolution Desc], tblReviewerNames.[Reviewer Name], tblRequestor.Requestor, tblTrackingRequestorNew.[Review/Denial Date], tblTrackingRequestorNew.[Date...

Nothing seems to be working. I tried putting in another field for the same date and in the second criteria row put in Is Null. With this below in the first criteria row for the first date and Is Null when I run the query with nothing in the date range I get only the record with nothing in the...

This is what I have entered. Is this the correct format? I have nothing on the next criteria line down the or: With this below if I leave the from-thru dates blank then no records display, all records should display. If I put a from-thru date in then I get just those records that have dates...

I have this on line 1 of the criteria Between [forms]![frmSelectResolutionRpt]![RevDenDate] And [forms]![frmSelectResolutionRpt]![RevDenDateThru] And Is Not Null then on the next criteria line I have Is Null this is on the or: line. Now if I do not enter a specific date range I get that only...

I put this in like this: Between [forms]![frmSelectResolutionRpt]![RevDenDate] And [forms]![frmSelectResolutionRpt]![RevDenDateThru] Or Is Null When I enter a from thru date say 01/01/04 and 01/15/04 I get all the records in the date range but then I also get the records that do not have a date...

I have a query that runs from a form. In the form I have the option for a user to enter a From-Thru date to print to a report based on the From-Thru dates they entered on the form. My form is called frmSelectResolutionRpt my fields on the form are RevDenDate and RevDenDateThru. WHen I use...

I have two cells that have time in them. I want to be able to calculate the difference between the values. For example cell A1 has 14:45 in it and cell B2 has 15:10 in it. I want to subtract the difference and return a value in cell A3 of 25minutes. How can this be done in Excel? Thanks...

Is it possible in Access to have the user create their own reports? I have say 10 fields in my database and some users want to only show 3 of the 10 fields on the report but then other users want to see totally different fields on the report. Is there a way to list all 10 fields on a screen...

I have a form and at the top has the following fields: AdmitNumber Admit Date Discharge Date Patient First Name Patient Last Name Then I have a tabular subform in the middle that has numerous fields where the user can enter data. They can add records to the Admit Number fields at the top and...

Where would I put your suggestion, can you give me the steps of how to apply the logic you provided. Thanks, Todd

I have a question. In a query how do you get a field that has null values but also may have a value in it to show everything on a query. For example I have the tables/fields listed below. I want to list by using a query the Locker ID/EmpLastName/EmpFirstName. In Table1 EmployeeID is null or...

I have five fields example field names are ActiveCombination, Combination1, Combination2, Combination3, Combination4, Combination5. I want the user to Enter a combination and then display only that combination on the report. For example I enter at the prompt 'Enter Active Combination' and I...

I have entries like this on a form Combinations: 49-05-21 42-48-14 37-43-09 Each of these is in a little window on the form. Only one of these can be active so I wanted to add check boxes below each combination. Would that be the best way to go. The user wants to display which one is...

Where would I enter your suggestion in my Select Query, how do I get this into the query? WHERE IIF (Len(Trim([Enter a Department])) = 0, TRUE, [Dept] Like [Enter a Department] & "*" Or [Dept] Is Null)