Making a table from a query which involves the calculation of tw

Resolved · Low Priority · Version 2007

Thu 25 Feb 2010, 15:06 Delegate Phylicia said...

Phylicia has attended:
Access Introduction course

Making a table from a query which involves the calculation of tw

Hi,

I have created a table to hold data on Gift Aid Income and would like one of the fields to automatically calculate the Gift Aid Amount shown as 20/78* [Donation]. I have created a query to do this, which works, however I am unable to make a table from this query. I would also like to be able to make the results in the form of currency, which will be shown in a form.

Please advise as to a possible solution.

Many thanks

Phylicia

Mon 1 Mar 2010, 09:17 Trainer Stephen said...

RE: Making a table from a query which involves the calculation o

Hi Phylicia

Thanks for your question

Can you just clarify something for me. You say you cannot make a table form this query, what specifically is happening when you run the query?

Thanks

Stephen

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Pop up property

If you want to focus the attention of a form / switchboard to a user then you can change the propeties of a form/switchboard for Pop up to On.

This meand tht the focus for the user must be on the form / switchboard

View all Access hints and tips