Search results

Our databases were functioning until last week, but to-day our queries are not working. Could you please advise me how to get our queries to filter our records again? Do you have any suggestion for restoring our toolbars? Thank you, Fabiola

I tried to change the value from Currency to Numeric, but the math error continues. Original formula =Sum(Nz([Stop_Current])-Nz([Current_Price])) Second choice formula =Sum(Nz([Stop_Current], 0)) - Sum(Nz([Current_Price], 0)) A = calculaction is wrong B = the calculation in the DIFFERENCE...

Could I please have a suggestion to fix this Query. IIf([Transaction_Type]="Sold_$", [CRA_Settlement_Amount] - [Book_Value], Null) and [CRA_Settlement_Amount]-[Book_Value] What we are trying to accomplish is; If the Transaction Type is "Sold_$" then the Transaction_Total is copied from the...

We have a MsAccess 2003 database that contains our reports that are currently printable by month, that we STILL WANT to use. How can we ADD the report selection “ALL” months so that we will then have a report for all 12 months? Your suggestions are appreciated? Thank you. Crystal

Until about October this report was being printed properly. But someone changed something and now the report is not being printed properly. Any assistance will be appreciated. Crystal

Every month we receive an Excel Spreadsheet that we import into our MsAccess Database table “ RBC “ Can I please get a suggestion on how to; Rename Table RBC_D to RBC_To-Day’s date Rename Table RBC_C to RBC_D Rename Table RBC_B to RBC_C Rename Table RBC_A to RBC_B Rename Table RBC to RBC_A...

We are preparing to upgrade some of our MsAccess 2003 Databases and would like to review the field information being used in 2 fields. Could I please receive a suggestion on how to print two objects within the table Field Names Data Types Thank you. Crystal

We are developing a database that will perform four comparisons each day. My idea was that each table would contain about 36 different fields except for one common field, the part number (identifier / common Key). Table A would contain the part number and other product information. Table B...

I / we have been trying to add a new grouping “Watch” for some time without success. The export group “Holdings”, works, but we cannot get the group “Watch” to work. Your suggestion will be appreciated. Crystal

I have not been able to solve our calculation problem “IF” the Net Share Cost has a value of $0.00. (If the Net Share Cost is BLANK or $0.00, it means that this stock has / was not purchased. Your suggestion will be appreciated. Problem – Field = Percentage_PC...

As of January we will be receiving daily data on about 100 items, which can be in a in a CSV or Excel format. Our intention is to store this information for comparison purposes and historical comparison in a MsAccess database. Should we receive the data in a CSV or Excel format? If the data is...

Current format Data Type – Currency Format - $#,000\.00 Decimal Places- 2 Results - $1763,00. (note the trailing decimal) = = = Would like - $1,763.00 (without the trailing decimal) Thank you Nicole

We are getting ready to upgrade our MsAccess databases and would like to have advice on the formatting of the fields that we have been using for years. Attached is the different formats in our MsAccess 2003 database(s) and I would appreciate suggestions on if and how I should change the field...

We have 3 Excel Spreadsheets with 24 columns on each sheet. Can we have 72 fields containing this data for ONE item on a Ms Access 2007 form using Tabs? Thank you. Crystal

Can we print one MsAccess 2003 report with two criteria’s? Start the report by Currency if Trade is “PURCHASED” Continue report by Currency if Trade is “WATCH” and investigation is “YES” We have tried many combination reports and would appreciate your suggestion. Otherwise we will continue to...

Hello. Could we please receive assistance in fixing our Access 2003 form to show the Percentage change in values? The formulas that we have tried do not work. If the SHARE COST has NO VALUE a percentage is not required. Thank you. Crystal

Could we please have a suggestion for the best way to copy a record from one field in a MsAccess 2003 table to another field in the same table? We have a calculated field aclled = AverageShareCost with the following calculation =[Bought_Drip_Dollars]/[Bought_Drip_Quantity] The value of this...

The charity where I volunteer had a custom Database Linked to their Windows 3.1 Accpac Program in 1994. Over the years it has been modified more than many times. Can I please receive a suggestion on where I can purchase a MsAccess 2007 Program to run our Accounting programs as we do not want to...

Person needed to update a Web Scraping Program using Beautiful Soap. I am not sure if this is the proper forum to post this project. Nicole

Could I please receive assistance with this Query with 4 criteria’s? If Stock_Name “Is Not Null” And if Currency is "CAD$" and or if Trade is "Purchased" and or if Investigate is "Yes" Then all of these matching records will be printed. Thank you. Nicole