Search results for query: *

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 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, 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, 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, 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, I have this: Group#1 Header (Suppressed) Group#2 Header Details (Suppressed) Group#2 Footer (Suppressed) Group#1 Footer There's a page break in details with this formula: {field} <> Next({field}) When I insert Group#1, the Group#1 Footer for the first set of data will always be...

Hi, I have a question here. Can I force page break in a report based on a field? I have one field. If it is A then this field will display &quot;A&quot; then all the details with respect to A. If it is B then it will automatically page break and display &quot;B&quot; then all the details of B...

Hi, In the format section option, in the details section, there is an option, Hide(Drill down OK), may I know what's the use of this option? How do I make the details to be hidden but can be drilled down by clicking on it?? Jerry 5/20/02 2:57:04 AM

Hi, need to trouble ppl again. In this formula field I have this: If {ParentProduct.ParentProduct} = &quot;Commission&quot; then {Trade.ProdCredit} In some records, it is zero. May I know how to display a &quot;-&quot; instead of 0.00?? Thanks Jerry

Greetings, I have specified in the select expert for one of my fields {Trade.TradeDate} to be between some dates. Now if I want to display the date ranges in the report? How can I do it? For example: TradeDate: DDMMYYYY to DDMMYYYY Thanks for any advice. Regards Jerry

I need to create my report such that this single field will have alternate colors. Example: BucketName AAAA (in green) BBBB (in yellow) CCCC (in green) DDDD (in yellow) How can I do this? Now I can only make it in one yellow. Please advise. Thanks! Jerry

Greetings, I have this problem here. When I display my report, the fields appeared like this: BucketName ProdCredit Product AXA 80 Commission AXA 500 Commission AXA 500 Commission AXA 0.00...

Hi, I have 2 tables in which there are some fields I want to display. These 2 tables are linked together by 3 tables which I did not display their fields. Now, if I want to display data based on the undisplayed tables' fields. Can I do that? OKie example: 2 Tables: Bucket and Trade Linking...

Hi, I have some problems here. I want to display some fields horizontal but I cant seem to do it. For example: Commission Convertibles GED Another problem is that if there's no links between 2 tables, am I able to display their fields together in one report? I cant seem to do it...

Hi, I have some problems here. I want to display some fields horizontal but I cant seem to do it. For example: Commission Convertibles GED Another problem is that if there's no links between 2 tables, am I able to display their fields together in one report? I cant seem to do it...