Dear Access Master,
Could anyone help me how to calculate data like this
Fields: CodeTraining Employee Department Date
IDT.01 Achi HSE
02/05/07
IDT.02 Icha Training
04/05/07
IDT.01 Cahi Construction
05/05/07
IDT.01 Tony HSE
I would like to have data like this
>From : 01/05/07
To : 06/05/07
Code Training :IDT.01
Training Total
HSE 2
Training 1
Contruction 1
Your advice Please
Rgds,
Achi
_____
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dana
Sent: Saturday, May 12, 2007 1:23 PM
To: [EMAIL PROTECTED]
Subject: RE: [AccessDevelopers] Combo Box Issue-PLEASE HELP
If it contains numeric characters, can you convert it into a number? There
are functions that do this. For example:
If ISNUMERIC(frmBuildings.cboBuildingID) then frmEvent.txtBuildingID =
CDBL(frmBuildings.cboBuildingID) ' (I typed the functions in upper case
for clarity)
Also, you can re-use the Event form as a subform in more than one parent
form. Run the subform wizard, and instead of choosing a table or query as
your source, select the existing Events form.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of jjolene31
Sent: Friday, May 11, 2007 6:32 PM
To: [EMAIL PROTECTED]
Subject: [AccessDevelopers] Combo Box Issue-PLEASE HELP
I have 2 tables one "Event" and "Building" (where the event could take
place) I have in my form a combo box displaying my table list of
Buildings. My Building table has a unique id for every building. I
need my combo box in my form to when one is selected to return the
unique id either into the same field or into my designated
field "building id" in my Event table. I do not want to use a subform
as the Event form is already a subform of another table. I can't put
it into the same field as my building are a string and the unique id is
a number. Please Help!
CONFIDENTIALITY CAUTION:
This email is confidential. If you are not the addressee tell the sender
immediately
and destroy this email without using, sending or storing it.
Emails are not secure and may suffer errors, viruses, delay, interception and
amendment.
PT Darma Henwa does not accept liability for damage caused by this email and
may monitor email traffic.
[Non-text portions of this message have been removed]
