Access Database Queries
Required skills: Access, Database
I have an access database that houses all of my inventory, sales, bin locations etc etc. I need some queries created:
1. I need one that shows items that I had in stock at one time and now are out of stock. It needs to update so it takes off what I received back into stock. I need it to be printable and to show me title, full issue number, condition last know sale price, how many total I sold and then I need a column that shows me what 20% of that last know sale price would be(this is my buy price).
2. I need to know what I have in stock. I need it to be printable and to show me title, full issue number, condition and how many I have of each.
1. I need one that shows items that I had in stock at one time and now are out of stock. It needs to update so it takes off what I received back into stock. I need it to be printable and to show me title, full issue number, condition last know sale price, how many total I sold and then I need a column that shows me what 20% of that last know sale price would be(this is my buy price).
2. I need to know what I have in stock. I need it to be printable and to show me title, full issue number, condition and how many I have of each.
Posted In: |
Related projects:
Export Object Information From Access Database To Excel
follow">http://blogannath.blogspot.in/2010/03/microsoft-access-tips-tricks-working.html
http://www.edugeek.net/blogs/benrwb/661-getting-list-tables-access-database-c.html
The bidders with the low price bids would be interviewed first.
Feel free to ask for more information if you have any doubts about this project.
Thanks
http://www.edugeek.net/blogs/benrwb/661-getting-list-tables-access-database-c.html
The bidders with the low price bids would be interviewed first.
Feel free to ask for more information if you have any doubts about this project.
Thanks
C Program With Access Database
Hello,
I need a simple program with some text fields that will take a text as input and put it in a access database. Please let me know if you are interested then I will tell you more.
I need a simple program with some text fields that will take a text as input and put it in a access database. Please let me know if you are interested then I will tell you more.
Microsoft Access Database
to design and build an access database that will help me keep track of my employees, customers, batches scanned, boxes, and files. Employees will have to log in order to access the database and their login and log off hours will need to be logged. Batches, Boxes, and Files have to be unique to the customer but not to the database. I started designing the database but was unable to finish due to time. Attached is what I was able to come up with. I need something better and complete. Thank you
Access Database Needs Populated
f them and start from scratch or leave them and enter new ones.
There is a lot of different trees, scrubs and plants. I need someone to enter all of them into the database along with all the information that the database uses along with pictures. Please take your time and look over the program and its database and also research all of the trees, scrubs and plants so you will know what all needs entered.
Thank you for taking the time to look into this project.
Happy Bidding!
There is a lot of different trees, scrubs and plants. I need someone to enter all of them into the database along with all the information that the database uses along with pictures. Please take your time and look over the program and its database and also research all of the trees, scrubs and plants so you will know what all needs entered.
Thank you for taking the time to look into this project.
Happy Bidding!
Ms Access Database 2
I want to create a new database for my personal use...
Additional Info (Added 3/21/2011 at 0:58 EST)...System Message: This is a reposting of project MS Access Database (1299369860).
Additional Info (Added 3/21/2011 at 0:58 EST)...System Message: This is a reposting of project MS Access Database (1299369860).
Microsoft Access Database Setup
on at some point in php/mysql.
We need the same thing done for directory submissions, press release submissions, video submissions, forum profiles and comment, so from on the main project details screen it will have these as buttons which then links the info.
Basically this will aid our company so we know the exact submission stage for each site and so do our clients.
You need to have excellent skills with MS Access,
Thanks
John
We need the same thing done for directory submissions, press release submissions, video submissions, forum profiles and comment, so from on the main project details screen it will have these as buttons which then links the info.
Basically this will aid our company so we know the exact submission stage for each site and so do our clients.
You need to have excellent skills with MS Access,
Thanks
John
Access Database Debugging And
s made as follows:
1)add a section where I can make notes in point form
2)add a section where I can make a list of clients that I can print out
3)add a formula that will be able to calculate labor% I will be providing the formula
4) have the ability to print the entire database in a way the is economical in terms of the amount of paper
Please find the attached database. Also I am open to suggestions on how to get a more efficient database.
1)add a section where I can make notes in point form
2)add a section where I can make a list of clients that I can print out
3)add a formula that will be able to calculate labor% I will be providing the formula
4) have the ability to print the entire database in a way the is economical in terms of the amount of paper
Please find the attached database. Also I am open to suggestions on how to get a more efficient database.
Ms Access Database
manager email address
developer name
developer email address
Manager name
Manager email address
once tables are created
We'll create (quesry)reports for distribution to the email address of the project manager, manager, customer or developer
Create and save a query that pulls all the company names from the project number and customer name and project manager fields
other reports or queires may be required in the future.
developer name
developer email address
Manager name
Manager email address
once tables are created
We'll create (quesry)reports for distribution to the email address of the project manager, manager, customer or developer
Create and save a query that pulls all the company names from the project number and customer name and project manager fields
other reports or queires may be required in the future.
Build Access Database, Forms, Queries
xt, number)
Scope:
We would like to complete the project in 3 phases, once scope is narrowly defined.
1. Initial Build
2. Review/Modification Round 1
3. Review/Modification Round 2
If necessary, additional small changes may be required.
Workspace:
If necessary, you will be provided with a Virtual Host to complete your work.
Compensation:
We are open to Fixed Rate and Hourly compensation terms.
Scope:
We would like to complete the project in 3 phases, once scope is narrowly defined.
1. Initial Build
2. Review/Modification Round 1
3. Review/Modification Round 2
If necessary, additional small changes may be required.
Workspace:
If necessary, you will be provided with a Virtual Host to complete your work.
Compensation:
We are open to Fixed Rate and Hourly compensation terms.
MS Access database testing and feedback (re-post).
ccess and via a Gmail account is my ideal result (Can Access handle POP/IMAP in that way?). I have experience managing mail campaigns in SAS.
I realise I'm not on a huge budget, so I'm not asking for you to rebuild the database. I expect it will probably take you a few hours to check it over and produce a document with your feedback, followed by an email exchange over the course of a few days for any clarification or questions.
I realise I'm not on a huge budget, so I'm not asking for you to rebuild the database. I expect it will probably take you a few hours to check it over and produce a document with your feedback, followed by an email exchange over the course of a few days for any clarification or questions.
MS Access database testing and feedback.
eting and notifications (mail merge). Populating and sending an HTML email template within Access and via a Gmail account is my ideal result.
I realise I'm not on a huge budget, so I'm not asking for you to rebuild the database. I expect it will probably take you a few hours to check it over and produce a document with your feedback, followed by an email exchange over the course of a few days for any clarification or questions.
I realise I'm not on a huge budget, so I'm not asking for you to rebuild the database. I expect it will probably take you a few hours to check it over and produce a document with your feedback, followed by an email exchange over the course of a few days for any clarification or questions.
Reports & Queries created for Access Database
ll be ignored
Additional files submitted: (Files are only available for logged in users)
Negotiation_Weekly.doc
Additional files submitted: (Files are only available for logged in users)
Negotiation_Weekly.doc
Upload An Access Database
An access database needs to be imported into MySql for the website theggg.org - some tables are already imported - it will be accessed from the page http://theggg.org/NARASEARCH.asp
Translation Access Database
Looking for an expert in MS Access to develop a translation database.
MS Access Database for Report Card Generation Needed (google
long it could take
Let us know and we can provide further details as to what entities are needed to be accounted for and we can provide all the details about the relationships between those entities. I'm attaching a copy of a report (that we're currently doing for the most part manually) to give you an idea of what is our expectation on what the system is supposed to turn out.
Thank you, and we hope to hear from you soon
Let us know and we can provide further details as to what entities are needed to be accounted for and we can provide all the details about the relationships between those entities. I'm attaching a copy of a report (that we're currently doing for the most part manually) to give you an idea of what is our expectation on what the system is supposed to turn out.
Thank you, and we hope to hear from you soon
Betfair data scrapping into MS access database
am-GB-Chl into columns that specify the horse, trainer, jockey, finishing position and the in play highs and lows etc. This is just one race meeting for the day, there are frequently more than one every day.
You can use macros or any other GUI, I just need to be able to specify a date range, eg 2011, and be able to download this range of data into access. I have attached an example of how I want the data to look like in access.
You can use macros or any other GUI, I just need to be able to specify a date range, eg 2011, and be able to download this range of data into access. I have attached an example of how I want the data to look like in access.
Access Database - Document Control and Item Tracking
2 - Create/modify Transmittal - Select Drawings/by ARNS/other filters
3.3 - View transmittal Details
3.4 - Transmittal history for a particular drawing etc
4. Work Orders/QA
4.1 - View all work orders
4.2 - Create/modify work order
4.3 - View QA for a particular Work order (showing status of each stage)
4.4 - View Work order details
4.5 - Work order history for a particular work order (any modifications etc)
3.3 - View transmittal Details
3.4 - Transmittal history for a particular drawing etc
4. Work Orders/QA
4.1 - View all work orders
4.2 - Create/modify work order
4.3 - View QA for a particular Work order (showing status of each stage)
4.4 - View Work order details
4.5 - Work order history for a particular work order (any modifications etc)
Access Database - Document Control and Item Tracking
2 - Create/modify Transmittal - Select Drawings/by ARNS/other filters
3.3 - View transmittal Details
3.4 - Transmittal history for a particular drawing etc
4. Work Orders/QA
4.1 - View all work orders
4.2 - Create/modify work order
4.3 - View QA for a particular Work order (showing status of each stage)
4.4 - View Work order details
4.5 - Work order history for a particular work order (any modifications etc)
3.3 - View transmittal Details
3.4 - Transmittal history for a particular drawing etc
4. Work Orders/QA
4.1 - View all work orders
4.2 - Create/modify work order
4.3 - View QA for a particular Work order (showing status of each stage)
4.4 - View Work order details
4.5 - Work order history for a particular work order (any modifications etc)
Creating a database in Access using queries, reports, forms
Creating a database in Access using queries, reports, forms etc.
Convert MS Access Database to MySQL Tables
ust have a few tables to go so need somebody who can do this work today.
I also need help with the tables that have been imported. They were imported as duplicate tables like if i had students table originally in mysql then we made another called students2 for the new imported ms access data.
Now I want to copy the data from students2 to students which is pretty easy.. just need to match the fields i want to bring across.
I also need help with the tables that have been imported. They were imported as duplicate tables like if i had students table originally in mysql then we made another called students2 for the new imported ms access data.
Now I want to copy the data from students2 to students which is pretty easy.. just need to match the fields i want to bring across.
