By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,608 Members | 1,698 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,608 IT Pros & Developers. It's quick & easy.

Costings database

P: 19
I wanted to make a new database for my company but ran into a problem. I dont know how to create a table for the costings with the required fields i need.

Here is a scan from part of the spreadsheet.

Is there a way to create or get around the X and Y fields
Aug 27 '08 #1
Share this Question
Share on Google+
4 Replies

Expert Mod 2.5K+
P: 2,545
Hi. I had a look at the scan you mentioned but it gives no clue at all as to what you are asking. If you could be more specific about your question I'm sure we will do our best to assist you.

In the meantime you may benefit from reading our HowTo article on database normalisation and table structures.

Aug 29 '08 #2

Expert Mod 15k+
P: 31,754
Did you mean create (as in design)? Or did you simply mean populate?
Aug 30 '08 #3

P: 19
populate, i cant figure out how to store date with multiple rows and colunms
Sep 8 '08 #4

Expert Mod 15k+
P: 31,754
Perhaps I should have been clearer in my last post.

The question I asked was simply to clarify one aspect of misunderstanding from your original post. This was following on from Stewart's already posted request to clarify the question generally.

There is simply far too little indication of what you want OR what you have already for me to be able to give any helpful advice at this stage.

This will work much better if you can post the meta-data (info about the layout / structure) of the table in the same way as I use in my example. Click on the Reply button and you will have access to all the codes I've used. PK & FK stand for Primary Key & Foreign Key respectively. Please don't use any TABs in your formatted layout as this will not display correctly - Spaces only for layout.
Table Name=[tblStudent]
Expand|Select|Wrap|Line Numbers
  1. Field           Type        IndexInfo
  2. StudentID       AutoNumber  PK
  3. Family          String      FK
  4. SName           String
  5. University      String      FK
  6. Mark            Numeric
  7. LastAttendance  Date/Time
Sep 8 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.