Search results for query: *

hi, i have a field name ID (autonumber) and date, how do I reset the autonumber to 1 when new year start. Examples: ID Date 1 01/01/07 2 07/15/07 3 12/24/07 4 12/31/07 1 01/01/08 2 02/05/08 3...

Hello All, I would like to calculate Week Number (each year has 52 weeks) and period during that week. First Day of the week is Sunday and last day is Saturday. Example: If I enter these days below: Date: 01/01/2008 01/03/2008 01/15/2008 03/28/2008 07/01/2008 07/22/2008 09/27/2008 12/21/2008...

Please help... with this one, I'm very appriciated. table named: "tblCustomer", Primary key: CustomerID and VOH_ID. If there r new records then I can use this button for adding new. However, if there are some records in this table such as: CustomerID VOH_ID OptID 1...

hello, i have a problem using access 2003 and SQLServer. using DOBC. If i'm using the mdb by myself then it's working fine. However, this is a shared mdb by network, so more than 2 people can open the database at the same time. All other forms are working except 1 form after i hit a button then...

I have a form linked with a subform such as: main form: (table A with ID: primary key) ID :1545 CustomerID (auto-number) 500 and some other fields subform (table B, primary key: CustomerID and ViolationNO)(CustomerID in both tables A & B linked) ViolationsNO Score...

hi i have a main form linked with subform, in the subform I would like to show all 27 records, how can I do it? please help? Example: Main form: CustomerID (auto-number) : 12545 Subform: (link with customer ID) (continuous form) Violations Score CustomerID 1 5...

hi i have a main form linked with subform, in the subform I would like to show all 27 records, how can I do it? please help? Example: Main form: CustomerID (auto-number) : 12545 Subform: (link with customer ID) (continuous form) Violations Score CustomerID 1 5...

I created a report with formulas: In group header: (@Reset): whileprintingrecords; StringVar RXDesc := ""; Group footer: (@Display): whileprintingrecords; StringVar RXDesc; left(RXDesc, len(RXDesc)-2); And In detail: (@Accum): whileprintingrecords; if not isnull ({@RXDesc}) and...

I have a report maximum each customer have 4 records, and if a customer have more than 2 records then split the page 1/2 and display on the other half, report run by CustomerID Data: CustomerID Date GivenBy 200 01/01/02 TNT 200 02/25/03 CNP 200...

I have a grouping on PatientNo and then a grouping on CollectedDate, This is sample of my table: PatientNo Specimen CollectedDate Culture Smear 101 Blood 11/01/2006 Pos --- 101 Blood 11/01/2006 --- Neg 101 Blood...

Hi, please help I’m using crystal report 10, database type: OLE DB(ADO) with SQLOLEDB server. I’m trying to run the parameters. The 1st parameter has three STATIC values : “Case Number”, “Patient Number” and “Case Name” in default values. If I pick "Case Number" in the 1st parameter, then...

Please help I have 4 fields like this in the table 1stField 2ndField 3rdField 4thField Y N Y N N N Y Y N Y N N Y Y...

I have a main report and a Sub-reportA on it, it's working and showing data fine on the main. However, I have another Sub-reportB link to an ID in Sub-reportA. When I run the Sub-reportA by itself, it's working fine and showing all data I need, but when I run the main report, the Sub-reportB...

I have a report using CR 10 and SQL server created in 17 X 22 landscape paper size. But my printer can't print that kind of paper, only leter size (8 1/2 X 11 only). So I search for a help, then I found a solution. The solution is: create the cross-tab, and click any field into the "Columns"...

Could you please help with this question? can I add these records to only one line with group by patient_no such as: Patient_no RX Meds dose 1252 INH 600 mg 1252 RIF 800 mg 1252...