Topics Search

Updating Numeric Values

Updating Numeric Values
Views: 1
I have two records that are brought in from an outside source. However, in my database I need their fees and payments to be combined because, now, they are one entity in our system, but the system I am getting them from does not know that. So I have tried multiple update queries that aren't working. Any
Sponsored Links:

Similar posts...

 

Only show numeric values

Only show numeric values Icon
I have a query which does some mathematical calculations on my data. Some of the results are Text ('No Change' & 'Used Space Decreased') and the rest are all numerical values. Is there away to pull out only the entries which have a numeric value bigger than 0?

I've tried adding 'WHERE [TableName].[TimeLeft] >0' but it doesn't work.
 

Union Query and multiple entries

Union Query and multiple entries Icon
I'm running into an issue with a union query - it is not properly gathering data from the table. Database is relatively simple - I enter numeric values in various fields: Example: Field [Front damage] - gets a numeric value of 1 every time a damage is found.

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?
 

Link Excel file to Access, wrong data type

Link Excel file to Access, wrong data type Icon
I have some code that links an Excel spreadsheet to an Access database then does some work with the data in that linked table.

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?
 

Inputting Record Numbers in an Access 2010 Query

Inputting Record Numbers in an Access 2010 Query Icon
The data base is comprised of three tables (1) Report Table containing descriptive information (2) Alpha Table containing character and numeric values (3) Numeric Table containing numbers only.

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.
 

Pulling Numbers from a Text Field

Pulling Numbers from a Text Field Icon
I have a text field "Notes" that has numeric values I need to extract. I'm running into difficulty because the numeric values are in no particular order. I've looked at various solutions online but can't seem to find one that simply takes a field and pulls out characters that look like numbers.
 

Problem with Listbox update via Combobox and Field Values

Problem with Listbox update via Combobox and Field Values Icon
I have a listbox(includesA) which works via combobox(sel_mac) update sort and the field values that were selected prior, however, the values it posts are numeric ID values and not theactual field values I want to be shown in the listbox.
I have some code below that pushes the updates from the combo to the list.
 

Update Query selecting multiple values in one field

Update Query selecting multiple values in one field Icon
I have a table that contains a location field which is numeric that represents the county of the record. I want to update the Zone field so that different counties i,e, numbers are given different zone numbers. Say I want to update the Zone field to 1 in all the records where the infocode (which is the county code numeric) is equal to any of the following values 6,17,46,47, 55 What is the easiest way to build this query
 

Use Numeric Criteria in Expressions

Use Numeric Criteria in Expressions Icon
To specify numeric criteria for an operation, you supply a numeric value as part of the string expression that forms the criteria argument. Learn how to specify numeric criteria for an operation.
 

Setting Up DB with numeric values

Setting Up DB with numeric values Icon
The db is to collect assessments for clients. Each client could have several assessments taken over time.

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:
[CODE]

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:
[CODE]
etc.

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.
 

Search Form returns numeric values but I need original names

Search Form returns numeric values but I need original names Icon
I have created a search form that is taking the data from a table (called Jobs). I am trying to grab names (cardname and approving off) from the table but when I run the search form I am only getting numeric values returned from the table (Jobs). Why is this? This table is joined to another table. The jobs table is on the many side