Search results for query: *

([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)

This is what I have in my Database ID Location Dept Rec 1 1M01 1ST FLOOR Rec 2 1M02 1ST FLOOR 222 Rec 3 1M03 1ST FLOOR 444 When I run my Select query using the Like [Enter a Department] & "*" Or Is Null I enter...

I have a database that has 600 records in it. The user has not populated anything into the Department field. I need to write a select query to allow the user to enter a Department at the time of running the query. So I used in the Criteria Like [Enter] & "*". But when I run the...

Ok this works great. But I need to have a message display when they try to enter something into this field when there is already something in the field. Where would I put that message then base on your code in the last thread? I need to display the message 'No Change Possible' Thanks, Todd

I have this code in my form it works great when the user tries to change something in a field that already has a value in it. The field is numAdmitNumber. But my problem is when the go to enter a new record and the enter 123 in the numAdmitNumber then tab to the next field and they realize the...

IF I remove this then the user can enter something into the field when they should not be. If you are on a record that has something in the numAdmitNumber field and they try to enter something over it then if I remove the GotFocus logic then my message in they KeyDown does not display. I want...