displaying value

M

marie

hi all,

im new to access and now i have problem with report. what
i want is to diplay the value i calculate in query which
only has 1 row and few fields. what i did so far is to
input its control in properties(unbound) to exact query
(i.e; [query1]![field1]).

but when i run report is shows '#name?'. i dont know how
to modify it such that it can display the value on that
particular field

TIA ,
marie
 
M

marie

but how if i have many query which has same fields name?

marie
-----Original Message-----
Marie,

Just =[field1] is all you need.

HTH,

Terry
-----Original Message-----
hi all,

im new to access and now i have problem with report. what
i want is to diplay the value i calculate in query which
only has 1 row and few fields. what i did so far is to
input its control in properties(unbound) to exact query
(i.e; [query1]![field1]).

but when i run report is shows '#name?'. i dont know how
to modify it such that it can display the value on that
particular field

TIA ,
marie
.
Click to expand...
.
Click to expand...
 
T

Terry

Marie,

If you run the query and note the name of the field you
want to use in the query column heading. It is usually
qualified with the name of the source table / query.
eg [Table1]![field1]

You will save yourself a lot of heartache and confusion if
you attempt to name your tables and fields meaningfully.

HTH

Terry
-----Original Message-----
but how if i have many query which has same fields name?

marie
-----Original Message-----
Marie,

Just =[field1] is all you need.

HTH,

Terry
-----Original Message-----
hi all,

im new to access and now i have problem with report. what
i want is to diplay the value i calculate in query which
only has 1 row and few fields. what i did so far is to
input its control in properties(unbound) to exact query
(i.e; [query1]![field1]).

but when i run report is shows '#name?'. i dont know how
to modify it such that it can display the value on that
particular field

TIA ,
marie
.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Top