Recent content by seanbee

ok..thanks..Just needed a direction. This is the 1st time im doing this.

Hello Guys, Finally got feed back. they are looking for a query with the fields that have a specific range example: SELECT BINWIP.[BINDTLBINLOW], BINWIP.[BINDTLBINHIGH], BINWIP.[BINDTLCOUNTRY], BINWIP.[BINDTLCARDIND] FROM BINWIP; is query..How would I specify a range of 40000000 to 49999999...

Still Waiting on feed back....Thx again

Oh ok...that my be the the issue there. ..Im check and see what exactly is needed and ill report back later. Thanks again

LOL..Sorry Plog. C2 represents BINLOW C3 represents BINHigh those are the 2 fields I am concerned about. I will build the other fields on Bincardin..inside the table to produce results for the other fields. certain ranges in .. '40000000' - '49999999' is Visa 51000000- 5599999 is...

the 1st screenshot is the dbf and the 2nd screenshot is sample of ranges with result. Thanks for all your help!! Best regards, Sean

After:

Before:

Thanks for all the help.

Here is screen shots: Says I need 10 post or greater..so I and right on the bubble.

sure..how would you like me to show that. screen shot or simple 10 or 15 record dbf . only got screen shot of what I want the result to look like Thanks for all your help.

ok..thanks. looking at it now. I would like to take the BINWIP table. Use the fields I gave you and generate another table athe will use the ranges in BINLOw and BINHIGH to produce a range of selected numbers that vary..ie: 4000 -4999 = Visa, 5100 - 5599- MsterCard. 3400-3499 = American Express.

OK...So so if I use the query wizard and create the query that way..will it give me the ranges to obtain.. can you please explain ..how to use query builder to build this query to add more then one field or is there a tutorials for this. Ill do it with the query builder. Just need a little...

OK Guys Sorry: Let me be more Clear. I need to write a VB Query on a table caleed BINWIP. Within this table. I need to query a fileld called BINDTLCARDIN and create a way to look at a range of numbers in another field called BinLOW and BINHigh. I need to to be able to do that VBprogramming...

So please point me in the right direction. where I can query the table with specific fields and then create a range look up in two particular fields I choose? thanks in advance. Sean