Search results for query: *

Hi, Yes indeed. I wuld like to accumulate totals within the report. How do I go about doing that? My idea of the report: Shift1 Shift2 Shift3 John 10 20 30 Mary 30 10 20 Issit posssible to achieve this? Rgds Jerry

Hi Duane, Thx for your reply. I tried out the method u mentioned. It was not exactly wat I have in mind. What I want is a report that will tabulate for example how many Shift1 or how many Shift2 an employee has done. A summary to be exact. The autoreport function just shows all the records...

Hi, I have this database here. It has 2 tables. One is employee info another is employee activities. The table on employee activities is actually showing the schedule of the employees. The dates and the kinda of shift each one is doing. It also shows whether the day he is working issit a public...

Hi Adamroof, Thank you for ur help.

Hi all, I have a combo box which is supposed to display a particular field from a table. There are many duplicates info in this field. Eg Shift1, Shift2, Shift3, Leave, MC. However, I only want it to display Shift1, Shift2 and Shift3. How do I write the row source statement? Select Distinct...

Hi Dcurtis, I have a new problem here. Let's say I have 2 tables. 1 is for storing the names and particulars of the employees. Another 1 for the shifts. Using the table meant for shifts, I am able to show it in the combo box and run a query. However, I want to show the names of the employees...

Hi Dcurtis, Thanks a lot for ur help! I got it now. Regards Jerry

Hi, Well, I forgot to let u know that those command buttons in the first place are being formed using marcos. I used marcos to open up the queries. In my queries, it actually requires user to enter the name of shifters or date of shift. This is troublesome as we need to know the exact name of...

Hi dcurtis, I understand what u mean. But I cant get the criteria correct. What do u mean by (critera is [Forms]![Form1]![WorkDate)?? Issit the expression builder?? How do u make the combo box looking up from the table?? Pls kindly advice. Thks. Jerry

Hi, I need some help here. I m doing a shift schedule database. I had a form here. With command buttons linking to some queries. When I click on the button, it will prompt me to enter the query name of the shifters or date of the shifts. Issit possible that I change these command buttons to...

Hi hneal98 and AceMan1, thanks for your reply. Okie...coz i was wondering whether it is better to have 3 tables like 1 for each shift. But in this way I have to query from 3 tables. Hi hneal98, double entry as in?? Well I m not sure whether to use filter or query to find my desired records...

Hi, I have this plan to start a staff movement database. However I need some tips on how to get it going. There are 3 shifts per day. 2 persons per shift. I have 3 tables. 1 table is for employees profile (tblprofile). Where EmployeeID is the primary key. 2nd table is activity table...

Hi, I have this plan to start a staff movement database. However I need some tips on how to get it going. There are 3 shifts per day. 2 persons per shift. I have 3 tables. 1 table is for employees profile (tblprofile). Where EmployeeID is the primary key. 2nd table is activity table...

Hi guys thanks for ur help. But I cant get the results I wanted. For example, 2 persons with different employeeID are on duty on a date. 2 records in activity table. I input a date and and filter it to find these 2 IDs. However, in a text box it is only able to display 1 ID at a time. I have...

Hi, I have a problem here. I am planning to build a staff movement database. Now I have a form where I want to display two records. For example, I input a date and did a filter. However, there are 2 persons on duty that day. It is only able to display 1 record at a time. Is there anyway to...

Hi, can u believe it? I have let it run since yesterday morning till now (ard 26 hours has passed).....but it's still reading records. This is after I have remove the groups which Ken suggested. If not I think it will still be accessing the database. At least there are records..... Jerry

HI Ken, thanks for the advice. I shall try it now and let u know how it goes.... Cheers Jerry

Hi Ken, CR wrote the SQL statement. I merely do all the record selection using select expert This is what i have in the Report - Edit selection formula: not ({Account.SystemId} in ["ADJU", "AP", "CROS", "GTE"]) and {Account.AccountType} = "1&quot...

Hi, actually I m a student on attachment trying to create this report for my company. I m not very sure how many records there are in the database. But I guess there are a lot. My record selection formula is: SELECT Trade.ProdCredit, Trade.TradeDate, Trade.DelFlag, Account.SystemId...

Thanks a lot Ken! I will try it out and see whether it works. I m still unable to know what's the outcome as the time taken to access the database is very long......(can be up to a few hours....) I m using Sybase Database and CR version 8. Get back to u when I tried it out. Thanks Jerry