Can I anyone advice me how to write parameter in Crosstab query in the date field and the date will be accessed through a form to put the range date?
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Achi Rachimuddin Sent: Thursday, May 17, 2007 4:00 PM To: [EMAIL PROTECTED]; [email protected]; [EMAIL PROTECTED] Subject: [ms_access] [AccessDevelopers] Count data from specific range of date (revisi Importance: High _____ From: AccessDevelopers@ <mailto:AccessDevelopers%40yahoogroups.com> yahoogroups.com [mailto:AccessDevelopers@ <mailto:AccessDevelopers%40yahoogroups.com> yahoogroups.com] On Behalf Of Achi Rachimuddin Sent: Thursday, May 17, 2007 3:39 PM To: AccessDevelopers@ <mailto:AccessDevelopers%40yahoogroups.com> yahoogroups.com; [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com; belajar-access@ <mailto:belajar-access%40yahoogroups.com> yahoogroups.com Subject: [AccessDevelopers] Count data from specific range of date Importance: High 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 06/05/07 I would like to have data like this >From : 01/05/07 To : 06/05/07 Code Training :IDT.01 Departments Total HSE 2 Training 1 Construction 1 Your advice Please Rgds, Achi _____ From: AccessDevelopers@ <mailto:AccessDevelopers%40yahoogroups.com> yahoogroups.com [mailto:AccessDevelopers@ <mailto:AccessDevelopers%40yahoogroups.com> yahoogroups.com] On Behalf Of Dana Sent: Saturday, May 12, 2007 1:23 PM To: AccessDevelopers@ <mailto:AccessDevelopers%40yahoogroups.com> yahoogroups.com 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: AccessDevelopers@ <mailto:AccessDevelopers%40yahoogroups.com> yahoogroups.com [mailto:AccessDevelopers@ <mailto:AccessDevelopers%40yahoogroups.com> yahoogroups.com]On Behalf Of jjolene31 Sent: Friday, May 11, 2007 6:32 PM To: AccessDevelopers@ <mailto:AccessDevelopers%40yahoogroups.com> yahoogroups.com 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. 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. 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] 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. 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]
