The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

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

Resolved · Low Priority · Version 2007

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

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

For upcoming training course dates see: Pricing & availability

ReplyMon 1 Mar 2010, 09:17Trainer 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

Access articles

· Find Out About The Join Property In An Access Query
· Understanding The Components Of Access
· Practice Microsoft Access Database Decorum To Reap The Rewards
· How To Understand Access As A Relational Database
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!

Please browse our web site to find out more about
access/courses and other Microsoft training courses.

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips

Could someone explain howthe code below work. I can't understand various bits such as 'Open file for Binary', 'Get #1', 'Print #2' etc. Any help in deciphering this greatly appreciated

Sub output_sc4_file_east_west(mode, scenario)

'macro to read t..

» Forum post: Access vba code

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions