Forum Home
Press F1
 
Thread ID: 60650 2005-08-08 21:20:00 MSAccess 2000 Brucem (8688) Press F1
Post ID Timestamp Content User
379486 2005-08-08 21:20:00 I am developing a small database to accept entries for a show. Each exhibitor can have more than one entry in each class, and I need to print cards for each entry. The entries table has Class, Exhibitor, and Number of entries fields, and the last field govers the mumber of cards printed.

As usual, help only works if you know the question to ask, which probably means that you know the answer.

Can anyone help?

Brucem 		Brucem (8688)
379487 2005-08-09 00:20:00 I am developing a small database to accept entries for a show. Each exhibitor can have more than one entry in each class, and I need to print cards for each entry. The entries table has Class, Exhibitor, and Number of entries fields, and the last field govers the mumber of cards printed.

As usual, help only works if you know the question to ask, which probably means that you know the answer.

Can anyone help?

Brucem
Just defining the problem: You have


Entries Table¬
exibitorID ----->Exibitor Table¬
classID -¬ exibitorID
other | name
random | etc
feilds |
|
------>Class Table¬
classID
classDescription
etc

And you need to generate a report that shows each of the entries, with a counter on it?

Is this correct? (particulary the data structure)


-Qyiet 		qyiet (6730)
379488 2005-08-10 21:07:00 Thanks for the reply, your diagram is correct, and one of the fields in the entries table is Numberofentries. I need to print one entry card for each entry.

Brucem 		Brucem (8688)
379489 2005-08-10 22:44:00 Thanks for the reply, your diagram is correct, and one of the fields in the entries table is Numberofentries . I need to print one entry card for each entry . Not quite sure what numberofentries is for . It sounds like a running total, but it would be odd put that information with each entry . Oh . . I missed the primiary key from the entries table . Is that it's use?

OK . . first thing you need to to is pull all the data togeather . You do this using a query (sorry if I sound like I talking down to you, I'm unsure of your level of knowlage here) .

Something like this should work


SELECT
entries . *,
exibitors . *,
class . *
FROM (entries
LEFT JOIN exibitors ON entries . exibitorID = exibitors . exibitorID)
LEFT JOIN class ON entries . classID = class . classID;


You should be able to copy and paste from the code section to a new SQL query . then replace my table names, and key feild names, with the ones you use . Then just switch back to design view in the query, and you'll have a graphical layout of the query .

Then you create a report using the query we just built . Get it's layout how you want your cards to appear, and you are set .

The report editor takes a bit of getting used to, and could be much better . But it does get there in the end .

-Qyiet 		qyiet (6730)
379490 2005-08-10 23:22:00 Following on from Qyiet's posts, if this is going to be an annual show then you might want to include a table of shows (e.g. date, location etc.). When you refer to the number of entries, are you taking about the number of exhibits put on by an exhibitor or the number of free passes issued for their staff? Or something else?

A 		andrew93 (249)
1