help to take value into a variable

[vds_sandeep]

Hi All,

I declared a variable x, now i want to select count of rows of a table into x
i m new user and i tried like this
select count(*) into x from <table>;
y=x;
where y is another variable
but when i m executing this all code it will create a table as x and insert this count into x but i want to take value into variable x;

please help me...

Thanks in advance

 

[Vbark]

Try this..

if y is a number then
x = nz(dcount("YourPrimaryKeyField","YourTable","WhichEverField=" & y ) ,0)

if y is a string then
x = nz(dcount("YourPrimaryKeyField","YourTable","WhichEverField='" & y & "'" ) ,0)

or with no Where
x = nz(dcount("YourPrimaryKeyField","YourTable", ) ,0)

 

[Vbark]

sorry last one again...

or with no Where
x = nz(dcount("YourPrimaryKeyField","YourTable" ) ,0)