User Profile

Collapse

Profile Sidebar

Collapse
bibaudj
bibaudj
Last Activity: Mar 1 '07, 04:19 AM
Joined: Feb 11 '07
Location: London
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • bibaudj
    replied to Using templates to create automated invoices for customers
    in Access
    Eek, spologies for the delay. DB just emailed to you. Hoping that you can dissect and understand it for what you want. ;-)
    See more | Go to post

      Leave a comment:

    • bibaudj
      replied to Calculate year range function
      in Access
      Hi peeps, many apologies firstly that I haven't got back to you for so long (busy!)

      I managed to use the code from NeoPa as a basis with pointer from Dezi and 'cobbled' together what I needed in a calculated query field. When I'm free again I'll post the code/ query set-up I used, just for you to see - but it works a dream for what I wanted and couldn't have done it without your help!

      Thanks! ;-)
      See more | Go to post

        Leave a comment:

      • bibaudj
        replied to Using templates to create automated invoices for customers
        in Access
        Eek, I already have this DB created from a project I did long time back. Do you have an email address if you would like to see it?
        See more | Go to post

          Leave a comment:

        • bibaudj
          replied to Calculate year range function
          in Access
          Thanks peeps: NeoPa and ADezii. Yes, I did want the year returned in text format. I'll try both these out and get back to you.
          See more | Go to post

            Leave a comment:

          • bibaudj
            replied to Access having row like excel
            in Access
            Design a Report to display in this format based on the Query; alternatively just export the data to Excel!! ;-)
            See more | Go to post

              Leave a comment:

            • bibaudj
              replied to Using templates to create automated invoices for customers
              in Access
              By the sound of what you are asking, you just need to create a Query for your report to be based on. The Query should include fields from your Orders table and the required customer data fields from your Customers table.

              In order to advise further, we would need to know what tables you have, structure and relationships.
              See more | Go to post

                Leave a comment:

              • bibaudj
                started a topic Calculate year range function
                in Access

                Calculate year range function

                I'm trying to write a function to be used in a query - because I don't think it can be compiled directly in a query (using Expression Builder). This is for a holiday DB. I would like to determine and automatically calculate/ display which holiday year annual leave dates fall into, i.s. if date is 3 Feb 07 that would fall into holiday year 2006/2007, whereas 8 Mar 07 would fall into 2007/2008. Basically in English I think it would be:
                ...
                See more | Go to post
                • bibaudj
                  replied to Querying database by date
                  in Access
                  CustID has been assumed to be the name of your unique reference (ID) field for your customers, i.e. Mr Fred Bloggs may have ID 62079. Just change this name (CustID) to whatever field name you are using to uniquely identify your customers.
                  See more | Go to post

                    Leave a comment:

                  • bibaudj
                    replied to Help with Leave Date "window"?
                    in Access
                    Try working it out in 'English' first before progressing to code - that often helps and is the proper way to write code. Basically you are looking to find:

                    If StartDate is before Date1 and EndDate is after Date2
                    OR
                    if StartDate is between Date1 and Date2
                    OR
                    if EndDate is between Date1 and Date2

                    I think!
                    See more | Go to post

                      Leave a comment:

                    No activity results to display
                    Show More
                    Working...