IGCSE/GCSE/O & A Level/IB/University Student Forum

Qualification => Subject Doubts => GCE AS & A2 Level => Miscellaneous => Topic started by: blackberry on November 26, 2010, 07:21:21 am

Title: AICT may/june 2010 paper 2
Post by: blackberry on November 26, 2010, 07:21:21 am

Can someone please tell me how to solve the 9th question???!!!

thanxx in advance!!

Title: Re: AICT may/june 2010 paper 2
Post by: Monopoly on November 26, 2010, 08:09:46 am

u can export the data in excel then use mid or left function to extract the codeand print after all the points asked in the question are done.

or

in access perform a query using the JXCust table. In the design view, on a black column, enter in the following format:
fieldname: Mid([CustomerID],1,1)
or
fieldname: Left([CustomerID],1)

this will seperate the customer types and then create a report basing on this query.

Hope it helps.

Title: Re: AICT may/june 2010 paper 2
Post by: blackberry on November 26, 2010, 08:54:49 am

Quote from: Monopoly on November 26, 2010, 08:09:46 am

u can export the data in excel then use mid or left function to extract the codeand print after all the points asked in the question are done.

or

in access perform a query using the JXCust table. In the design view, on a black column, enter in the following format:
fieldname: Mid([CustomerID],1,1)
or
fieldname: Left([CustomerID],1)

this will seperate the customer types and then create a report basing on this query.

Hope it helps.
thanxxxx dewd!!!!