Question about Microsoft Office Access 2003 (077-02871) for PC

1 Answer

MS access - how to insert a function in a access table

I have prepared a database in access ledger format and a report also prepared.It contains daytoday transactions of my office.problem is when generating a report for a specific period opening balance of that day is not availed.how can i solve this .

Posted by on

  • sarath_7026 Jun 07, 2008

    thanks for your comment,

    I create the tables in ledger database. It contains 3 tables, accounts, account types and transaction. In accounts name of bank and in account types the various accounts in those banks. Transaction table contains day to day transaction in these accounts. how can I get the opening balance of each account when generating a report for specific period. ie, for a report from 1-06-08 to 15-06-08 the opening balance is the closing balance of 30-05-08 ( (total deposit-total withdrawal) below the date 01-06-08) to be displayed on top of each account header.Please help. sample database may be posted if you required



    Thank you

×

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Legend:

    An expert who has written 200 answers of more than 400 characters.

  • Expert
  • 359 Answers

Have you reached resolution yet? If not I would be happy to help otherwise, I would be interested to know what happened. It sounds like you need to call the date (today) for the appropriate balance to come in automatically - assuming you have a table holding this data. Thanks for rating FixYa!

Posted on May 05, 2008

  • Cheryl Whalen May 17, 2008

    sarath_7026:



    If you could provide the additional information in regard to where the issue stands, and if you need/want more assistance, I will gladly help. As your issue was so old at the time that I posted the response, I was simply trying to make sure you were taken care of, or that if you still needed help, I was ready to offer that. Obviously, no other expert was comfortable taking on an Access issue with the small amount of detail given, or it would have been answered when it was posted. I will be more than glad to help you if you still have an issue, as the problem depends on two things, primarily, the source of the balance (and how it is being called into the report), and the relevant date to be used for comparison to include it. Please post back if you need help; otherwise I would appreciate it if you would reconsider the rating you have assigned, as I don't believe that an offer to assist, when no one else has done so, warrants posting a "poor" rating to my offer to further advance your solution. Thank you for your consideration!

  • Dan McCracken Feb 23, 2015

    Agree poor rating not fair here. Moral of the story don't post an answer when you actually are requesting more information.

×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

3 Answers

I need to perform access database repair


The repair method attempts to recover only the tables, indexes and queries in the database. Do not attempt to repair damaged forms, reports, macros and modules. Before executing the Compact and Repair tool, please ensure the following condition:

1. Do not Open Access database must closed
2. Sufficient storage space available - minimum double in size of your Access database on that Disk.
3. Close the .mdb file related to .ldb file before you delete the .ldb file.
4. Then Run the Compact and Repair tool

Read more about Access Repair Toolbox
On:- http://www.access.repairtoolbox.com/

I tried lots of the suggestions and eventually found that this page was the most helpful http://www.filerepairforum.com/forum/microsoft/microsoft-aa/access/1385-%E2%80%8Bhardly-corrupted-access-2007-database

Feb 28, 2015 | Microsoft Office Access 2007 for PC

4 Answers

Access database 2003 problem with a copy of database file. How to fix?


You say corrupt, in what way exactly? Do you get any specific error numbers/messages?

Have you tried Access repair program? Compact and Repair. If not, use it. But ensure that you made a backup, it is necessary because all the recovery tips can make the damage even worse.

Also try Jet Compact Utility. This tool created by Microsoft and it is much like Compact and Repair, but more successful in repairing.

If no one of above advice helps, then perhaps you need more powerful solution. In this case try to run a good third-party. I would recommend Recovery Toolbox for Access. It must help you. https://access.recoverytoolbox.com/

Feb 23, 2015 | Microsoft Access 2003 for PC

7 Answers

MS Access database recovery


Have you tried creating a NEW MDB, and then IMPORTING the objects from the Crashed/Corrupted MDB?

This will SOMETIMES serve to rescue most if not all of the corrupted entities .

Or:
You can try:
eRepair Access is a powerful Access database recovery solution for damaged *.mdb and *.accdb files created in Access 2000 and above. Having such a tool at hand immediately after a database file corruption incident may save you a great deal of time, nerve and, of course, an ample amount of money that would otherwise be paid to third-party recovery services. With eRepair Access, you don't need to depend on anyone and entrust your Access data (often quite sensitive) into somebody else's hands. You don't have to wait. You don't have to call it a day knowing that the damaged Access file will not be restored (if at all) until tomorrow. With eRepair Access, you can be back in the game within minutes!

For more information: http://access.erepairtools.com/

If doesn't help, look here: http://www.filerepairforum.com/forum/microsoft/microsoft-aa/access/933-ms-access-database-recovery

Feb 05, 2015 | Microsoft Office Professional 2007 Full...

2 Answers

MS Access 2007 freezes when opening a basic TABLE. Please assist in resolving this frustrating problem.


You might try the "Compact and Repair" database option first before working on the database. Click on the "Office Button", then click on "Manage", then select "Compact and Repair Database". The usage dialog from there is straightforward. One that'srun, try opening the database again and opening the table as well.

Jul 15, 2009 | Microsoft Office Standard for PC

2 Answers

Steps in saving file in excel to database


severals solution :
- save file as text separated by comma and use sqloader from oracle
- use function in excel to concatenate insert order : "insert into TABLE_NAME (field1,...,fieldn) values (A1,B1,...,??n);". Save file as text with sql extension. Connect against roacle db and execute file previously saved.
- use ODBC from MicroSoft

Dec 11, 2008 | Microsoft Computers & Internet

1 Answer

Application of Pivot table & Sub total with Examples


Suppose you have a Database regarding sales of this Month inthe Column and Row Fromat with column Heading SalesPerson, Company, Product and Amount. where salesperson sales to different company different Products more than once. In this type of Database Salesperson, Company and Products appears more than once. Now you can use PivotTable to view and analyze your data in different Formats like Salesman wise COmpany wise and Productwise with different formatting REports with a facility of Preparing Charts too.

Dec 03, 2008 | Computers & Internet

1 Answer

Hyperlink function in ms access


To Create a Hyperlink Field:


Display the table in Design view, create a new field to store the hyperlinks, click the new hyperlink field's Data Type box, click the list arrow, select Hyperlink, and save the table.
To Insert a Hyperlink:

Select the hyperlink field and then click the Insert Hyperlink button on the toolbar or select Insert , Hyperlink from the menu. Either select a file you want (use the Browse button to help you locate the file) or type a Web address for the hyperlink's destination and click OK.

To edit a Hyperlink: Right-click the hyperlink and select Hyperlink , Edit Hyperlink from the shortcut menu.


Is this enough?

Dec 21, 2007 | Microsoft Office Access 2003 (077-02871)...

2 Answers

Ms access


before this u should know what is databse.
ms access has various objects likw table,form,query,report etc..
table is a object which stores the actual data and form is used to enter the data in to the table and display the data from the table, while report is object which is used to desplay your data in required formate.Query is used to fetch the data from the table in customised formate.for that u should have knowledge of SQL.

Nov 14, 2007 | Computers & Internet

3 Answers

Viewing ms Sql Server database on Access


Are you familiar with "Linking" tables in Access? In Access: File --> Get External Data --> Link Tables. This will bring up a dialog box which allows you to browse to your SQL server and select the table you want.

Aug 23, 2007 | Microsoft SQL Server Standard Edition for...

1 Answer

MS Access 2003 Development - Format Problem


Hi, the difficulty to solve your problem is that we are not familiar with Appx. I have faced this problem numerous time, but usually it was from Excel to Access. Now if you can transfer it to Excel then you can change the format in Excel to Text and import it into Access. I have also read a little of the Appx manuals and it says there that you can work with ODBC, are you using it? ODBC will create a connection between the APPX application Database and Access, you should be able to do your queries directly from the ODBC connection without the need to import the table. Here is a PDF manual of how to set it up from their website: http://www.appx.com/ftp/appx/documents/manuals/appx/appxodbc/current/appxodbc-manual.pdf I hope it helps, let me know and I will try to do my best to solve your problem. Daniel

Aug 10, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Access 2003 (077-02871) for PC Logo

Related Topics:

1,554 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2638 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18333 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...