|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 12th, 2004, 02:51 AM
|
|||
|
|||
displaying value
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 
|
|
#2
August 12th, 2004, 03:19 AM
|
|||
|
|||
|
displaying value
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 .
|
|
#3
August 12th, 2004, 03:44 AM
|
|||
|
|||
|
displaying value
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 . .
|
|
#4
August 12th, 2004, 06:29 AM
|
|||
|
|||
|
displaying value
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 . . .
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Displaying JPGs | AmauryJapon | General Discussion | 1 | July 16th, 2004 06:10 AM |
| Displaying JPGs | AmauryJapon | Using Forms | 0 | July 13th, 2004 03:03 PM |
| Displaying JPGs | AmauryJapon | General Discussion | 0 | July 13th, 2004 03:01 PM |
Linear Mode
