UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> showing query result on a form    
 
   
msm1977
post Feb 9 2008, 03:00 AM
Post #1

UtterAccess Member
Posts: 26
From: UAE, Dubai
I have a query calculating a sum of numerical resulting only one value
on the other hand i want the result to be shown in a form's lable
query name: balance
form name :Tabbed
Lable name: Balance_LBL
Go to the top of the page
 
+
Bob_L
post Feb 9 2008, 03:54 AM
Post #2

Utterly Banned
Posts: 7,038
Use a text box formatted as a label (Special Effect - FLAT, Border - Transparent, Background - Transparent

and set the control source to =DLookup("WhateverFieldFromYourQuery","YourQueryNameHere")
Go to the top of the page
 
+
msm1977
post Feb 9 2008, 04:12 AM
Post #3

UtterAccess Member
Posts: 26
From: UAE, Dubai
That is great it is working perfectly
thank you
Go to the top of the page
 
+
Bob_L
post Feb 9 2008, 04:21 AM
Post #4

Utterly Banned
Posts: 7,038
Glad we could help (IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif)
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 09:40 PM