Search results
-
beginner - easier to have big table & subdivide it or have couple table sharing ID?
Re: beginner - easier to have big table & subdivide it or have couple table sharing I By storing the data once then you obviously save a lot of storage space compared to flat files. That is why a properly normalised database is an efficient means of storing and processing data. It is always...- Rabbie
- Post #17
- Forum: Theory and practice of database design
-
Beginner needs help on table structure
In general Access tables should be long and thin not short and wide. I would advise you to google database normalization and then check your design. In my experience if you have a properly normalised DB then it is much easier to write meaningful queries and to add extra functions later... -
Running balance with multiple entries the same date
One way to resolve this would be to store the date and time of each transaction. You could just display the date but the records would sort in the correct order. -
-
Odd Behaviour of Int() in Function
IIRC this sort of problem is due to conversion from Real to Integer. REal is stored as a floating point number and this can lead to small inaccuracies/rounding errors when it is displayed. -
-
Question question about relation in access
qupe, it is good manners not to nag people to reply every 12 hours. It just irritates the people who may help you. Remember all the answers come from people who do it out of the goodness of their hearts. From the bottom up your episode table should be linked to your season table and your... -
Help with calculated table fields
This rings alarm bells for me. Calculated fields in a table should be a no-no because the calculation Isi lye performed once when the record is inserted. This means that if one of the fields used in the calculation changes the calculated field does not unless you take special steps to... -
-
-
Happy Birthday Anthony Gerrard
HappyBirthday, Anthony Who is a regular Watercooler contributor- Rabbie
- Thread
- Replies: 2
- Forum: The Watercooler
-
runtime ERROR 2471 in DLOOK
Thread moved to correct place. Ian please do not post technical queries in the introduction thread- Rabbie
- Post #6
- Forum: Modules & VBA
-
-
-
-
Recordset not updateable
This link gives you the possible reasons why a query may not be updateable. Hope this helps -
-
Text alignment for queries
In my opinion it is best i people remember that tables are for storing data, queries are for selecting data, forms are for inputting and displaying data and reports are for displaying data often in printable form -
Is it worth working?
Doc, as usual you havegot it right:). As a retired pensioner I can't tick the employed box (except for all the work I do assisting Mrs Rabbie in her business) but I do enjoy my life. Currently on a ski-ing holiday in Bulgaria 27 years after my last skiing trip. Surprisingly it has all come...- Rabbie
- Post #109
- Forum: The Watercooler
-