Set up an Autonumber Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you get the auto number to pull only 1 specific account like the
expression is what i'm asking for? Heck while i'm asking I am runing a
monthly report but I need it to update or change every month so it will work
correctly please assist.

Thanks
 
Access Autonumbers are designed to be used as unique row identifiers, to
help in relating tables. I'm not familiar with using them "to pull only 1
specific account".

We aren't there, and you didn't provide an example of what you are talking
about, so "...like the expression ..." doesn't tell us nearly enough to do
anything but guess...

You mention "running a monthly report" needing changes/updates "so it will
work correctly", but provided no ideas on what it is doing wrong, or should
be doing, or what changes are currently needed, or ...

--
More info, please ...

Jeff Boyce
<Access MVP>

"CT. College Student Project" <CT. College Student
(e-mail address removed)> wrote in message
news:[email protected]...
 
Ok this is the situation. I have the telephone number as my primary key.
I'm building a database that will allow me to print a reciept when an order
is completed in a form. That form that I am using I want it to pull the
information from that current form (that I have just entered) and be able to
print that information in a report but only that one record not all of them.
That is the problem. These are the fields that I have in the table First
Name, Last Name, Address, City, State, Zip Code, and the Order Number. The
initinal question was how do I get a reciept printed for every new record or
use the account number as a way to select only that record in a query? In
the second table the fields that I have are Make, Model Color, Mileage,
License Plate. I would even be willing to accept a popup that would say
please input order number or license plate and then i type in the number and
the report is generated how do you do that. The monthly report thing I got
that figured out so don't worry about that.
 
If you have a form open on which you can select a specific record, you could
add a command button that opens a report. If you use the filter/where
portion of the DoCmd.OpenReport command, you can limit that report to the
record you are viewing in the form.

--
Good luck

Jeff Boyce
<Access MVP>

"CT. College Student Project"
 
Back
Top