Leopardfist
Access Newb
- Local time
- Yesterday, 23:23
- Joined
- Feb 14, 2006
- Messages
- 87
Sorry for the vague subject, but I really could not think of a way to sum this problem up.
OK, I have a database with a field titled Meal. In this field there are 9 possible choices: REG, N/P, N/M, C/F, BAG, Styrofoam, REL N/P, REL N/M, REL C/F.
Now, I have a report that lists how many of each meal type we have, it breaks down very simply.
Meals
REG -- 50
N/P -- 50
N/M -- 50
REL N/P -- 50
Etc. Etc.
The problem I have is..... I have 18 assignments to "REL N/P" and 1 assignment to "REL C/F". On my report, it shows all 19 as being REL C/F.
Now, I have a separate report which lists each inmate who has a meal LIKE "REL*" and it then lists the meal beside each inmate. Thsi report works fine, and only shows the one REL C/F assignment.
Anyone know why this might be doing what it is? Does it see "REL " and automatically place all query results with that meal into the first assignment that matches alphabetically? hence the "REL C/F"?
I started with them having a dash in between the REL and the C/F or N/P and it did it. Then I changed the choices to "N/P REL", "C/F REL" and it then sent those on N/P REL to the N/P count. It sounds like it is for some reason delimiting the meal title to the first 3 or 4 characters to make a match. If that is what is happening, how can I fix it?
OK, I have a database with a field titled Meal. In this field there are 9 possible choices: REG, N/P, N/M, C/F, BAG, Styrofoam, REL N/P, REL N/M, REL C/F.
Now, I have a report that lists how many of each meal type we have, it breaks down very simply.
Meals
REG -- 50
N/P -- 50
N/M -- 50
REL N/P -- 50
Etc. Etc.
The problem I have is..... I have 18 assignments to "REL N/P" and 1 assignment to "REL C/F". On my report, it shows all 19 as being REL C/F.
Now, I have a separate report which lists each inmate who has a meal LIKE "REL*" and it then lists the meal beside each inmate. Thsi report works fine, and only shows the one REL C/F assignment.
Anyone know why this might be doing what it is? Does it see "REL " and automatically place all query results with that meal into the first assignment that matches alphabetically? hence the "REL C/F"?
I started with them having a dash in between the REL and the C/F or N/P and it did it. Then I changed the choices to "N/P REL", "C/F REL" and it then sent those on N/P REL to the N/P count. It sounds like it is for some reason delimiting the meal title to the first 3 or 4 characters to make a match. If that is what is happening, how can I fix it?
