Find Jobs
Hire Freelancers

Create a query in ms access2013 based on multiple tables

$10-30 USD

Terminado
Publicado hace más de 8 años

$10-30 USD

Pagado a la entrega
I am new to MSA2013 and have difficulties in creating the query that does what I want. I want to retrieve a sum of sales and expenses that I have recorded in various tables. The tables that I used are as of below 1) Primary table Table name: USERS This table contains following: a) a unique key reference (user ID, primary key) b) Last name of the user c) First name of the user 2) Secondary table I a) a unique key reference (user ID, primary key) b) Date field with short date (YYYY/MM/DD) c) Payments received (Currency) 3) Secondary table II a) a unique key reference (user ID, primary key) b) Date field with short date (YYYY/MM/DD) c) Expenses (Currency) 4) Secondary table III a)a unique key reference (user ID, primary key) b) Date field with short date (YYYY/MM/DD) c) Donations received (Currency) The secondary tables (I & II & III) are used to record payments received, Expenses and Donations, that a certain user has been linked to. The query that I want to create shall retrieve only the sum of each secondary table that match a certain date. The query shall not list users that have received payments, recorded expenses or received donations on a certain date. The query shall only return the sum of each secondary table that matches a certain date. For examples below Secondary Table I Date USER ID Payment received 2015/03/01 1 10.00 2015/03/01 4 15.00 2015/03/10 7 20.00 Secondary Table II Date USER ID Expenses 2015/03/01 2 5.00 2015/03/01 8 10.00 2015/03/05 12 30.00 Secondary Table III Date USER ID Donations 2015/03/01 3 20.00 2015/03/05 6 5.00 2015/03/10 9 15.00 So when the query is created following should happen. 1) I start the query and a dialog box pops up "Please enter a date" 2) I enter for example, 2015/03/01, then the query should return below Payments received 25.00 Expenses 15.00 Donations 20.00 SUM 60.00 If I would enter 2015/03/05 the result should be: Payments received 0.00 Expenses 30.00 Donations 5.00 SUM 35.00 Could anyone please help me on how to create this query in MSA? I have tried many times, but the result returned is not correct. The query seems to return correct totals only when all three tables contains a value on the entered date, or the query returns an empty result when one of the table does not have a match for the requested date (but the two other has).
ID del proyecto: 8868522

Información sobre el proyecto

27 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hi, I have gone through your project details of MS Access and would like to take an opportunity to work on it. I have created several queries of simple and complex nature and can help you out with the required query you need on the tables you mentioned. For more details and have a look on existing MS access db file, I would like to chat and plan out further. Waiting for your response on the same. Thanks.
$25 USD en 0 día
4,8 (162 comentarios)
6,3
6,3
27 freelancers están ofertando un promedio de $22 USD por este trabajo
Avatar del usuario
Closed tickets requiring waiting on partsHi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. In my portfolio look at the screen of "Create sales and purchases database application". You will find the similarity.... Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$30 USD en 1 día
4,7 (75 comentarios)
6,5
6,5
Avatar del usuario
I have expertise in SQL. I can provide solution.. Please feel free to communicate......... Thank you...
$25 USD en 1 día
4,9 (24 comentarios)
5,9
5,9
Avatar del usuario
I am expert in ms access, I can develop query as you requested. Please contact me. I am ready to start now
$30 USD en 1 día
4,7 (24 comentarios)
5,9
5,9
Avatar del usuario
I am sql expert certified by Oracle corporation and I can easily make such queries
$20 USD en 1 día
4,7 (40 comentarios)
4,8
4,8
Avatar del usuario
I've got lots of experience writing queries with the joins to other tables you mention. You will probably need to or three queries rolled into one to get the result but it's easily acheived. Let me know if you have any questions. Adam
$20 USD en 1 día
4,9 (7 comentarios)
4,7
4,7
Avatar del usuario
Bis jetzt wurde noch kein Vorschlag eingegeben
$20 USD en 3 días
5,0 (8 comentarios)
4,3
4,3
Avatar del usuario
Hi. Would be glad to help you with this project. Regards, Yuri .
$25 USD en 1 día
4,9 (22 comentarios)
3,9
3,9
Avatar del usuario
Hi I can help you with this query. Shortly about myself: 15+ years SQL experience. Also, in your table description you wrote (for secondary tables) UsedID is a primary key? It cannot be correct i guess. Please contact if interested regards, Yevgeny
$15 USD en 1 día
5,0 (2 comentarios)
3,4
3,4
Avatar del usuario
Hi, I have plenty of experience working with writing queries in MS acess and SQL platforms. This can be done using right joins. Basically main table needs to be left joined with others. I hope you will definitely give me a chance. Thanks, Ritika
$15 USD en 1 día
5,0 (1 comentario)
0,4
0,4
Avatar del usuario
Aucune proposition n'a encore été fournie.
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
i can provide you with the solution to your problem as i have in MSA. Your problem is not as much as easy it seems to be.
$13 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have experience in design and creation of database I have worked for over 11 years at the request of this type.
$30 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$10 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Dear Sir, I have read your Project Descriptions. I am willing to help you to create the query in MSA. As I am expert in SQL and MSA. So, I am waiting to hear from you to start the task immediately. Thanks a lot for your valuable time. I am waiting for your quick response.
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
All you have to do is create a new table, drag what you want to see, then dump it into excel. From there you can filter on the date column, then create a pivot table to see the dates that you need per user id. Let me know if that works for you.
$10 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Good Afternoon I am an expert in Busines Management with Masters degree in Finace, with more tan 8 years of experience. I use MSA to control my bussines income an expenses. I already made a test database with your 4 tables and managed to create the desired query. I worked in MSA2010, but I can deliver the result in MSA2013 if needed. I created an sql sum and union query with date parameter imput, to display the sum of Payments, Expenses, and Donations by the date required. I am doing this job because i need to create reputation on the freelancer site. I will be glad to have a contact to discuss the details. Thanks Guillermo Velutini
$10 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have over 15 years of experience and I am sure that this is pretty easy and I can deliver it to you same day.
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I think I'm the best candidate for this project as I am currently studying Excel deeply. This means I am very up to date with the program and know all the ins and outs of it. I can do both simple and complicated actions with Excel.
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi I have experience in developing complex queries and interested in this task ping me so we can start the work Thanks
$25 USD en 1 día
5,0 (1 comentario)
0,0
0,0

Sobre este cliente

Bandera de JAPAN
Matsuyama, Japan
5,0
2
Forma de pago verificada
Miembro desde sept 10, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.