Search results

Gina, Sorry I am just getting back to this. I am trying the update query. Can you or someone point me in the right direction on how to write the following? If OperationsDate in tblDispatch is greater than or equal to EffectiveFrom and less than or equal to EffectiveTo in tblSchedule AND...

Im not able to share the database. Should I be reposting this somewhere for more responses?

I need to explain this better as it has become more complicated than originally thought, I am not an expert in access so any help would be appreciated in how to get this to work: I have a form named frmDispatch; I am trying to figure out how to do the following when I enter the OperationDate...

Thanks Ginna I made the qrySchedule an append query and it does send the data to the tbldispatched which is part of what I wanted to accomplish. So now how do I make it so that when I click on a record in the listbox it shows all fields show on the form?

Hello I have a form (frmDispatched), and a query (qrySchedules). I would like to have a listbox on the frmDispatched that has the schedules information in it that would allow the user to click on any given schedule and have that information populate into the frmdispatched(table). From...

I am trying to figure out a way to calculate distance from coordinates. I have spent my afternoon googling and everything I have found appears very complicated. Am I just overthinking this and freaking out, or is this as complicated as it appears? I have the cities, coordinates.. just need...

We cross time zones in travel and my need is to ensure that data entry is entered is such a way that it recognizes both the movement between pacific to mountain (vice versa) time zones as well as daylight savings... Did that make any sense? Tracy

Hmmm maybe I should mention as well that I only need to consider two time zones, Pacific and Mountain..... Tracy

Thanks Ill have a look.

I love simple.. I will try to digest this one... thanks

Ugh... is there no easier way of dealing with this!! sigh... I found this but its backwards from what I need and not sure if it will work for what I need to do. It was posted to covert GMT to local. Option Compare Database '*** start code *** Option Explicit 'following code adapted from...

Help?.. just need a little push.. insight.. :)

I am trying to figure out how to handle working with ZULU Time in a database Time Zone and difference to Universal Time Dealing with 2 time zones Dealing with daylight savings time Someone suggested :establish a table with the ZULU offset for each time zone witht he logical field that...

I am trying to figure out how to handle working with ZULU Time in a database: Time Zone and difference to Universal Time Dealing with 2 time zones Dealing with daylight savings time Any input would be appreciated.

Sweet, I have been chasing a parameter error forever, checking the sorting and grouping located the problem! Thanks Tracy

As usual, brilliant! Such a simple thing! Thank very much Tracy

Tried that, seemed to make sense to me too, but the field that should be not overdue is howing blank?

I have the following code in my query and it seems to be working fine, but I would also like it to show the Not Overdue Items. Overdue: IIf([Investigation Status]="Open",IIf([DueDate]<=Date(),"OVERDUE")) Any help would be much appreciated! Tracy

Sorry my bad! It works! Thanks Bob! Appreciate it!

I have tried your suggestion Bob, the field name shows but no data is appearing?