 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / August 2006access date query
I'd like to be able to return a text cell value from a table that includes fields for "start date", "end date", and the text value that I'd like to find. My plan is to use an update query that would post this value into a different table. I'm new to access and would like to be able to do this in the wizard screens if possible. Wes Why? As in "why do you feel you need to move a value from one table to another?" While this might be a common approach when using a spreadsheet, it is rarely either necessary or desirable in a relational database (Access).  SignatureMore info, please ... Jeff Boyce Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ > I'd like to be able to return a text cell value from a table that includes > fields for "start date", "end date", and the text value that I'd like to > find. My plan is to use an update query that would post this value into a > different table. I'm new to access and would like to be able to do this in > the wizard screens if possible. I suppose for reporting purposes I could continue to have the query look for the value. However, this doesn't change the fact that I'd like to be able to take an entered date in one table and have a query return a value from a different table that is associated with two other values, start date and end date. I'm working in an industry that cycles on a 8 week period. The periods are referred to as A15, A16, A17 etc. Each of these periods has a start date and an end date. I've setup a table that lists these ranges. My production period can start at any time within that range. I've setup an additional table that identifies the details of a particular block of production. I'd like a query that will look at the start date of the production block and compare it to the dates in the period table to return a production period id (eg. A16). I'm new at this and maybe I'm looking at this the wrong way. Advice is what I'm pursuing here. Thanks for now, > Wes > [quoted text clipped - 9 lines] > in > > the wizard screens if possible. Wes It sounds like you want to find the first record in the "cycles" table that has a start-date less than the date in your production block table. That sounds like taking the Top 1 (a property of the query) of the cycles table rows, sorted in descending order by start-date, where (a criterion) the start-date is less than the production block date. SignatureRegards Jeff Boyce Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ > I suppose for reporting purposes I could continue to have the query look for > the value. However, this doesn't change the fact that I'd like to be able to [quoted text clipped - 29 lines] > > in > > > the wizard screens if possible. Thanks for the advice, it looks useful. Most of what I've taken in has been through the tutorials that are available in the Office website. This wasn't covered there. Or if it was, I missed it. From what I can tell, this would fall into the SQL scripting area of writing queries. Do you know of any other resources where a person could get interactive training with SQL or for that matter more advance query developement? Wes > Wes > [quoted text clipped - 51 lines] > > > in > > > > the wizard screens if possible. Wes Right off the top, sorry, I don't. I'm mostly self-taught also. I do know of several websites by my colleagues ... perhaps there are links from these: http://www.datacomptech.com/links.html http://home.bendbroadband.com/conradsystems/accessjunkie.html http://mvps.org SignatureRegards Jeff Boyce Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ > Thanks for the advice, it looks useful. > [quoted text clipped - 62 lines] > > > > in > > > > > the wizard screens if possible. Thanks for your assistance, I will look into the sites. Wes > Wes > [quoted text clipped - 95 lines] > > > > > in > > > > > > the wizard screens if possible. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.