corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » Geek Day » microsoft access


New Topic
New Poll 		  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author microsoft access
CorsaLad
Member
Registered: 25th Sep 01
User status: Offline
3rd Mar 03 at 21:54   View User's Profile U2U Member Reply With Quote
please reply if u have a good knowledge of microsoft access, 2000 in particular. this help is for my final a level coursework and so i would appreciate any help!

thanks

james
Jodi_the_g
Member
Registered: 7th Aug 01
Location: Washington D.C
User status: Offline
3rd Mar 03 at 21:54   View User's Profile U2U Member Reply With Quote
I can help you, I also had to use it for my a-level course work
CorsaLad
Member
Registered: 25th Sep 01
User status: Offline
3rd Mar 03 at 21:56   View User's Profile U2U Member Reply With Quote
ok cool!!

i am creating a system for a hardware/software resale company. my system is nearly complete, but i need to create an invoice. do u think a report is the best way to do this?
Jodi_the_g
Member
Registered: 7th Aug 01
Location: Washington D.C
User status: Offline
3rd Mar 03 at 21:57   View User's Profile U2U Member Reply With Quote
Yeah as you will need to print out an invoice to send out, therefore it will have to look professinal
Joff
Member
Registered: 17th Oct 00
Location: Cambridgeshire
User status: Offline
3rd Mar 03 at 21:57   View User's Profile U2U Member Reply With Quote
You would be better seeking help from a dedicated Access forum, or even help from your tutors - that's what they're there for.
CorsaLad
Member
Registered: 25th Sep 01
User status: Offline
3rd Mar 03 at 21:59   View User's Profile U2U Member Reply With Quote
joff - yeh i know that but ive left it a bit late!

jodi - ive tried to create an invoice based on a query, using a wizard but there doesnt seem any way to group the data on the invoice. what i mean is i could have orderID and the date in one box, customer details below it etc...
Joff
Member
Registered: 17th Oct 00
Location: Cambridgeshire
User status: Offline
3rd Mar 03 at 22:01   View User's Profile U2U Member Reply With Quote
CorsaLad - have you got an example of your DB schema?
Jodi_the_g
Member
Registered: 7th Aug 01
Location: Washington D.C
User status: Offline
3rd Mar 03 at 22:02   View User's Profile U2U Member Reply With Quote
I was about to ask the same
CorsaLad
Member
Registered: 25th Sep 01
User status: Offline
3rd Mar 03 at 22:03   View User's Profile U2U Member Reply With Quote
schema?
Joff
Member
Registered: 17th Oct 00
Location: Cambridgeshire
User status: Offline
3rd Mar 03 at 22:04   View User's Profile U2U Member Reply With Quote
Oh dear.
CorsaLad
Member
Registered: 25th Sep 01
User status: Offline
3rd Mar 03 at 22:06   View User's Profile U2U Member Reply With Quote
ive never heard that term before... do u mean relationships?
Joff
Member
Registered: 17th Oct 00
Location: Cambridgeshire
User status: Offline
3rd Mar 03 at 22:07   View User's Profile U2U Member Reply With Quote
Basically, yes.

The structure of your tables and any relationships between them (altho relationships aren't necessary).
CorsaLad
Member
Registered: 25th Sep 01
User status: Offline
3rd Mar 03 at 22:11   View User's Profile U2U Member Reply With Quote
i knew i wasnt that hopeless!

ill try and explain...


4 tables

customer, order, order line, stock

one customer can have many orders
one order can have many order lines
many order lines can have one stock item
CorsaLad
Member
Registered: 25th Sep 01
User status: Offline
3rd Mar 03 at 22:22   View User's Profile U2U Member Reply With Quote
.

 
New Topic
New Poll

  Related Threads Author Forum Replies Views Last Post
serves u right mr gates Richie Geek Day 29 2363
16th May 03 at 01:18
by Munchie		  
Data Access Pages ricKA Geek Day 0 1046
25th Mar 04 at 16:07
by ricKA		  
Help with Microsoft Access Ashton306TD Geek Day 4 1179
30th Apr 05 at 16:54
by Ashton306TD		  
Microsoft Access Related Question Bart Geek Day 4 782
5th Mar 08 at 19:43
by Kerry		  
Microsoft Access users Kerry Geek Day 3 725
6th Jun 08 at 23:05
by Corsa_Joel		  

Corsa Sport » Message Board » Off Day » Geek Day » microsoft access 28 database queries in 0.0101762 seconds