making table query which

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Making a table from a query which involves the calculation of tw

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

resolvedResolved · Low Priority · Version 2007

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

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

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

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


Server loaded in 0.09 secs.