Converting Excel table with formulae to Access for reports and forms

[ScottlyRM]

Hi all,

Having a little trouble converting an Excel table into an Access table. I think the problem is with the formula and the way they're incompatible in access...
I wondered if anyone had any thoughts on a work around.

Essentially its a list of financial information with equations to sort out NET, VAT and Total values with discounts, as well as a few date fields which relate to the date payment is due etc.

I need a simple form for my colleagues to fill out each time they need to submit info, with a back end which works out the VAT dates etc. All of this is pretty basic arithmetic and standard opperators (+, -, * or / with parentheses) except the date valuse which uses the EDATE function to add months onto a date.

Ideally I would like to copy/translate my excel formula into access and then import the historic data. Or find a way to have an Access form add info to the table.



Any work arounds/ideas welcome!

Thanks in advance.

[June7]

The first question you have to answer is 'Do I need Access for this requirement?' Do you want a relational database? If you want to maintain historical records, then yes, sounds like you do. In which case the question is 'Do I need Excel as a component of this requirement?' If not, then import the raw data into Access table and then build queries, forms, reports to manipulate the data. You will have to recreate the calculations. Instead of EDATE, explore DateAdd function.