Tamamlanmış

Modify a existing access query ( group by a if statement )

i have a sum query

i need that a group by field should be based on a if statement

purpose = i have two warehouse's but dont want each item to show double only if its not there in the first do i want it to show from the 2nd

job will be done by loggin in remotely

its a query based on other query the whole structure might need to be redone

should take a few minutes if you know what your doing

Beceriler: Veritabanı Programlama, Microsoft Access, Yazılım Mimarisi, SQL, Visual Basic

Daha fazlasını gör: access query designer, access query days, access query creator, how to modify a query in access 2016, update query in access 2010, how to create an update query in access 2016, access update query from another table, access update query multiple criteria, access update query examples, append query access, update query access, sql, software architecture, visual basic, database programming, microsoft access, project access query, access query days today, access query convert multiple records across columns, php count access query

İşveren Hakkında:
( 9 değerlendirme ) BROOKYN, United States

Proje NO: #17443495

Seçilen:

sumon355

Hello, As an expert in SQL, i am very much interested to modify the query. Are you using ms sql server or ms access? Thanks

%selectedBids___i_period_sub_7% gün içinde 23%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(254 Değerlendirme)
7.2

Bu iş için 13 freelancer ortalamada $27 teklif veriyor

VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl Daha Fazla

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(108 Değerlendirme)
6.1
alexgospodarets

Hi! I have 11+ years of web developing experience. I can promise quality and responsibility. We can start IMMEDIATELY.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(25 Değerlendirme)
5.8
zu02

Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VB. I'm Ms Access/VB/SQL/Excel programmer since 1997. Really all my projects here I've developed for Ms Access Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(53 Değerlendirme)
6.2
NourElDeen

Hi on14ave, I'm expert in access and anything can be done if not in query i can do it dynamic through VBA. Wish you msg me to get more details. Thank you NourElDeen

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(71 Değerlendirme)
5.9
vmadhavan15

am not a random bidder.. Please ping me if you are interested with my proposal and share more details.. thank you../

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(21 Değerlendirme)
4.7
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(59 Değerlendirme)
5.2
nizamulamy

Hello Sir, I read your project description with interest. As per your requirement, I would like to tell you that I have more than 5 years working experience in this roles, I'll provide you 100% quality with efficie Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
1.8
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
1.5
judicaelyossa

Hi Dear Hiring Manager, I'm a senior software developer with experience on SQL Query. I used to write optimized queries for some customers. I will do your group by fast. I'm available now. Get in touch with me Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
1.0
Mexi2705

Hi!. I am available right now, how are you? I am interested in your project and would like to discuss the project with you. I always deliver on time and on budget feel free to check my feedbacks and portfolio. I u Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
midas0925

only 10 minutes is enough for you. I am sql query expert and i am sure that i can help you. just tell me your issue, i will fix it.

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0