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:

More topics

 

Only show numeric values

Preview
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

Preview
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

Preview
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

Preview
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

Preview
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.
 

check the format of an numeric inputted field?

Preview
Is there a way to set an input mask for a numeric field, so if gets a msgbox if the values aren't in the format of "123" OR
 

Problem with Listbox update via Combobox and Field Values

Preview
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.
 

Use Numeric Criteria in Expressions

Preview
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.
 

Update Query selecting multiple values in one field

Preview
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
 

Update Query selecting multiple values in one field

Preview
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 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?