Look Up Help

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

Guest

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
 
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
 
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]
 
Thanks for your help guys. I appreciate it. I have been using excel for long
enough that it is going to be hard to break myself of my old thinking. But
the more that I play with access, the more that I like it. I think that it is
going to be much more useful to me for some of my reporting that I do at work
than excel.
 
Back
Top