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 ?
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...
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...
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...
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...
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 !!
: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...
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...