AICT may/june 2010 paper 2

[blackberry]

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

thanxx in advance!!

[Monopoly]

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.

[blackberry]

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!!!!