Filling in the Blanks of a Table

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

Guest

I have a table with groups, divisions, and paycodes.

For example

Group Division Paycode
1 A a
b
c
B a
b
c
2 etc. etc.

My table, however, is incomplete (there may not be a paycode c for Group 1
Div A). My table, in theory, should have a paycode for every division and
group and I wanted to see if I could modify my table to include "null" values
for any group or division that doesn't have a paycode or if I could run a
query that would list all of the null paycodes by group and division. My
goal is to "fill in the holes" where a paycode is not listed.

Thanks in advance for any response. I am a beginner user in Access, however
I am very good in Excel.
 
Create a table on numbers (COUNT) and a table of letters (ALPHA). Use the
following query, editing the maximum group, division, and paycode. This will
give you all the possible combinations. Then use an Unmatched query to find
the holes.

SELECT Count.Count AS [Group], ALPHA.ALPHA AS Division,
LCase([ALPHA_1].[ALPHA]) AS Paycode
FROM [Count], ALPHA, ALPHA AS ALPHA_1
WHERE (((Count.Count)<4) AND ((ALPHA.ALPHA)<"G") AND
((LCase([ALPHA_1].[ALPHA]))<"d"));
 
Back
Top