Suoritettu

Export of Access crosstab queries to Excel, then create chart

1. We require an export of Access crosstab query to Excel, then create an Excel chart from the data.

See the attached test Access file - the user will use frmReport to generate the report.

There is a sample output: [url removed, login to view]

2. The crosstab query needs to be modified so that the months are in date order from left to right

3. The solutuion must be generic for any crosstab query. If you need to attach parameters to specific queries, then implement this in the table zstblReport, by adding columns as necessary.

Note: the number of columns will change depending on the date range the user has selected

4. Must be done using Access/Excel/Office 2003

## Deliverables

See attached files

Taidot: Microsoft, Microsoft Access, Visual Basic for Apps, Windows Desktop

Näytä lisää: export crosstab query excel, access export crosstab query excel, excel crosstab query, access export crosstab query table, export access excel chart, access crosstab report export excel, crosstab query export chart, excel create chart access crosstab query, range query, generic excel, generic data access, create a table chart, microsoft excel test, microsoft access test, queries, export from excel, create an excel, excelchart, excel access table, report chart

Tietoa työnantajasta:
( 44 arvostelua ) Auckland, New Zealand

Projektin tunnus: #3512597

Myönnetty käyttäjälle:

Prashantskin

See private message.

$59.5 USD 14 päivässä
(486 Arvostelua)
6.9

4 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

qualityprof101sl

See private message.

$76.5 USD 14 päivässä
(2 arvostelua)
1.9
mmbeng

See private message.

$34 USD 14 päivässä
(0 arvostelua)
0.0
titokhan

See private message.

$85 USD 14 päivässä
(0 arvostelua)
0.0