I have a field that was populated from the following look-up list - Forcast/Concept;Sources Sought;Sources Sought Submitted;Awaiting RFP;Proposing;Submitted for Review;Drop;Won;Lost. I need to print a report in the following order:
Forecast / Concept
Sources Sought
Sources Sought Submitted
Awaiting RFP
Proposing
Submitted for Review.
and the report excludes the last three in the list (drop - won - lost)
Since the field data is being selected from a list and not a table I can't come up with a good way to sort the report for printing in the correct order. There is a second sort order by bid date after the sort criteria above is chosen. .
From what you are describing I would suggest setting up another table with the fields in the list and sort_order. Then link up this table with the table with the data to sort.
For the past 15 years I have worked with Excel/MS Access and 11 years with MS SQL Server 7.0 and 2005. I have been doing my contracting work with VWorker/Freelancer for the past 3 years; during that time I have completed 70 projects ranging from Excel/Access VBA to SQL Server database constructions. In my experiences over the past 3 years I know how daunting it is to try and describe what you are wanting along with sifting through numerous bids. As you can see from my reviews I strive to make sure my customers are happy with my services. I take a lot of pride in my work and stand behind anything I create so if you ever encounter a problem just email me Please feel free to ask any questions I am always willing to share my experience.
Best of luck with your search.
Michael
p.s. I am based in Phoenix AZ, MST, in case you would like to call and discuss.
$45 USD in 1 day
5.0 (37 reviews)
5.0
5.0
15 freelancers are bidding on average $39 USD for this job
Greetings Client
I will be able to help you with this project.
I have over 7 years of experience in excel,access,vba automation and database development and management.
I will be able to provide you with accurate and
project result
Regards
Mukul
Hi John3588,
I'm an experienced Access/VBA developer interested in your project. This looks like a straightforward and quick fix which I would be more than happy to undertake!
Hi, I have a great deal of experience developing applications with MS Access, and would have no trouble creating the report you are interested in. Thank you.
I feel fully capable of extracting and sorting your data to the desired output. With 12+ years of daily Access experience, I see no issues with turning the project around in a timely fashion.