Look Up Help

J

Josh

Hello,

I have a question concerning lookups. I know that there is a lot of
information concerning Dlookups compared to Vlookups, but I am not sure if
that is the correct formula that I want to use. What I am trying to do is
this: I create a table of open items on a weekly basis and I would like to
compare the open items from the current week to that of the previous week.
Basically what I want to see is how many open items were resolved through out
the week. I used to do this in excel by using the Vlookup function after I
already exported the data to excel from Access, but I would like to see if I
can do this in Access as I am already in that program.

I am not even sure what the correct path to take is.

I hope this makes sense. Any and all help would be appreciated.

Thanks,
Josh
 
L

Larry Daugherty

Don't create a new table each week! That's "Excel think". In the one
table that will hold all of those items, include "DateOpened field and
a "DateResolved" field, each with a datatype of date/time. Now you
can use queries to report on the number of things opened (or resolved)
between any two dates. The Microsoft.public.access.queries newsgroup
is helpful in that regard as are any number of books on Access. My
favorite books are those by Ken Getz and his buddies.

Oh, don't delete items once closed. let them continue to live in your
database for a long time to provide historic information such as
trending, etc. An Access database can grow to 2Gbyte before it's a
real problem . Check the size of your BackEnd and you'll see that you
have plenty of room to grow. If BackEnd is a new term for you then I
suggest that you do a Find in your newsreader on the term and read and
learn. Also look for "splitting". It's related to FrontEnd and
BackEnd and how they came to be. Other interesting terms and
practices are Backups, Compact, Repair....

Welcome to Access.

HTH
 
J

John W. Vinson

Hello,

I have a question concerning lookups. I know that there is a lot of
information concerning Dlookups compared to Vlookups, but I am not sure if
that is the correct formula that I want to use. What I am trying to do is
this: I create a table of open items on a weekly basis and I would like to
compare the open items from the current week to that of the previous week.
Basically what I want to see is how many open items were resolved through out
the week. I used to do this in excel by using the Vlookup function after I
already exported the data to excel from Access, but I would like to see if I
can do this in Access as I am already in that program.

I am not even sure what the correct path to take is.
Click to expand...

Neither VLookUp nor DLookUp, frankly!

Access is *not* "Excel on steroids". It's a very different program with a very
different philosophy. An excellent spreadsheet can be a abominably bad Table,
and vice versa.

As Larry says, abandon the spreadsheetish "table per week" approach. It will
become an utter nightmare and is not necessary. Check out the links at

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

especially the Database Design 101 links on Jeff's site.

John W. Vinson [MVP]
 
Top