querying records, some have a matching key some do not.

J

JoeA2006

I need to relate records from one table(tblEntriesTmp) to a table containing
categories (tblCategories) for sorting these entries.

The fields for the tmp table are
Date
Location
Desc
System
Source Code
Amount

appends to perm table using the category table in an append query
Category table:
CategoryID PK
CatDesc
System FK
SourceCode FK
SortKey FK



The fields I need in the Perm table
Date
Location
System PK
Description
Souce Code PK
SortKey ---RIGHT([Description],3) PK
Amt
CategoryID

The problem is on many records, the sort string does not have a
corresponding record in the category.SortKey column because there are an
infinite number of descriptions, but some that are consistant from month to
month Those records are unique because of the other keys. Is there a way to
use the sortkey as a key only on certain records?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query to show all records whether or not there is a matching messa 5
Query is not locating all records 3
totals query as recordsource of report 6
Advice needed on an append query 4
appending new records to a table with a compound primary key 11
How do i use subforms and reports with self joins?? 3
Trouble with composite keys 2
Retrieving records with a query by form. 1

Top