Search results

  1. C

    Solved multi page report, bottom of the page take the date of the last record of that page

    ok, thx. It works didn't realise it was that simple.
  2. C

    Solved multi page report, bottom of the page take the date of the last record of that page

    currently I have a date field added to the footer but that just prints the current date. could you explain how I could use the date of the last field on a page to put that date on the bottom ?
  3. C

    Solved multi page report, bottom of the page take the date of the last record of that page

    Hi, I have a report of 98 pages. Each line on the report starts with a date and then more info. On the bottom of the page, in the page footer, I want to use the date of the last row printed in the report, is this possible? simple example 20-12-2020 test 1 testing 21-12-2020 test 2 fail...
  4. C

    Starting a new dbase

    Mike60smart: exactly what I need to understand the joined 3rd table better and change it to what I need. Thx
  5. C

    Starting a new dbase

    Thx for the answers. MickJav: for some reason I can't download anything from databasedreams... Plog: I've used junction with my 2 tables to create a 3rd table. I've been trying all day now to create a form which does: dropdown box with names (showing 1 name) And next to it a list of the 2nd...
  6. C

    Starting a new dbase

    Hi all, I'm starting a new DB for a new hobby project. I have a table with people and I have a table with tasks. Every person can have multiple tasks. How can I best set it up: Person table John Amy Pete Task table fix car pay bills read book How can I make a link between the 2 tables and...
  7. C

    Use textbox value of 1 report to autofill a textbox in another report

    That helped 50% thx. Now the info is not duplicated but the report still produces 1968 empty reports...?
  8. C

    Use textbox value of 1 report to autofill a textbox in another report

    I don't have that option in my report. I can choose "reportview" or "print preview" in the default view section
  9. C

    Use textbox value of 1 report to autofill a textbox in another report

    Where can I set the report as a single, not continuous?
  10. C

    Use textbox value of 1 report to autofill a textbox in another report

    Sadly it's not working yet. I do get my sum but for some reason it repeats itself many times. I've readup on it and it's not the width of the page. Report record source = mytable Then in the detail section on the text box I've put =Sum([Nighttime]) But it repeats about 1968 times. Any idea...
  11. C

    Use textbox value of 1 report to autofill a textbox in another report

    Solved it. Forgot to setup the main Table as the source. Now the expression works. And since that table is the main source, I should be able to get all different totals out from it with sum if. thx !!
  12. C

    Use textbox value of 1 report to autofill a textbox in another report

    :unsure: that could be the easy answer I was looking for. This is the query: SELECT totaaltabel.Nighttime, totaaltabel.Type FROM totaaltabel WHERE (((totaaltabel.Nighttime)>0)); And then I use the query to form the report with at the bottom a text with the total using =sum(nighttime). How will...
  13. C

    Use textbox value of 1 report to autofill a textbox in another report

    Hi all, This must be very simple but I'm stuck for hours, googling, trying etc. Simplistic version. Report 1 has a list of values and at the bottom a sum of these values in a textbox (lets call it total). Report 2 has a textbox and in this textbox, the value of total. I've tried in properties...
  14. C

    Report with multiple totals

    Thx again jdraw, perfect. I should have managed this one myself as I have many reports build like that, was too focussed on doing it in a Query :-(.
  15. C

    Report with multiple totals

    Jdraw, I've got it working in my Dbase, works quick and perfect. Is it possible to get a total under the 365 90 and 30 day column? thx
  16. C

    Report with multiple totals

    That is exactly what I need. Thank you. I will try and put it in my access DB.
  17. C

    Report with multiple totals

    I've tried 'union' but that didn't give me what I was looking for. SQL: SELECT DISTINCTROW totaaltabel.Type, Sum(totaaltabel.Duration) AS SomVanDuration FROM totaaltabel WHERE (((totaaltabel.Date)>Date()-90)) GROUP BY totaaltabel.Type HAVING (((totaaltabel.Type)<>"FNPT2")); union SELECT...
  18. C

    Report with multiple totals

    Hi all, I've used access for many years and now I want something out of it that I can't get 1-2-3. I have a huge datebase where flight hours are logged. Now I want a report that shows a total of flight hours: since the beginning , last 365 days, last 90 days, last 30 days. example. 01-01-2020...
Top Bottom