Is there a web site that can ofer some help. The quotation marks are posing
an issue as well as other items for this function. I have some books but
they are not consistent in their use of the code lingo. Thank you for any
help. Presently I have tables and forms to gather employee info. I use the
subform to gather status of absence, text field. What I want to do is
calculate the vacation hours and subtract them from the total alocation of
vacation alloted per year. I presently have my subform set up to input the
staus condition, hours off and then to segregate the vacation hpurs I added
a second field of hours of vacation to Sum the Vacation hours separate from
the other hours of absence that are not related to vacation. I can set up a
query with a parameter to extract the vacation hours only which is simple
enough but how can I erase the second hours column and replace it with DSum
function to tidy up the subform so data entry personnel only see one hours
filed on the form. Presently the form runs off tables. Should I rebuild the
form and run it off a query with the vacation parameter built in to the
field.
All help is welcome.
Marc Aube
1  1939 
OK,
1. The domain function DSum, (like DCount, DAvg, etc.) syntax is enclose
each required element with double quotes and separate them commas -
DSum("[thing I want to total]","[where the records are]","[condition(s) that
I want to filter records]")
2. You really don't want to store calculated values. Use an unbound control
on your subform to subtract the hours data entered from the allocated leave
time. Recalculate that for any form/report where you need to see the hours
remaining.
-Ed
"Marc Aube" <ma******@cogec o.ca> wrote in message
news:9o******** *******@read2.c gocable.net... Is there a web site that can ofer some help. The quotation marks are
posing an issue as well as other items for this function. I have some
books but they are not consistent in their use of the code lingo. Thank
you for any help. Presently I have tables and forms to gather employee
info. I use the subform to gather status of absence, text field. What I
want to do is calculate the vacation hours and subtract them from the
total alocation of vacation alloted per year. I presently have my subform
set up to input the staus condition, hours off and then to segregate the
vacation hpurs I added a second field of hours of vacation to Sum the
Vacation hours separate from the other hours of absence that are not
related to vacation. I can set up a query with a parameter to extract the
vacation hours only which is simple enough but how can I erase the second
hours column and replace it with DSum function to tidy up the subform so
data entry personnel only see one hours filed on the form. Presently the
form runs off tables. Should I rebuild the form and run it off a query
with the vacation parameter built in to the field.
All help is welcome.
Marc Aube This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Rolan |
last post by:
I'm using Access 97 and need some assistance in sorting out a proper
DSum expression. It relates to a subform (sfrmCost) from which I'm
wanting to extract the grand total of any and all data rows that have
the same primary IDReference, and have it post as an accumulative sum
in one text box (TotalCost) on the main form (frmMain). There are
actually three columns across in each row which contain number values
and I have been able to only...
|
by: Rolan |
last post by:
I'm using Access 97 and need some assistance in sorting out a proper
DSum expression, or maybe even DCount might be an alternative. I have
tried numerous combinations, but with no apparent success.
The DSum function relates to a subform (sfrmCost) with a text box
(RefCost) which is intended to be the container for a total from a
query (qryItems). The query has three number columns from the table
(tblItems) of which I have an expression...
|
by: Dalan |
last post by:
I seemed to be having problems with structuring the use of NZ with a
DSum expression. Having tried numerous variations of the expression
without success, I'm asking for assistance.
First some background (Access 97) - the DSum expressions are being
used in grand total text boxes on the footer of a subform. And when
viewing the subform in the linked main form the two grand total boxes
display #Error if no entry had been made. Those with...
|
by: Mark Reed |
last post by:
All,
I have never used this function before and am not sure it what I need.
Just to clarify, I have a report based on a query which has amoungst other
field, wk, parea & packs_req. What I am trying to do is create a subreport
for the main report which gives a generalised breakdown of the main report.
For the gender of 'Ladies', there may be several parea's so I want to sum
the packs_req for ladies only. (Gender is not a field I can use,...
|
by: GD |
last post by:
tblFoo
FooId Name Number
1 One 1
2 Two 2
3 Three 3
The Following query produces the results I want, but it is not
updatable. I need at least the "Number" field to be updatable.
| | |
by: gbb0330 |
last post by:
Hi All
i am trying to calculate Quantity on hand in a unbound textbox in a
form with a subform
QonHand=Qreceived - TotalQSold
TotalQsold=QsoldOnEbay+QsoldThruOtherChannels
here is my expression:
|
by: emc_cos |
last post by:
So I am relatively new to Access so please bare with me...
I have been able to create a very functional form that will be utilized
for time entry for tasks.
The primary form is a record entry type that has a unique file number
for each entry.
At the bottom of the form I have a set of control buttons that when
|
by: pixie |
last post by:
Hi. I'm having problems with the following DSum in my report footer. It gives me #Error when I run the report. I hope someone can help me out as I am at my wits end. What I am trying to do is to create a total budget which is revenues - expenses - expenses in-direct. Those controls are in the detail section of the report as groups. Here is the code.
=DSum("","qrySummaryReport"," = 'Revenues'")-DSum("","qrySummaryReport"," = 'Expenses...
|
by: danielgoss |
last post by:
Hi
I have a report that has loads of textboxes that calculate things based on the value on another textbox in the report. I have put a hidden textbox on my report that gets its value from an inputbox when the report opens. I then want to use the value inputted in a DSUM calculation on the same form.
The hidden textbox is called tbHolddate, its control source is:
=InputBox()
The textbox that calculates a value using a DSUM control...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
