Question about Business & Productivity Software

1 Answer

I want to add two value of two field and display another field in form of ms access 2003

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 78 Answers

Set field number 3 = to sum of first 2

example
A1 = 5
B1 = 6
C1 = A1+B1 which will make C1 show 11
type in C1 = then move cursor (arrow key) over to A1 then type + then move cursor to B1 then hit enter - formula showing in C1 on top should show
=A1+B1 and valud in cell should show 11

Posted on Mar 21, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

MS Access: Zero value to display as "New"


Is that field a resultant of an expression or it will be filled manually? If it is a manually updated field then use the following expression in the code builder.

If ok.Value = "0" Then
ok.Value = "New"
End If
If the field is a resultant of an expression then add some more lines similar to above to get required results.

Jul 13, 2009 | Microsoft Office Access 2003 (077-02871)...

2 Answers

I want to create a function in access to calculate a total. Where can I find a step by step guide?


If you already have a field where you want the total to be if you right click on the field and go to properties and find out the name of the field and also the 2 or more other fields that you want to add or multiply together then you can make the total field equal to the formula ie

if you have 3 fields

Field one = value1
Field two = value2
Field total = total

in design mode you would right click on the total field and go to properties and in the properties there should be a field where you can enter a formula.

in there you would enter something along the lines of

=value1.value + value2.value

Then when you have it normal view ie you open it, it should always add the values together and put the sum of them into the total field.

If you want an example database post back and I will create one.

Apr 13, 2009 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Ms Access 2003


If Access is anything like Excel, you can put in one of the cells: =SUM(A1:A5) If I remember rightly. That will add all the values from A1 to A5 together and display it. Alternatively, you can do =SUM( and then select all the values you wish to add together with your mouse by dragging, or selecting individually by holding CTRL whilst individually selecting. Hope this helps, because I'm only going under the assumption that Access is similar to Excel. Either way, you will need to use a formula similar to the one I just showed you.

Sep 10, 2007 | Microsoft Office Standard for PC

2 Answers

Hi all i want to launch a form when i click the data base file in MS access 2003 (the form is created inside the mdb file of access)


hi,

on MS Access 2003:
goto Tools Menu --> Startup --> select your form for "display form/page" dropdown
uncheck the "display database window checkbox and display status bar checkbox

Hope this helps.

Thanks.

Apr 01, 2009 | Microsoft Access 2003 for PC

1 Answer

MS Access-validation rule-for every value start with "E" or "V"


go to design view and select the Admission_Number field. At the bottom of the screen in the field properties section, select the 'Validation Rule' and input the following syntax: Like "E*" Or Like "V*"
The * indicates any character after the E or V.

Mar 21, 2009 | Microsoft Business & Productivity Software

1 Answer

How to get 1 value from report to another form in ms access


You'll have to use a separate Group By query to get the summed data you are looking for, you cannot pull it off the report.

Feb 06, 2009 | Microsoft Business & Productivity Software

1 Answer

How to use passwd character in a table in ms-access 2003


When you create table where you want to store passwords, go to Edit Table, then select a field where the password will be stored, go to Input Mask field in Properties and type Password in that field. That will set up the field needed for storing passwords.

Aug 18, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Conversion of nemeric value


If you just want to change the format to text in a query, you can use the Str function in your query. In MS Access, in the Field area of your query in Design View, you can type the following:
YourDesiredCharFieldName: Str([YourNumericFieldName]).

On the other hand, if you prefer to convert the data once and for all in your table, you can go to the Table Design View for that Table, change the Data Type of your numeric field to "Text", and close that window to save the changes. This will convert all of your data in that field from numeric to text permanently.

Jul 01, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Ms access


Stored Procedures don't exist in MS Access. You do have the following options though. Queries, which are just select or action queries. VB Code, which you can write using Query Objects as if you were writing a Visual Basic application. These can be Functions or Subroutines. In these, you would use the standard programming techniques with while and for loops, etc.

You can create complex situations combining the two of these. A function in the VB code area can accept through parameters, the single values (line by line, record by record) in a query and act on them and manipulate the values.

For example: create a query that does a select phone from address. Create a function in vb called public function StripDashesInPhone(Phone as string) which then uses VB coding to strip dashes from each phone value passed in. To make it all work, in the query on one of the field columns put "NewPhone: StripDashesInPhone([Phone])" and for every record processed in the query, the function is called with the [Phone] field value passed in to the function and the action is processed and returned.

Other than writing a function that is activated by a form button click, which opens the current db and opens a table and process it, just like in VB, this is about as close to cursors and oracle procedures as you get.

I wish it was more, but ...

Oct 09, 2007 | Microsoft Office Standard for PC

3 Answers

Connecting html form to Ms-access data base


If, as I suspect, this is for a web form, then it effectively can't be done on a "proper" web server. This is because you cannot install MS Office on an MS server OS (e.g. Server 2003). You need to use MS SQL Server or MySQL instead. If this is for very limited use (i.e. only a few clients at a time), you can use XP running IIS but this is really not a good idea. The sedurity implications don't bear thinking about :) Linking a web page to Access can probably be done using ASP (never even thought of trying it - anyone else here know for sure?) If you are using a Linux web server then it's totally out of the question. Use Webmin or PHPMySQL to set up a MySQL database & PHP to code the linkage between the page and the DB. There are plenty of tools out there that will automate this for you, some of them Open Source and therefore free to acquire.

Sep 26, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

97 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18299 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...