defining a range of columns in a table for a query or expression

S

Spiky

Hi,

I am in the process of creating an Access database to
track the servicing requirements for a company.
All the service tracking was previously being done in
Excel 2000 but due to the size and extra requirements it
is being transferred into Access.

In excel the Vlookup formula was used to lookup another
sheet and match the service date and service unit with the
service level, thus letting us know when the service is
due and what level of service is required. BUT I am
having trouble getting Access to do the same thing.
The excel formula is: =VLOOKUP(C271,'FireMaterial'!A:O,
M271 + 3, FALSE)

How do I either convert an excel formula into access or
Get Access to lookup a range of columns in a table.
I have been trying to use the DLookup function but keep
getting either the #Name? or #Error messages.

I need it to look at the date, then the unit, then match
both to the service level. Basically, find the matching
field in the table.
Please help, I know it is pretty simple to do but I keep
going blank, and it is driving me crazy.

Thank you.
Spiky
 
D

Doug Munich

Rather than using DLoopkup, you may get what you want with a query. If I
follow you correctly you can create a relationship between your Unit table
(which contains your Unit Name or whatever, and the Service Date) and your
ServiceLevel table (which contains Unit Name, Service Date, and Service
Level) based on UnitName and ServiceDate and then have a query showing
UnitName from the Unit table and ServiceDate from your ServiceLevel table.

Hope this helps.

Doug
 
Top