How to Sum Total Acquisition Costs

How to Sum Total Acquisition Costs

Use the find feature to locate and isolate groups of records. You need some way to identity records as a group so an example might be to right click in the Medium field and choose Find Matching Records for Mixed Media. That will find and display only records with Mixed Media in that field. 

Once you have the group of records you want isolated you will need to export the Cost field to find the total acquisition cost since we don't currently have a report that reports on cost. Just Value. 

To do that:

1. Go to File/Export Records.

2. Select the file type. If you choose Excel you can use that to calc the total cost

3. Set the Dropdown on the left to Current Table (MyArt) and Choose Cost to move to the right. 

4. Click Export.

5. Open in Excel and calc total. 

Unable to Export as XLS

Use the File/Export Records command.

1. go to File/Export Records.

2. Select the file type.

3. Set the Dropdown on the left to be Current Table (MyArt)  and Choose fields to move to the right. to be in your excel file.  

4. Click export.

5. Open exported file in Excel.

Upgrading from one version of My Art Collection 2.0 to another.

Upgrading from one version of My Art Collection 2.0 to another.

There are three versions of My Art Collection from which to choose.  You may want to upgrade from one to the other. 

On the My Art Collection version from which you are upgrading:

● Launch the version of My Art Collection from which you are upgrading.

● Go to File/Save a Copy As and save a copy of the MyArt.MA2 data file to your desktop. (Name the MyArt.MA2 data file MyArt_TodaysDate.MA2 or something else unique.

New My Art Collection Version:

● Install My Art Collection 2.0  (Adv or Professional)

● Launch My Art Collection 2.0  (Adv or Professional)

● Go to File/Import from My Art Collection 2.0

● When prompted locate the file MyArt_TodaysDate.MA2 on the Desktop.

● Choose to Add Records.

● The data will be imported.

How to Isolate a Found Set to Generate a Report

To isolate a found set for a report you will do the following:

1. Go to The Art List. 

2.Click the Find Button. 

 

3. Add your search criteria.

4. Hit the Return/Enter Key.

5. Your search will be returned.

6. Go To Reports.

7. Choose a report. 

8. When asked if you want to build a report for All or your Current found set Choose "Current"

Utilizing Bar Codes to Record and Find a Stored File

Utilizing Bar Codes to Record and Find a Stored File

We don't print bar codes out of the system, but a bar code reader is just an input device like a keyboard. If you have barcodes you can scan them into the tracking number field and store the number from the bar code there. Then you can find a file the same way by entering Find mode and scanning the bar code into the tracking number field and hitting enter. That will return the record with that bar code number assigned to it.