Query or Reporting

[Guest]

I have add a new table of department names. Is there a way I can designate
these names to a specific set of zip codes without making changes to the zip
code table. It is to intangled within the database to unlink anything? What I
am trying to do is run a new report that will give the department head when a
certain zip code comes up in the report. I guess a IIf then thing but not
good at SQL statements.

Thank you for any help

Steve

 

[John W. Vinson]

I have add a new table of department names. Is there a way I can designate
these names to a specific set of zip codes without making changes to the zip
code table. It is to intangled within the database to unlink anything? What I
am trying to do is run a new report that will give the department head when a
certain zip code comes up in the report. I guess a IIf then thing but not
good at SQL statements.

Steve, I appreciate your confidance, but you must know that nobody here has
any idea whatsoever how your tables are structured, or what kind of
"unlinking" you're talking about.

ASSUMING - and I know, that can make an "ass out of U and ME" - that each
department needs to be associated with one zipcode, then you can simply put a
Zip field in the Departments table. If on the other hand each department can
be associated with several zipcodes, then I'd suggest "breaking normalization"
a bit and creating a DeptZip table with the DepartmentID and Zip; add each
pairing there. You could then simply join this table to your report's query by
Zip to retrieve the appropriate department.

John W. Vinson [MVP]