Access Dynamic Crosstab Report

I need a dynamic crosstab report for invoicing designed by someone experienced. I believe this task will require VB at some point.


The crosstab columns (services) and rows (dates) are always going to variable. The date and customer ID values are fetched from the form to generate a crosstab query and a report. Since the values are always variable, I'm struggling to create a template.

I need this to be done within 5 days as it is not a massive task. But I need explanation (informal) as how this task was accomplished.

This is a part of an ongoing project. If successful there will be more work to follow immediately.

Thank you.

Evner: Microsoft Access, Visual Basic

Se mere: microsoft project template, dynamic services, template report, microsoft template access, report variable, create access template, customer report, access create query, access create report, customer template access, microsoft access invoicing, access invoicing template, report dynamic, task create access, someone dynamic, access rows, report generate, access crosstab query values, microsoft access point, crosstab query access values, crosstab query access, generate report, dynamic form project, access generate unique report, informal report

Om arbejdsgiveren:
( 0 bedømmelser ) NOTTINGHAM, United Kingdom

Projekt ID: #5987292

17 freelancere byder i gennemsnit £35 på dette job


Hi, the only way you can achieve this is by building a SQL string to generate the data that gets stored in a temporary table (using the form handle will always give you a unique number). This is far more difficult t Flere

£150 GBP in 3 dage
(23 bedømmelser)

Hey Pione3r, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality Flere

£29 GBP på 1 dag
(30 bedømmelser)

Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft database Flere

£32 GBP in 3 dage
(10 bedømmelser)

Databases expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: [url removed, login to view] Lollipop (video demonstration) [url removed, login to view] and feedback a Flere

£20 GBP in 2 dage
(16 bedømmelser)

Hi, in which format are your data stored? In Excel / Access? .

£20 GBP in 3 dage
(6 bedømmelser)

Hello I'm a software engineer with good knowledge in access database I can do this for you. ready to discuss, best regards hossein

£18 GBP på 1 dag
(7 bedømmelser)

i have an exp in vb6 of 6+ years ............... i can do your task............ PM me with all details............

£23 GBP på 1 dag
(7 bedømmelser)

Experienced software architect with 20 years in design, development and maintenance of applications. Good in working with Access

£30 GBP in 2 dage
(2 bedømmelser)

Sir/Madam, Greetings. This is an IT person and an experienced MS Access database developer.I have done many such academic tasks of IT with corresponding write ups . Send me the database and let me know your desi Flere

£18 GBP på 1 dag
(4 bedømmelser)

Még nem kapott javaslatot

£23 GBP in 3 dage
(0 bedømmelser)

Dear Sir, I am an experienced developer for stand alone projects (VB and MS Access) and web applications (php, MySQL, CSS, JS/Mootools, HTML). I have created more than 25 different custom databases for clients Flere

£18 GBP in 2 dage
(0 bedømmelser)

Dear Sir/Madam I have been in this industry for 6 years and such jobs are my daily practice. This is my first time on this site and hence you can see that I do not have any ratings/testimonials to show you. I Flere

£23 GBP in 5 dage
(0 bedømmelser)

I am ready to do the job for you and I can do it nicely and in time with very good quality and accurate work.

£57 GBP på 1 dag
(0 bedømmelser)

Hi I am an ACCESS SPECIALIST with 15 year experience writing VBA. This will definitely require VBA. My solution would be to write a routine that would use a record set process to provide what you are after. I wou Flere

£23 GBP på 1 dag
(0 bedømmelser)

I can do this in .NET. I will give you options to export the data to PDF, WORD or excel too along with this I will gie u the option to represent the information in Graphical view

£20 GBP in 5 dage
(0 bedømmelser)

I have total 13 years of experience in IT which include both software development and web development. I have great experience in managing projects with USA/UK based clients and I manage my work shift timing as per cli Flere

£55 GBP på 1 dag
(0 bedømmelser)

Hi, I have gone through your requirement and would like to work on this with you. Hope to hear from you soon Techno Verstand

£18 GBP på 1 dag
(0 bedømmelser)

Hi, VB data reports is good tool but it does not have crosstab support. Crystal reports and Microsoft Access both are best solutions for such type of complex reporting. Although complex reporting entirely depends up Flere

£28 GBP in 2 dage
(0 bedømmelser)