I need to create access table with VB Programming

[seanbee]

the 1st screenshot is the dbf and the 2nd screenshot is sample of ranges with result.

Thanks for all your help!!

Best regards,
Sean

 

[plog]

Your results data is in no way related to your intial posting. I don't know if you misunderstood what I needed or if you are leaving out some initial data.

Since you didn't give your results field names I will refer to them by column number (C1, C2, C3 etc.).

C1 - No where in your data does the value 'VI' appear

C2 - No where in your data does the value '40000000' appear

C3 - No where in your data does the value '49999999' appear

C4 - No where in your data does the value 'Visa' appear

C5 - No where in your data does the value '15' appear

C6 - No where in your data does the value 'Both HCS & TCS' appear


Data just doesn't get created in a query, it flows through from the underlying source.

 

[seanbee]

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 MasterCard

3400000- 3499999 is American express

Hope that clears it up better.

Best regards,
Sean

Thanks in advance.

 

[plog]

No, you missed the point. You can't query a dataset and get data that isn't in the underlying data set. This has nothing to do with column names and everything to do with the data. What you provided me as resulting data doesn't exist in the starting data.

 

[seanbee]

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

 

[seanbee]

Still Waiting on feed back....Thx again

 

[Uncle Gizmo]

It appears to me that you need to reply to plog's request.

 

[seanbee]

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 inside that query.
using BINDTLBINLOW and BINDTLBINHIGH as the range fields?

thanks in advance.

Sean

 

[plog]

No offense, but that's not even query 101 level material. I suggest you read up on how to write queries:

http://office.microsoft.com/en-us/access-help/queries-i-get-answers-with-queries-RZ001077757.aspx

 

[seanbee]

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

 

[Thales750]

You are going about this the hard way. Learn how to make queries with the Create Query tool first.

It is a graphic tool for making queries, you can make most any kind of query with this tool.