Updating Numeric Values
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I've tried adding 'WHERE [TableName].[TimeLeft] >0' but it doesn't work.
There is a simple query which shows the sum of the values entered into each field per month. I compare the sum monthly with another table through a union query. this is where the problem occurs.
For example: June 2011 in the union query - shows a sum of 16 - however the simple query shows a sum of 17 for the same month.
The issue seems to be with double entries on the same day. What I mean by that is - On June 16 (ID 2468) there are entries in two fields - Field A has a numeric value of 1 and Field B has a numeric value of 1.
Seems like the union query is only picking up one of the values. How can I get the query to pick up both values?
One of the fields has traditionally held numeric values, but recently we've been receiving some that have text values (A123456789 instead of 1234567890) and the link fails to recognize it,and the column is created as Numeric.
How do I fix it so I don't lose my Text values?
The files are in Excel's csv format. This is a relational data base which, according to the literature, means that the Report Table needs to be linked with either the Alpha or Numeric table depending on the values requested.
The linking field is known as the report record number RPT_REC_NUM.
The individual RPT_REC_NUM represents one line of data for each organization in the data base which contains of the the numeric and descriptive data for that organization for a given year.
So far, I have been successful in accessing the data base because I have been dealing with a small number or organizations. What I have done is to (1) open a particular year in Access (2) click on Create/Design Query (3) open the Report and Numeric Tables.
I have some code below that pushes the updates from the combo to the list.
Each assessment consists of a series of conditions for which the user must select 1. a priority and 2. a status. Both the priority and status values are fixed. Each status value has anumeric value, as well, but the user won't see that.
Right now, I have the following set up:
Priority values are a value list: Primary; Seconday; Not a Concern; Not Determined
Status values are a value list from TBLStatus: In Crisis, 1; Vulnerable, 2; Stable, 3; Safe, 4; Thriving, 5.
So for AssessmentID1, the user might choose:
I've set it up this way because I must run reporting on the numeric values in TBLStatus. Here are my problems. First, I cannot seem to get TBLStatus to connect properly with TBLAssessment. I tried a junction table, but I must be setting it up incorrectly.
Second, TBLAssessment is going to be huge - there are 80 fields. I can certainly break it into smaller tables and link them to the assessment - is this the best thing to do?
I am not wedded to this design. I just can't think of another way to do it.