Appending data imported

The UK's most regular instructor-led training courses.
Training information: 2003 access micorosft training · Microsoft.access.courses · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2003

3 posts

ReplyWed 22 Jul 2009, 13:56Delegate Louise said...

Louise has attended:
Access Introduction course
Access Intermediate course

Appending data imported

If I am importing Data from Excel can I add an additional field to create Flags to identify different types of customers for example VIPs or Emailable. Yes/No

Louise

Version	Date	Location	Places available	Book	Next place rate (£)		List price
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice	List price
2007	Tue 3 Aug 2010	Bloomsbury	1		£215	£220	£235
2003	Fri 20 Aug 2010	Bloomsbury	7		£190	£195	£235
2007	Fri 27 Aug 2010	Bloomsbury	9		£180	£185	£235
2010	Thu 16 Sep 2010	Bloomsbury	7		£250	£255	£299
2007	Wed 29 Sep 2010	Bloomsbury	8		£176	£181	£235
2003	Fri 8 Oct 2010	Bloomsbury	10		£142	£157	£235
Full Schedule: See all 35 Access Intermediate course dates. Bookings currently available until 28th September 2011.

2,024 posts

ReplyThu 23 Jul 2009, 13:10Trainer Amanda said...

RE: Appending data imported

Hello Louise

Thank you for your question and welcome to the forum.

Presumably the data imported from Excel is stored in a table, in which case you can add fields and specify their settings using Table Design view.

I hope this helps.

Kind regards
Amanda

· Innovation with Microsoft Access
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· An Introduction To Queries In Access
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· Making The Transition To Access - Why You Might Need It

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

Access tip:

Calculating The Difference Between Dates

If you wish to calculate the time between two date fields, this can be done in a number of ways:

1. As a calculated field in a query
2. As a calculated control in a form or report
3. As a calculation in a VBA procedure.

The basic syntax to get the number of days between two dates is:

=[One Date Field] - [Another Date Field]

You can also use one of the following functions:

=Month([One Date Field] - [Another Date Field])
which calculates the number of months between the two fields

=Year([One Date Field] - [Another Date Field])
which calculates the number of years between the two fields.

Another function is the DateDiff() function.

It uses an argument to determine how the time interval is measured. For example:

=DateDiff("q",[One Date Field] - [Another Date Field])
returns the number of quarters between the two fields.

Other intervals that can be used in this expression are as follows:
"yyyy" - Years
"m" - Months
"d" - Days
"w" - Weekdays
"ww" - Weeks
"h" - Hours
"n" - Minutes
"s" - Seconds