Jump to content

the_furious

Members
  • Content count

    17
  • Joined

  • Last visited

Community Reputation

0 Neutral

About the_furious

  • Rank
    member

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

500 profile views
  1. the_furious

    hourly rates

    My bad, I meant stored calculation The formula seems to be working well.
  2. the_furious

    hourly rates

    Hi everyone, I have a field for for hourly rates, price per unit is $100, however, subsequent hours are half of the original unit price ($50) I need a auto calculation that reflects the actual amount, based on the number of hours inputted. (e.g. 5 hours = $300) I'm raking my brains on how to perform such calculations. Anyone can shed some light to me? Appreciate it!
  3. the_furious

    autocalculation help needed

    Hi Comment, I have no idea why, it's showing the correct values today. My apologies.
  4. the_furious

    autocalculation help needed

    Hi Comment, Sorry about it. Was trying to get the result "Invoice-136-036-15" using "Invoice-" & Category & "-" & SerialIncrement ("000"; SerialNumber) & "-" & Right ( Year (InvoiceDate); 2 ), instead, I'm getting "Invoice-136-36-15" I intend to stick my string of serialnumber to a 3-digit code here.
  5. the_furious

    autocalculation help needed

    Hi Comment, Thanks for the reply. It makes more sense to use Year (InvoiceDate) than Year (Get (CurrentDate) ) However, SerialIncrement does not seem to work very well with my string. I will like the field to display the Serialnumber as a fixed 3-digit code Was trying to Case ( Length ( SerialNumber ) = 1 ; "00" & SerialNumber ; Length ( SerialNumber ) = 2 ; "0" & SerialNumber ; ) but was unsuccessful in integrating it.
  6. the_furious

    autocalculation help needed

    in addition, the record number will reset at the beginning of a new year. Invoice-136-001-16 when it's 2016
  7. Hi all, I have a manual input field, and I plan to replace it to calculation field instead. The field is show as below: Invoice-136-036-15 136 being the category 036 being the last record 15 being the year invoice was created. Is there a way to obtain the "036" and replace the XXX to display as Invoice-136-037-15 once a new record is created? "Invoice-136-" & "XXX" & "-" & Right(Year ( Get ( CurrentDate ) );2) Appreciate your advices.
  8. the_furious

    Portal, records, relationship?

    Hi LaRetta, Sorry for the late reply. Just realised the field is my child table is unstored. Thanks for the info. Merry Christmas to you!
  9. the_furious

    Portal, records, relationship?

    Hi LaRetta, There is something that doesn't quite fit in. I'm trying to get the portal to display records of different months under the same department. E.g. If there are 12 imports, once a month, the portal should display Jan'14 HR Feb'14 HR etc.. Like in my initial attachment.
  10. the_furious

    Portal, records, relationship?

    Hi LaRetta, Thanks for the quick reply. Your file does help me lots. As mentioned in my first post (question 2). I wanted to do away the Reports table but I need an identifier(besides date_imported) to segregate my records as there may be more than 1 import in a single day. Should I change this date field to a timestamp instead? The acknowledgement status/date will be flagged once the head of department has verified the report for the particular month for his department. All records with the same date_imported & user_dept will have the same acknowledge_date. So the same portal will display the acknowledge date to assist the head of department in his work.
  11. the_furious

    Portal, records, relationship?

    Hi LaRetta, Records are all imported data from an excel file. I need my portal to only display the date_imported, and not all records. Therefore, I created a separate report table to do so. Is it possible for me to use records table as a portal to display non-repeated records like date_imported with user_dept? Edit: LoginIDs can be Paul or John (no passwords) the_furious_sample_data.zip
  12. the_furious

    Portal, records, relationship?

    no love? ):
  13. the_furious

    Portal, records, relationship?

    I'm working on a system that allows the head of each department to access and acknowledge monthly reports that are imported into the DB. 2 of the tables are as follows: (I've omitted other fields that are not required for this to work) Records table: pk_recordID, date_imported, user_name, user_dept, acknowledge_date, acknowledge_avg, kf_reportID, g_deptcode (global field that is defined based on user login) Reports table: pk_reportID I'm currently using reports table as a portal to reflect the following fields: Records::g_deptcode, Records::date_imported, and a button that displays a sub-summary list of records found based on Records::user_dept I need some help for the following questions: 1) Displays records:acknowledge_date in my portal. Let's say there's 2 department heads that access the same report/records, Head of HR may have acknowledged the records that reflects HR dept, I want the acknowledge_date to reflect for Head of HR but not Head of Finance who has not acknowledged the records for the same month. 2) Can I make records::kf_reportID into a secondary primary key(e.g. current last count of kf_reportID +1) on its own? so i can remove reports table and use records table as my portal instead. (e,g. 100 records are imported during the month of dec'14. these 100 records shall hold the same kf_reportID) Hope someone can enlighten me from here. Thank you.
  14. hi! thanks for the advice! the calculation is working great!
  15. Hi, Didn't realized I posted my query on the wrong place :X Sorry I didn't make myself clearer. I need to compare this "username" field with "userID" field from another table. if there is a match, it will then grab the relevant information (dept code, user name, etc) from the matching "userID" field.
×

Important Information

By using this site, you agree to our Terms of Use.