Income tax receipt numbers

[Bob Hughes]

I want to create income tax receipts from new information appended to a
table. I would like to be able to append several records at one time and
increment the receipt number for each new entry starting at the previous
highest number.
Is this possible in 1 query, or do I have to loop through each new record?

Bob

 

[Bob Hughes]

I want to create income tax receipts from new information appended to
a table. I would like to be able to append several records at one time
and increment the receipt number for each new entry starting at the
previous highest number.
Is this possible in 1 query, or do I have to loop through each new
record?

Bob

That what I thought. I'll just loop trough the records. I'm never sure if I
ask tough questions or don't phrase them properly. Thanks anyway.
Bob

 

[Tom Ellison]

Dear Bob:

About your question:

Giving it less than 24 hours on a weekend isn't really going to get
you a sure answer.

For my part, I can't tell enough about what you're asking to be able
to reply.

You're going to "append several records at one time." Where is the
data residing while it's waiting to be inserted?

Why not just use an autonumber for the receipt number and be done with
it? That would assign a unique number every time you insert.

If you use a form to enter the data, and it is bound to the table, it
will add new records as you go. If you have this receipt number
autonumber assigning new numbers will be done for you.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

 

[Bob Hughes]

Your right of course. I was in a hurry to get this done & out of the way.
Its for an organization that I volunteer my time to. As a retired person
I loose track of days of the week

I wanted to create income tax receipts and the receipt number has to
start at a particular one. Autonumbers would be great if I could force
the starting number.

The main data resides in a table with all members info in it. I then
append new donation info to a table that simply keeps track of all
donation information for the purpose of issuing tax receipts & storing
info for the tax department. I think they want 7 years of history. The
latter table has just been created & so far is unpopulated because
someone else was doing this & did not keep very good records. I am just
in the process of programming this whole procedure & creating a tax
receipt report.

In the main I have given up on bound forms because I found them to
difficult to manage. I prefer unbound forms with a manual update button

Thanks for taking the time to reply.

Bob