Page 4 of 4 FirstFirst 1234
Results 46 to 53 of 53
  1. #46
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    7,335
    At least some data is needed? Unless it makes your compacted and zipped copy too large, might as well leave it in.

  2. #47
    inke01 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    May 2020
    Posts
    31
    I was away for last five days. i'll make copy of db and erase data so i can post it.

  3. #48
    inke01 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    May 2020
    Posts
    31

    Db beklab

    BEKLAB.zip
    Here is db with some data that we can use, this is closest version to my original db.
    And all tables and querys are for modifying.
    Now we can start from here.
    There will be 3 versions of report that need to calculate somatic_cells (somatske_stanice) and bacteria(broj_bakterija).
    Somatic cells are calculated by forumala geometric mean so somatic_cells= n sqr (n1*n2*nn) and it has to take parametras from last three months for every single co buyer.
    Bacteria are same formula but they are calculated on last 2 months.
    I can make next: somatic cells are allways in thousends and millions so it can insead of: 1.192.000 been writen 1192 and on report add field x1000
    Click image for larger version. 

Name:	BEKLAB 1.jpg 
Views:	26 
Size:	163.2 KB 
ID:	42746
    Last edited by inke01; 08-20-2020 at 12:55 AM. Reason: Adding pictures

  4. #49
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    7,335
    I tried to send you a PM about this but as I said in post 44, I cannot. This is what I get:
    The following errors occurred with your submission
    inke01 has chosen not to receive private messages or may not be allowed to receive private messages. Therefore you may not send your message to him/her.
    If you are trying to send this message to multiple recipients, remove inke01 from the recipient list and send the message again.


    this is what I tried to send:
    just downloaded today, will try to review issue over the next 2 or 3 days and see what I think.
    Hopefully the language will not be a problem.


    If you think you have allowed PM's then perhaps you should contact a forum administrator to find out if you are being prevented from receiving them.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

  5. #50
    inke01 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    May 2020
    Posts
    31
    i just send message to administrator to see where problem ist. If u have any problems with language just ask i will translate or rename it.

  6. #51
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    7,335
    I dropped my laptop. HD might be damaged. If I have to replace pc I will be out of commission for a while.

  7. #52
    Bob Fitz's Avatar
    Bob Fitz is online now Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    2,690
    Quote Originally Posted by Micron View Post
    I dropped my laptop. HD might be damaged. If I have to replace pc I will be out of commission for a while.
    Sorry to hear that
    Hope you get it sorted out soon
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  8. #53
    inke01 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    May 2020
    Posts
    31
    Dont tell me now that in middle of problem... hope the hdd is not damaged

Page 4 of 4 FirstFirst 1234
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 12-18-2019, 02:57 AM
  2. how to place a multiply in a query
    By darwin in forum Queries
    Replies: 6
    Last Post: 05-14-2015, 03:56 PM
  3. Opening multiply Forms?
    By djclntn in forum Forms
    Replies: 10
    Last Post: 04-02-2013, 04:20 PM
  4. Ado update for multiply records
    By thanosgr in forum Access
    Replies: 26
    Last Post: 03-16-2012, 01:26 PM
  5. Multiply front end on same computer?
    By efk0107 in forum Access
    Replies: 5
    Last Post: 01-25-2011, 08:39 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 - Senior Forums