Calculated Fields

[Sherly25]

Hi,
I have an excel document which calculates my invoices. and I want to transfer everything to Access, but I have the following problem. When I try to calculate a field using the expression builder on my query I don't get any answers. I tried many ways and nothing works. An example of what I want to do is the following. Add two fields, then divide them by 144. In a sense: [Plotting Invoice]![Check] + [Plotting Invoice]![Issue] / 144. This code worked but is no longer working. I have 5 diferrent calculations, but all of the same nature.

Sher

 

[scriverb]

The syntax is correct so I need a little more information. Are you importing the Excel documents into ACCESS and then using a query to manipulate the calculations? Or, are you linking to the excel documents and performing the calculations in the query using the data directly from Excel.

Why don't you post your SQL for the query and answer the above questions and let's see if we can help you.

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???