Calculated Field

[aussie]

Hi,

When I make a calculated field on a form eg: [AmountBilled]-[ReceivedFrom]
the form stops me from adding new records. I have tried to make a query with the calculation and then base the form on that, but I still get the same result.
Can anyone help?:banghead:

 

[RainLover]

Looks like it maybe the query itself not the Form.

Can you add records to your query.

If you are using SQL Statements then convert to a Query until you sort the problem.

You can go back to SQL later if you want.

 

[aussie]

When my query didn't allow me to add new records I tried to set the default value in the table to :
[AmountBilled]-[ReceivedFrom] but it didn't work in the table.

If I go to the table I can add new records, but I can't add in the query - don't understand why.:banghead:

 

[RainLover]

Is this just a Standard Select Query, or is it an Append, Update or Totals?

 

[aussie]

It is just a standard query made using the query wizard, then entering the formula into one field.

I don't know how to make it an Append, Update or Totals

 

[RainLover]

Aussie

I think the penny has droped. You are using 2007 or 2010 where you can do this in the Table. I have never used this feature.

Suggest you delete the Calculation from the Table then add in to the query as a new field.

I Could be on the wrong track. As I said I do not use 2007,2010