Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: arman28
  • Order by date
  1. arman28

    organised data structure

    Yes I want to see a flexgrid on my form showing selected data as I pick one from the dropbox. If I use the dropbox to choose either male or female, after I select either one I like to see all data associated with what I chose, such as their names, age, location and phone numbers, shown in...
  2. arman28

    organised data structure

    Does anyone know how to see a table in a form by creating grid? I am using Access 2007. I would like to have a dropbox, choose whichever I want and have it to show in gridview along with whatever else associated with that data.. Thanks.
  3. arman28

    organised data structure

    It seems to be working with a field decleard as PK. I have someone to check the result versus both tables(Import and Export)to make sure the result is what I want. I have another question for you; I have created some unique results in two seperate tables and I want to bring them together in...
  4. arman28

    organised data structure

    You mean adding a PK to my Import and one to my Export tables and then follow the "Rank queries" direction that you had originally mentioned along with the rest of the queries?
  5. arman28

    organised data structure

    Here is where data doesn't get pulled properly from the Import or Export table. These are the actual data. Import Date Style Color Qty 11/18/2009 A42101 Black 15 11/18/2009 A42101 White 15 11/18/2009 A42101 Terra Multi 30 11/18/2009 A42101 Metalic Multi 30 11/18/2009...
  6. arman28

    organised data structure

    I will send the section of the exact data that the query didn't retrieve properly. Also, I did another desperate attempt. I got my "matched" query that pulls all matched data, this time with a "PK" that I assigned to all my data in the Import and Export tables. So, naturally when I get my...
  7. arman28

    organised data structure

    Your previous thread worked on all but some and I tried and tried and tried to understand what is different about the records that they didn't produce the correct result but I couldn't see why. The astrisks showing I am not so much worried about but I will try the NZ(). Yes, I do Export my...
  8. arman28

    organised data structure

    I am working with 182000 lines of recods and sometimes due to integrity of the comapny I am unable to post complete data. I grab a sample with some minor changes so I can only deliver the idea(not so good at it seems like it)as to what I am trying to get. Ok, these are shoes coming in on variety...
  9. arman28

    organised data structure

    I have two table Import and Export. They have multiple columns but I have picked Import Style(I_S), Import Color(I_C) and Import Quantity(I_Q) as well as Export Style(E_S), Export Color(E_C) and Export Quantity(E_Q) to show what I want to accomplish. The tables have no PK or FK and the only...
  10. arman28

    sort matching data in ms access

    Sorry to respond late but I just got home from work. Well, one is what I sent you with the Style "A201" Color "Red" that I am missing two records with the "9/3/09" Date. I may be wrong but I believe that if we know what causes the problem then the rest should be solved....am I wrong?
  11. arman28

    sort matching data in ms access

    The last set of records that I sent you with the Style "A4265" comes out OK. I sent them just as a sample of data that I work with as you requested, but the ones before the last that I sent you, is where the dates are similar and where I don't get the correct result. I am refering to the set of...
  12. arman28

    sort matching data in ms access

    The Result Table Date Style Color Qty Date Style Color Qty * * * * * * * * * * * * * * * 5/1/2009 A4265 White 15 3/6/09 A4265 Black 45 * * * * * * * * * * * * * 4/24/09 A4265 Black 105 4/30/2009 A4265 Black 30 4/24/09 A4265 Black 105 4/30/2009 A4265 Black 15 * * * * * * * * * * * * * * *...
  13. arman28

    sort matching data in ms access

    Export Table Date Style Color Qty 7/10/09 A4265 Black 15 11/19/09 A4265 Metallic 15 4/30/09 A4265 White 15 7/10/09 A4265 Citrus 15 5/7/09 A4265 White 15 7/10/09 A4265 White 15 7/10/09 A4265 Terra 15 5/7/09 A4265 Terra 15 5/7/09 A4265 White 15...
  14. arman28

    sort matching data in ms access

    Import Table Date Style Color Qty 4/24/09 A4265 White 210 4/24/09 A4265 Black 105 4/24/09 A4265 Citrus 150 3/6/09 A4265 Citrus 105 3/6/09 A4265 Metallic 165 3/6/09 A4265 Terra 90 3/6/09 A4265 White 90 3/6/09 A4265 Black 45 4/24/09 A4265 Terra 120
  15. arman28

    sort matching data in ms access

    sure, let me see if I can attach some data here....be back shortly
  16. arman28

    sort matching data in ms access

    You are absolutely correct and I cannot argue with that. Now, my data consists of two tables, Import and Export. These are shoes that come in and leave the company that is importing them. The Import and the Export tables both have these information that could be unique and could sets them...
  17. arman28

    sort matching data in ms access

    I am sorry I may have missed that then, my apologies. So based on your opinion, where and what do I need to change so the problem will be resolved?! Regards; Arman
  18. arman28

    sort matching data in ms access

    Hello.. I have tried everything but I cannot seem to see the problem. Here is my Import, Export and the output; Import |Style | Color | Qty | ----------------|-------|------ 11/18/09 | A201 | Red | 195 Export | Style | Color | Qty ---------------|------------ 9/11/09 | A201 |...
  19. arman28

    sort matching data in ms access

    No, not on the same date. This company brings in shoes as "Import" and sends some out as "Export". Every shoe has a style number called "Style" and "Color" and quantity "Qty". Now they may import 50, A4201, red, this year and export 15, A4201, red next year january and 20, A4201, red in march. I...
  20. arman28

    sort matching data in ms access

    so maybe this has something to do with the RANK clause or how the first sql ranks the output. I am thinking the date has something to do with it. It is probably right in my face but I don't see it just like how it is sometimes in life. This is for my wife's company and if I don't figure it...

Part and Inventory Search

Back
Top