Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-21-2019, 09:30 PM   #16
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,673
Thanks: 2
Thanked 2,059 Times in 2,014 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Form and Query Help Please!

Click at the new button in the form, is this what you want?
Attached Files
File Type: accdb SAMPLE-15.accdb (664.0 KB, 17 views)

__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Old 06-24-2019, 01:20 PM   #17
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,673
Thanks: 2
Thanked 2,059 Times in 2,014 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Form and Query Help Please!

Have you looked at the attached database in post #16, is that what you want?
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Old 06-24-2019, 01:32 PM   #18
rsingh4377
Newly Registered User
 
Join Date: Jun 2019
Posts: 37
Thanks: 6
Thanked 0 Times in 0 Posts
rsingh4377 is on a distinguished road
Re: Form and Query Help Please!

Hi JHB, I was able to resolve that particular issue however I have another bump in the road...I will post the attachments here regarding what I messaged you. Thank you!
Attached Images
File Type: png Example.png (40.8 KB, 12 views)
Attached Files
File Type: accdb AnotherSample.accdb (640.0 KB, 10 views)

rsingh4377 is offline   Reply With Quote
Old 06-24-2019, 09:13 PM   #19
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,673
Thanks: 2
Thanked 2,059 Times in 2,014 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Form and Query Help Please!

Yes you posted a printscreen how you want it but not which data there are involved and how they are related to each other.
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Old 06-26-2019, 05:50 AM   #20
rsingh4377
Newly Registered User
 
Join Date: Jun 2019
Posts: 37
Thanks: 6
Thanked 0 Times in 0 Posts
rsingh4377 is on a distinguished road
Re: Form and Query Help Please!

Hi JHB, so basically I want to be able to create a criteria in either access or excel where I would be able to find a BIN in all records and based on that BIN I want to put particular elements into a new table and so on going across. For example, if I am looking for BIN 1234, there are duplicate records under the BIN field with that same number so I want to find that BIN and move on to the next criteria for a particular cell/value and find multiple elements from the next field, so say the elements I am looking for include 1,2,3 and 4. Each element is entered in its own record so I am trying to create a criteria/code in either access or excel to find BIN 1234 for elements 1,2,3 and 4 for one particular cell. I am sure I will be able to duplicate this code once I am able to find the correct code for one cell. Please Help!
rsingh4377 is offline   Reply With Quote
Old 06-26-2019, 05:53 AM   #21
rsingh4377
Newly Registered User
 
Join Date: Jun 2019
Posts: 37
Thanks: 6
Thanked 0 Times in 0 Posts
rsingh4377 is on a distinguished road
Re: Form and Query Help Please!

And just to clear which data are included, I am looking for a simple math equation once I am able to find my desired data. I am looking for the percentage makeup of cs3 and cs4 out of the entire sum quantity. So it would be ((cs3+cs4)/sum quantity)*100
rsingh4377 is offline   Reply With Quote
Old 06-26-2019, 09:30 PM   #22
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,673
Thanks: 2
Thanked 2,059 Times in 2,014 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Form and Query Help Please!

Sorry - looking at your tables I don't see any BIN 1234 or field cs3/cs4.


__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Query In Form Fails When Form Is Called Through Navigation Form guyuz Forms 2 01-28-2016 03:38 PM
[FORM] Query Builder Form Generator (GENERATE FORM BASED ON TABLE) BlueIshDan Modules & VBA 0 05-30-2014 09:44 AM
Query by form, Query explodes after being closed for the first time, any help appre New to Access Queries 1 04-22-2011 03:35 AM
Combining 3 Queries to Form One Query With Columns from each query by month springa Queries 3 03-17-2009 01:13 AM
Search form will run query but will not open form based on same query mitchem1 Forms 3 06-27-2002 12:07 PM




All times are GMT -8. The time now is 10:24 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World