G
Guest
I am creating a system to keep track of the subscribers to a very small
newspaper I work for.
And I want to create a query to check if the subscriber has paid the yearly
fee within 30 days after the bill have been sent out.
So 30 days after the customer is registered in the database (field
"Registrert"), and if the date of payment field is empty (field "Betalt"), I
want them to appear in the query list.
Both the "Registrert"-field and the "Betalt"-field is Date/time fields, with
an input mask that creates the date like this: dd.mm.yyyy.
Sincerly,
sebross
newspaper I work for.
And I want to create a query to check if the subscriber has paid the yearly
fee within 30 days after the bill have been sent out.
So 30 days after the customer is registered in the database (field
"Registrert"), and if the date of payment field is empty (field "Betalt"), I
want them to appear in the query list.
Both the "Registrert"-field and the "Betalt"-field is Date/time fields, with
an input mask that creates the date like this: dd.mm.yyyy.
Sincerly,
sebross