Search results for query: *

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...

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.

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...

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?

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...

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...

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...

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...

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...

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?

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...

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 * * * * * * * * * * * * * * *...

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...

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

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

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...

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

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 |...

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...

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...