Search results

I just changed the FIRST function to MAX on my field expression. It seemed to fix the problem. Thanks for the help.

I'm using a combo box for frequency with the FrequencyID as the bound column for both the table and the form.

See revised spreadsheet.

Sorry for the confusion. The last entry on the query is an example of my problem. If I put this entry in the table (CompletionDate 8/18/16), this is the problem I would have on the query. I Forgot to add that note in. :banghead:

See attached. Hopefully this is enough information. My goal for this is to filter out results that reoccur on a daily basis for example, and if it's been completed for that day, will not populate on the list until the following day when it is due again.

This is what I want to happen. (1) in my count field is 1 day. This will give my last completed date of 8/18/16 another day to 8/19/16 which should then essentially, remove it from the list because it doesn't match the criteria <=Date()

I have attached the table. The goal is to take the "maxofcompletiondate" and add the count table to it to give the next day. The correct value should be 8/19/16 but it only shows that way in the form, not on the query. I used the last one because it kept calculating from the first entry in the...

I have a form that should only display Due Items based upon the criteria <=Date(). This way i can see items that are either at today's date or a past due date. My form based off the query shows "DueDate" of tomorrow (8/19/16). But my query shows it as Today (8/18/16) therefore will not remove...

Never mind I got it figured out.

Ok so that worked great, on my test database. On my main database it's a very similar setup but more to the SQL. The problem I have on this one is that the records with completions dates open in taskdetail. But the records without a completion date open up to a blank page. SELECT...

frm1 on open filter by equipmentID, recordsource - Equipment (Table) Subfrm1 recordsource - SELECT PMTask.TaskID, PMTask.EquipmentID, PMTask.Task, PMTask.StartDate, PMTask.Frequency, Max(PMTaskDetails.CompletionDate) AS MaxOfCompletionDate FROM PMTask INNER JOIN PMTaskDetails ON PMTask.TaskID =...

frm1 = "Equipment with completions" - This is the first viewable form which is filtered by the equipmentID. It will only show tasks related to that piece of equipment and allows the user to view the due dates side by side. It's control source is from a query to allow the MaxOfcompletionDate to...

I have attached 3 pictures. If you look at picture Equipment tasks (Editable form(Table)) you can see that entry TaskID# 2 is present. If you go to picture Equipment with completions (Non Editable version(Query)), the entry is no longer present because I haven't given it a completion date yet...

I have 2 Tables. Tbl1 TaskID Task EquipmentID Frequency StartDate Tbl2 TaskCompletionID TaskID DateCompleted Frm1 is a filtered form with subfrm1 which shows all tasks associated with a specific piece of equipment with a query to also display a field "DueDate". All fields are locked frm2 is...

Perfect, thanks.

How do I adapt to allow me to put 2 requirements?

Hello, I have a form [frmPMSearch]. It has 2 unbound text boxes with date pickers. [FromDate] [ToDate] It has a button. [cmdSearch] I have another continuous form [FrmPMTasksDue] that has a field in it [DueDate]. What i am trying to acheive The user will open the [frmPMSearch] and select 2...

Table w/ linked table Query This is my viewable continuous form that runs from the query This is my editable form for entering new data like a new task. At this point there will be a start date but no completion date. The highlighted entry is a new entry that will not populate on the...

I got the following error. I will upload some pictures to see if I did this right. I do not have much knowledge of functions.

I have a query that has 5 fields. TaskID Task StartDate MaxofCompletionDate DueDate If i input a new task with a start date of 4/21/16 but it does not have a completion date yet, i will get no results. If i input a completion date into the table it will then return a result. How do i make it...