Recent content by XPS35

The best method is not to duplicate your database. One database for all years is the best. Year (date) should be a field in your tables and should not be in the name of a database or a table.

I guess it starts with me.parent..........

As said in post #3 there is no use in looping through all the records. The real action (print the report) is outside the loop. This will do: Public Sub KnopBriefAfdruk_Click() DoCmd.OpenReport "ledenbriefRap" End Sub

Welkom. Zoals je merkt, is de voertaal hier Engels. Maar daarvoor is Google Translate je beste vriend. Welcome. As you can see, the main language here is English. But for that, Google Translate is your best friend.

Long does not have decimals. Use Dim XXX as Single.

Is the number always 7 positions?

This one is updateable....

Use a query to select the records with the current date. Something like SELECT * FROM TOC WHERE TocDate = Date()

Sorry, I didn't read your question completely. Nevertheless, I agree with the others that it is not necessary to record the previous value. After all, it is in the previous record and therefore you do not have to record it again. Make sure you have a field in your table that allows you to...

What's the point of having a table with duplicate records? Please tell us more about the background of this question so we can better assist you.

It is a bad idea to store that in your table. You need to run the query every day. Make a query with a calculated field and you can always show the right value at the current date

Eberhards solution (MID) will do.

That depends on whether the prefix is always the same number of positions long. And if that is not the case, then it always ends with a /?

Or WHERE YEAR(YourDateField) = YEAR(Date()) - 1

Every four of the records in table 1 that has matching records in table 2 has two matching records there. Every combination is shown. Add DISTINCT to your query to eliminate duplicates: SELECT DISTINCT Table1.Payer, Table1.ClientName,...............