RE: Ken Sheridan!!!

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

It can be done, but it does require that all columns other than the
autonumber can be Null, i.e. have their Required property False. Now its
very unlikely that all columns should legitimately be Null, so it does
potentially undermine the integrity of the database. If you are prepared to
accept this then you can do it manually simply by entering something into one
of the non-key columns, and then delete what you've entered. As soon as you
start to enter data the autonumber value will be generated. If you want to
automate it you can do so by running the following 'append' query which
inserts a row with the highest existing value in the autonumber column + 1:

INSERT INTO YourTable (YourAutonumberColumn)
SELECT MAX(YourAutonumberColumn)+1
FROM YourTable;

Now I'd be interested in hearing what this reason is. It sound like an
Irish reason to me<G>.

Ken Sheridan
Stafford, England

"duchessofireland" wrote:

Once again you are my hero!!! Everything is working absolutely lovely. I
lied though....Got one more question...lol I'm wondering if there is a way
to create dummy records. I just want to have a record that has a autonumber
assigned to it, but have the information blank. I want to be able to go back
later and fill in the information. I know it sounds stupid, but I have a
reason (believe it or not)... You are such a wonderful help! Thanks so much
for your patience!

"Ken Sheridan" wrote:

There was a problem the other day. I found I'd posted one reply 5 times!

Sorry for the delay in replying; I've only just spotted your post.

The report shouldn't be difficult. Firstly join the three tables in a
query; Jobs to Assignments on JobID, and Assignments to Employees on
EmployeeID. Add whatever fields you want to show in the report from Jobs and
Assignments to the query design grid; you can include as few or as many of
the available fields as you wish. When you open the query you should see
multiple rows fro each job and the employees assigned to them.

As you are using the query as the basis fro a report don't sort on any
fields. The report will just ignore this. You do the sorting in the report.

You can use the report wizard to create a report base on the query. Group
it by job so each job will be listed as a group heading with the group of
employees assigned to the job listed below. You don't have to accept
completely what the wizard produces; you can open the report in design view
at any time and amend its design.

Ken Sheridan
Stafford, England

"duchessofireland" wrote:

I've tried twice to reply to the previous question that I asked....Not
showing up. So here it goes again...a new thread.

First and foremost...THANK YOU!!!! YOU ARE MY HERO!!! I went back through
everything and made sure it was all lined out the way that you had said. It
works! Yeah! One more question....I think this should do it.

Now I am entering my data into the form and subform. I want to query (I
think) to create a report that will show all my jobs and all the employees
that were assigned to it. I tried doing it the way I thought it should be
done. No such luck. It gives me an error message about being unrelated.
Sorry...and thanks again!


.

Relevant Pages

  • RE: Ken Sheridan!!!
    ... The report shouldn't be difficult. ... query; Jobs to Assignments on JobID, ... multiple rows fro each job and the employees assigned to them. ...
    (microsoft.public.access.gettingstarted)
  • Re: Running Sum in a Query?
    ... Why do you so particularly want to do this in a query? ... on a report to =1, and set the running sum ... Record number 2 is deleted and a new record is added, using autonumber ... You're running sum is out the window. ...
    (microsoft.public.access.formscoding)
  • RE: Ken Sheridan!!!
    ... my report is to act as a "worksheet". ... query; Jobs to Assignments on JobID, and Assignments to Employees on ...
    (microsoft.public.access.gettingstarted)
  • RE: Ken Sheridan!!!
    ... You can place vertical lines and boxes from the toolbox on a report provided ... 'Irish' way. ... query; Jobs to Assignments on JobID, ...
    (microsoft.public.access.gettingstarted)
  • RE: Ken Sheridan!!!
    ... The report shouldn't be difficult. ... query; Jobs to Assignments on JobID, ... multiple rows fro each job and the employees assigned to them. ...
    (microsoft.public.access.gettingstarted)