access date query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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).

--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


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
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

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.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
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
 
Back
Top