Need SQL Help (VB6 and Access)

[ahmed_1]

Hi

I need Help in SQL. I've created a VB Project of Accounting, Using Access as a Backend database, In database I've 2 tables:

Table 1: Trans
Table 2: Trans_Details

Following Fields are in "Trans"

FieldName (Type) FieldName (Type) FieldName (Type)
Vno (Text) Vdate (Date) VNarr (Text)

Following Fields are in "Trans_Details"
FieldName (Type) FieldName (Type) FieldName (Type) FieldName(Type)
Vno (Text) AccId (Text) DebitAmnt (Number)CreditAmnt(Number)

What i need is a SQL query which give me All Transactions of particular AccId for a specific range of range of dates.

Please Help me on to this.

Waiting for anyone's quick response

Ahmed

[mnemtsas]

This should work for the command text for a command object in ADO

Parameters Date1 DateTime;Date2 DateTime;SELECT * FROM Trans_Details INNER JOIN Trans ON Trans_Details.Vno=Trans.Vno WHERE Trans.Vdate>=Date1 AND Trans.Vdate<=Date2

[ahmed_1]

Hi mnemtsas,

Thanx for your reply. The code you've given will reult all Transaction within a specific range. What i want is All Transaction in a specific range AND a AccId specified.

waiting for reply.

Ahmed

[mnemtsas]

Parameters Date1 DateTime;Date2 DateTime;Account Text;SELECT * FROM Trans_Details INNER JOIN Trans ON Trans_Details.Vno=Trans.Vno WHERE Trans.Vdate>=Date1 AND Trans.Vdate<=Date2 and Accid=Account;