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

...E_Q A42 Red 20 A42 Red 10 A42 Red 5 I want to get this as output; I_S I_C I_Q E_S E_C E_Q A42 Red 20 A42 Red 10 *********** A42 Red 5 doesn't matter how many stars or @ or & just any character will do, this is so the cell underneath is filled therefore...

...E_C E_Q ============================================ A42 Multi 15 A42 Metallic 15 A42 Multi 360 A42 Multi 15 A42 Metallic 210 A42 Multi 30 *** **** *** A42 Multi 15 *** **** *** A42 Multi 15 *** **** *** A42 Multi 15 *** ***** *** A42 Metallic 15 B33 Black 85 B33...

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

...| 15 9/3/09 | A201 | Red | 15 Result Import Style Color Qty Export Style Color Qty 8/20/09 A201 Red 195 8/27/09 A201 Red 15 * * * * * ** * * * * * ***9/10/09 A201 Red 15 * * * * * ** * * * * * ***9/11/09 A201 Red 30 * * * * * ** * * * * * **10/9/09 A201 Red 15...

...15, A4201, red next year january and 20, A4201, red in march. I want to see this; 2/20/2009 - A4201 - red - 50 | 1/5/2010 - A4201 - red - 15 ********************* 3/5/2010 - A4201 - red - 20 Bue what I see in some instances is 2/20/2009 - A4201 - red - 50 |...

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