Phoenix - Your AI AssistantMicrosoft Access Report Fix (Query + Grouping + Formatting)
- Posted:
- Proposals: 3
- Remote
- #4491133
- Open for Proposals
have already sent a proposal. Description
Experience Level: Entry
Hi,
I’m looking for an experienced Microsoft Access specialist to help fix and optimise an existing report system linked to an Excel data source.
The database is already built, but there are a few issues that need to be resolved properly and cleanly.
Scope of work:
Fix query issue causing parameter prompts (field mismatch)
Ensure correct data types and stable query structure
Update report grouping to:
Group by Date
Then by Operator
Sort by Route Order
Format date to long format (e.g. Sat 25 April)
Remove unwanted row shading (grey fill)
Ensure report displays 4 records per page
Add pagination per group (e.g. Sheet 1 of X per Operator/Day)
Ensure system works reliably with weekly Excel updates
Important:
Must be clean, simple, and reliable (no fragile setup)
Must work consistently with updated Excel data
Experience with Access reports and Excel-linked tables required
Deliverables:
Fully working Access file
Clean query and report structure
Brief explanation of changes made
Timeline:
ASAP (preferably within 2-3 hours
I’m looking for an experienced Microsoft Access specialist to help fix and optimise an existing report system linked to an Excel data source.
The database is already built, but there are a few issues that need to be resolved properly and cleanly.
Scope of work:
Fix query issue causing parameter prompts (field mismatch)
Ensure correct data types and stable query structure
Update report grouping to:
Group by Date
Then by Operator
Sort by Route Order
Format date to long format (e.g. Sat 25 April)
Remove unwanted row shading (grey fill)
Ensure report displays 4 records per page
Add pagination per group (e.g. Sheet 1 of X per Operator/Day)
Ensure system works reliably with weekly Excel updates
Important:
Must be clean, simple, and reliable (no fragile setup)
Must work consistently with updated Excel data
Experience with Access reports and Excel-linked tables required
Deliverables:
Fully working Access file
Clean query and report structure
Brief explanation of changes made
Timeline:
ASAP (preferably within 2-3 hours
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Is this the job posted yesterday by John D with a budget of £365?
Job No 4490894
I have a very simple Microsoft Access Report that I want to create
It has one linked Excel table that I will update weekly
I have created a MS Query Weekly Crew Sheet Query
And then created a report to run off the Weekly Crew Sheet Query
But when I add groupings it doesn't report any data
I would like it to group the calls
By Date
By Operator and then sort each day by route order
I currently have a version that looks like this but I want to simplify the system
Can you help and what do you recommend
If so I already have a prepared answer and budget