Page 2 of 3 FirstFirst 123 LastLast
Results 16 to 30 of 44
  1. #16
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    We are trying to help. Please do not PM me. I'll answer, as will others, in the forum.



    Make your questions as clear and focused as you can. It is obvious that English is Not your native language.

    "Later" is not a PaymentType. It is not the same as "Cash","CreditCard"....

  2. #17
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Thank you very much
    Yes
    1. (Cash) Is a payment in advance
    2. The (Later)
    Is the non-payment of the amount then maybe a week or a month payment is

  3. #18
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Hello
    Suppose that the (Cash) is (A)
    And that (Later) is (B)
    If the value of (Type of payment) is (A) the text field ($ $) and (HAS) is the same value (Total work wages) and (HAS) subform

  4. #19
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Readers are not understanding your English description.
    In post#5 you made a PK from the Date - does this mean you only have 1 record per day.
    It is not common to see this data type used for a PK. Just trying to confirm your choice of PK and the relationship between tables.

  5. #20
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Thank you orange
    I am writing a new bill when I add the same date there is no harm from it
    Your advice to me
    Or Is it possible amendment to the (DB)

  6. #21
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Please post a jpg of all your tables and relationships. Make sure you extend your tables in the diagram so all fields are visible.

  7. #22
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Attachment 15455
    Thank you all
    This image tables as you require
    Attached Thumbnails Attached Thumbnails aa.JPG  

  8. #23
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    528
    As the Post #13
    Were attaching (DB)
    And send the password you

  9. #24
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    You may get some ideas from this free data model.

  10. #25
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Thank you orange
    All I want is required in the Post (18)

  11. #26
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I don't understand post #18. Try again to describe what you want. Show an example if necessary.

  12. #27
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Thank you orange
    Suppose that the (Cash) is (A)
    And that (Later) is (B)
    If the value of (Type of payment) is (A) the text field ($ $) and (HAS) is the same value (Total work wages) and (HAS) subform
    Click image for larger version. 

Name:	1.JPG 
Views:	19 
Size:	113.0 KB 
ID:	15458

  13. #28
    Xipooo's Avatar
    Xipooo is offline Sr. Database Developer
    Windows 8 Access 2013
    Join Date
    Jan 2014
    Location
    Arizona
    Posts
    332
    I am really trying to understand, but I simply cannot. Your sentences are incomplete. Perhaps if you wrote out your question in your native language we might be able to interpret it better.

  14. #29
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Good morning sir
    I'm so sorry to bother you
    Thank you very much
    You can see this thread
    https://www.accessforums.net/forms/m...eld-41657.html

  15. #30
    Xipooo's Avatar
    Xipooo is offline Sr. Database Developer
    Windows 8 Access 2013
    Join Date
    Jan 2014
    Location
    Arizona
    Posts
    332
    أنصحك طرح الأسئلة الخاصة بك هنا وليس في رسالة خاصة. هناك المزيد من المعرفة تراكمي من هناك في شخص واحد يسأل واحد.

    Google Translated:
    I recommend you ask your questions here and not in private message. There is more knowledge cumulatively than there is in asking one single person.

Page 2 of 3 FirstFirst 123 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Billing first 2 hrs at one rate
    By wnicole in forum Queries
    Replies: 9
    Last Post: 12-12-2013, 07:18 PM
  2. Billing DB form
    By Symlink in forum Access
    Replies: 47
    Last Post: 07-30-2013, 08:37 PM
  3. time and billing DB
    By gpnhmiller in forum Access
    Replies: 4
    Last Post: 12-31-2012, 04:27 PM
  4. Multiple Payment Instances
    By luckysarea in forum Queries
    Replies: 3
    Last Post: 04-21-2011, 03:29 PM
  5. Client Payment History
    By GMatos78 in forum Access
    Replies: 4
    Last Post: 04-24-2010, 09:19 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums