Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Copy A Number Value To Another Field And Sum The Column


I have two sub forms and need one field to equal a field in another sub form.

When I enter data (a number) I would like the field in the other form to add up all the fields in the form I just enetered the data in.

Both sub forms are datasheets.

thanks


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Find The Lowest Number And Place The Number And Column Name Into In Field
I have a access table with 32 columns and 42,000 rows of numbers. I need to find the MIN number in the row and if the MIN number has duplicates then I need them all placed into another column by column name.
Example:
Starting file
DEST,ORIGIN1,ORIGIN2,ORIGIN3,ORIGIN4, ETC
05512,3,2,4,2

ENDING table needed
DEST,ORIGIN1,ORIGIN2,ORIGIN3,ORIGIN4, NEWCOLUMNname
05512,3,2,4,2,2 ORIGIN2 ORIGIN4

Where the new column name contains the MIN number in the row and all of the associated duplicates column names.

View Replies !   View Related
How To Split Letter&number Field Into 2 Column And Skip Brackets?
HI!
I have big problem I have telephone number field like this
Tel(XX)XXXXX - X are numbers

I have to split it into two columns and skip brackets like this

Column1 - Tel
Column2 - XXXXXXX

Is it possible?

I have no idea how to manage it...I'd be very thankful for any
examples ? Or Help....I'm beginner

Thanks a lot
in Advance

View Replies !   View Related
Copy Data From A Column In One Table To A Column Another.
Please would you be able to advise me how I would copy data from a column in one table to a column another table.

But I need to only use table not a query.

Thank you in advance for your help.

View Replies !   View Related
Copy A Column And It's Properties
hello,
I wanted to know how to copy a column and it's properties by programming (VBA-SQL).
I have a column that has a list of values, and want to duplicate it (with another name).The new column should have the same list of values.

thanks for reading.
Seiky

View Replies !   View Related
Copy A Column And It's Properties
hello,
I wanted to know how to copy a column and it's properties by programming (VBA-SQL).
I have a column that has a list of values, and want to duplicate it (with another name).The new column should have the same list of values.

thanks for reading.
Seiky

View Replies !   View Related
Copy Table But Exclude A Column
Hi

Here's a brain-teaser for you all.

I want to create a copy of a table which I do using the code below.

SELECT * INTO My_Temp_Table FROM My_Table WHERE ColumnA = 100

Great, all works well.... but I want to exclude a column when the temp table is being built. I know I could specify all the columns I want leaving out the undesired column (rather than using SELECT *) but there are lots of them and, whilst in development, the table columns are liable to change. So I'd like to copy all coumns that are in force at any given time except one in particular?

I thought it would be something like :-


SELECT * INTO My_Temp_Table FROM My_Table WHERE ColumnA = '100' AND Columnname NOT LIKE 'ColumnB';

But this doesn't work.

Any ideas please?

Many Thanks

View Replies !   View Related
Copy Column Problem Wont Update
Hi

I have a column in a table which I need to display in another table I can just copy and paste it but I need to it to update with the original. I donít want to have to use a list or combo box as the data has to be selected from them and isnít just displayed like the original column.

Thanks

View Replies !   View Related
How To Copy Value From Access Table To Excel File Without Losing Number?
This forum is really helpful!

I am using following code to copy low value from Access table to excel file, but only to find that it changed in excel file. How should I do to not change that?

ThisWorkbook.Sheets("EV Data").Cells(row + 2, col + 2) = _
rs.Fields(col).Value



RecordIDDateTimeStampSetupIDStringBaseProductIDStringMGDBIDStringVAGLBIDStringPWDCohortIssueAge1IssueAge2NumberOfCellsNumberOfScenariosTotalWeightInitialPremiumEV_MeanEV_P995EV_P99EV_P95EV_P90EV_P75EV_P50EV_P25EV_P10PrEVGTZero
51907/27/2007 7:04:36 PMAccess2006Max72006MGIBAllCombinedAllCombinedAllCombined95010.006800000006810000009.33604218011769E-03-2.48487734766947E-02-2.35810657931309E-02-1.44083677074442E-02-1.10775676515645E-02-2.1878002261516E-037.92060932296671E-031.95193525290664E-023.06835072412068E-020.70658682634731
52007/27/2007 7:04:37 PMAccess2006Max7LifePayIAllCombinedAllCombinedAllCombined185010.005110000001.19424841908013E-02-1.67115163990304E-02-1.42187111112351E-02-8.08910871821918E-03-4.62961276311795E-032.72200376166994E-031.04312882683217E-022.06668892126601E-022.96649979111015E-020.80638722554891
52107/27/2007 7:04:37 PMAccess2006Max7NoneAllCombinedAllCombinedAllCombined95010.0054410000007.98908918707603E-03-1.67789382388317E-02-1.56490361783179E-02-1.07703746693193E-02-0.00753365556878-7.10709517675212E-046.72111941423526E-031.59418102675589E-022.44078788510759E-020.730538922155694
52207/27/2007 7:04:37 PMAccessRat2006MGIBAllCombinedAllCombinedAllCombined95010.0030199999969810000009.52176602967384E-03-1.56233866973614E-02-1.49901562045925E-02-8.41152147122661E-03-5.44762510232609E-034.05576508882054E-047.33588282834675E-030.0164686012768352.61950530898991E-020.754491017964078
52307/27/2007 7:04:37 PMAccessRatLifePayIAllCombinedAllCombinedAllCombined185010.00226499999773510000001.06805510377118E-02-0.014626108301625-1.20428523073918E-02-6.08984658852046E-03-2.22851888030373E-034.04428276871694E-039.82402795120803E-031.68655595406923E-022.40410662469335E-020.856287425149709
52407/27/2007 7:04:37 PMAccessRatNoneAllCombinedAllCombinedAllCombined95010.00241599999516810000005.8666292477999E-03-1.13844546795139E-02-1.04027261898336E-02-6.72766534794549E-03-4.77103336054974E-03-3.11542830732602E-044.5158867397345E-031.06654135236169E-021.76803347713142E-020.730538922155694

View Replies !   View Related
Column Chart With Variable Number Of Series
I have four column type charts based on queries that return a variable number of series in each chart depending on the data. So chart one may have 3 series, chart 2 may have 4 series etc. MS Graph allocates the colour of the series dynamically which is OK if all four charts happen to have the same series. So if Brand A, Brand B, Brand C and Brand D are present in each chart then Brand A will say be red in all four charts, Brand B will be green in all charts etc. But, if say Brand A is not present in one chart then the colour sequence will differ and the brand colours will be inconsistent between charts.

If a series is present in a chart then I want it coloured the same as it is in any other chart i.e. I want all Brand A's to be red, all Brand B's to be green etc. regardless of how many series are present.

I have tried to adapt an Excel macro but get an error Object doesn't support this property in relation to the strCase statement - see below:

Dim iSrsCt As Integer, COUNTER As Integer, strCase As String

iSrsCt = Me!DERVGraph.Object.Application.Chart.SeriesCollec tion.Count

For COUNTER = 1 To iSrsCt

strCase = Me!MyGraph.Object.Application.Chart.SeriesCollecti on(COUNTER).Name

Select Case strCase

Case "BrandA"

Me!MyGraph.Object.Application.Chart.SeriesCollecti on(COUNTER).Name.Interior.ColorIndex = 2

Case "BrandB"

Me!MyGraph.Object.Application.Chart.SeriesCollecti on(COUNTER).Name.Interior.ColorIndex = 4

Case "BrandC"

Me!MyGraph.Object.Application.Chart.SeriesCollecti on(COUNTER).Name.Interior.ColorIndex = 6

Case "BrandD"

Me!MyGraph.Object.Application.Chart.SeriesCollecti on(COUNTER).Name.Interior.ColorIndex = 8
End Select
Next

Me!MyGraph.Object.Application.Chart.Deselect


Any help appreciated.

Thanks

View Replies !   View Related
Update Column Valu With Random Number
hello all
I am trying to set column values to a random number between 3 and 5

PMRatingTokenID: textH1: doubleYearID: textCode:UPDATE PMRating SET PMRating.H1 = (5+3-3)*Rnd()+3
This shows type mismatch error . What is the problem here..


please do help...Thank you

View Replies !   View Related
Counting Number Of Times A Username Appears In Column A
I have a spreadsheet and the only column that matters is D.

Down column D it appears as:
a
b
b
b
c
c
d
e
f
c
a

I need the result to just appear like
A - 2
B - 3
C - 3
D - 1
E - 1
F - 1

View Replies !   View Related
Number Fields In Text To Number Field, Formula For Fiscal Year
Date of Birth (DOB) field etc. in one program are text - how do I make another file with the same data into number fields for Date of Birth field etc? When I copy data to file that has number fields the 09252004 is changed to 9252004. Can I get reports with the correct Date of Birth in them by moving data from text file to number file?

There is data entered monthly in file and formula has been set up for January, February etc as ---quarter: Int(([month]-1)/3)+1. I would like formula for the fiscal year for April to be counted as month 1, May - month 2, June as month 3, July as month 4, August as month 5, Sept as month 6, October as month 7, Nov as month 8, Dec as month 9, Jan as month 10, Feb as month 11 and March as month 12.

Thank you

View Replies !   View Related
1st Field In Copy Of Form Will Not Allow Moving To Next Field
Okay. I am certain that I am missing something real easy.
I have a somewhat large, form. I needed to offer users a similar form, but with a few field changes.

So, I copied the form, added the new fields.
If I work with an existing record and do not change the 1st field's data (idnumber), then no problem.
BUT if I try changing that idnumber or adding a new record, I cannot exit that 1st number.
There is no afterexit info for it or other issue that I can see. (But am I 'blind'?)

I appreciate any ideas.

Russ

View Replies !   View Related
How To Copy A Column From One Table And Insert It Into Another Table In The Same Db
How to copy a column from one table and insert it into another table in the same database

Hi, All,

I have two tables (old and new) sitting in the same database. The new table is the result of 'data cleansing' done by an external company. In the process (export and import via excel) two memo type colums in the table were truncated in excel.

To make the new table usable, I must therefore now copy/insert the two memo columns from the old table into the new table.

Both tables are already Access tables and sit in the same database. Both tables, of course, have the same number of rows.

I tried to high-light one column in the old table, clicked copy, then high-lighted a blank column in the target table, then clicked Paste, but got error msg: "This text is too long for this field. Try copying a shorter text", as if I had wanted to copy the whole column into one cell rather than one column into another column of equal length.

What is the best way to proceed?

Thanks for your help.

Adrian

View Replies !   View Related
How To Copy A Column From One Table And Insert It Into Another Table In The Same Db
How to copy a column from one table and insert it into another table in the same database

Hi, All,

I have two tables (old and new) sitting in the same database. The new table is the result of 'data cleansing' done by an external company. In the process (export and import via excel) two memo type colums in the table were truncated in excel.

To make the new table usable, I must therefore now copy/insert the two memo columns from the old table into the new table.

Both tables are already Access tables and sit in the same database. Both tables, of course, have the same number of rows.

I tried to high-light one column in the old table, clicked copy, then high-lighted a blank column in the target table, then clicked Paste, but got error msg: "This text is too long for this field. Try copying a shorter text", as if I had wanted to copy the whole column into one cell rather than one column into another column of equal length.

What is the best way to proceed?

Thanks for your help.

Adrian

View Replies !   View Related
Copy Field
I have a data entry form with many records. Instead, of retyping the same data. I would like click a button and the data on the top row will copy downward.

View Replies !   View Related
Copy From One Field To Another (in Different Tables)
I am looking at copying one field to another (held in a different table) by using a command button. I've applied to following code to the OnClick event of the command, but it doesn't seem to work and I'm not sure if you can actually copy between two different tables :

Private Sub Command59_Click()

[enquiry_mainsite]![mainsite_unit] = [enquiry_entity]![entity_postalunit]
[enquiry_mainsite]![mainsite_streetnum] = [enquiry_entity]![entity_postalstrnum]
[enquiry_mainsite]![mainsite_street] = [enquiry_entity]![entity_postalstreet]
[enquiry_mainsite]![mainsite_suburb] = [enquiry_entity]![entity_postalsuburb]
[enquiry_mainsite]![mainsite_state] = [enquiry_entity]![entity_postalstate]
[enquiry_mainsite]![mainsite_postalcode] = [enquiry_entity]![entity_postalcode]

End Sub

This code is basically trying to copy fields from the enquiry_entity table to the enquiry_mainsite table. Does anyone have any insight to if what I am trying to do is fesible?

View Replies !   View Related
Copy Field Value To Variable?
I'm sorry to have to ask such a basic question, but I'm having trouble figuring out the syntax for saving a field value, in the current record, to a variable. I appreciate the help.

View Replies !   View Related
Copy Part Of 1 Field To Another
Hello,

I need to be able to copy the last part of text from 1 field to another.

Speciffically,

yadda yadda (ABC)

to become:


+ field1 + field 2 +
| yadda yadda | (ABC) |

(ABC) is not always of length 3, it could be (XY), (T) or more.

can someone help me with a method to strip this into another field?

thanks!

View Replies !   View Related
Copy Data From One Field To Another In Same Table
I have a field called Shipdate. I have created a new field that is called invoicedate. What I want to do is copy all of the shipdates and paste them in the invoicedate field for my old records. From here on out they would be distinct fields but for old records and reporting purposes I need those dates.

Can I do that in a query, do I need a module???

It's probably easier than I think it is.

Thanks.

View Replies !   View Related
Copy Autonumber To Another Field In Same Table
I need to make changes to a table already containing data. Currently the autonumber field is simply there as a primary key, but I now wish to use it for another number field (Accession No) which was previously completed manually.

As this doesn't seem possible or practical (as I need the flexibility to overwrite the number sometimes), I just want the autonumber to also appear in the Accesion No field when a new record is added (but be manually overwriteable).

I've had a play with default values and lookups, but with no success, and haven't found anything on the forum. Where am I going wrong, or is this just not possible?

Thanks for your help.
Alison.

View Replies !   View Related
Copy Part Of A Record As Value In Another Field
Im using the UPDATE Query in Access

UPDATE MAT_Clean SET FCODE = 'BC', NOTES = 'HC RAMP'
WHERE FCODE='BC HC RAMP';

Instead of typing what needs to go into NOTES everytime, how can I specify whatever comes after 'BC' to go into NOTES? Use 'BC *'?

Thanks!

View Replies !   View Related
Subform Tab Control - Copy 1 Tab Field 2 Other
Hi

I have read through this forum and found some help on this but can't get it working.

I have a subform

Activity

Contains a tab control with two tabs

Activity Details - Persons

I want to copy the address field from Activity Details tab to the Address field on persons tab

Code for the on click even twon't work. Can't find errrors. I know it is because I haven't referenced it properly.

Me.txtpersonBuildingNameNo = Me.txtactivityBuildingNameNo

Any help :)

View Replies !   View Related
Copy Field Data To Status Bar
I have a form that resembles a spreadsheet and have data in certain fields that is longer than the field is wide. (The widths are set according to client preference and widening the field is not the solution.) I was thinking perhaps I could use the status bar to show the data when the focus is on that particular field. Right now, the only help on the StatusBarText topic that I can find indicates that the status bar can be "programmed" with static text only, but I was hoping to make it dynamic, depending on the field in focus.

If this is the wrong approach (i.e. can't be done), does anyone have any ideas about how to use an external control to show (and possibly edit) data on a spreadsheet-like form?

The client has been using MS Works and is being dragged into Access only if the transition isn't too painful (for him, lol) and having an ability to look and feel like the Works interface is important to him.

Thanks,

- Terri J.

View Replies !   View Related
Form Event (Before And After Update) Copy Form/Field Value To Another Table/Field
Group,

I thank you in advance for considering this inquiry.

From within a Form.field (based on a master table query), I desire to trigger two events; one before update and one after update.

This function will serve to document specific form.field value changes to a "log" table for review prior to being committed back to the master table.

What I'm looking for are functions, which I can use in a Macro or VBA code to facilitate a field read and copy before change and a read and copy after change triggering.

I'm sure this is absurdly simple.

View Replies !   View Related
Convert Text Field To Number Field But Keep Leading Zeros
I need to convert my text data to a number but when I convert using the VALUE function or use "format cells" to the numbers category, I loose the leading zeros. I need to keep them for sorting purposes.

What formula do I use?

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved