Search results

If data is being encoded in table names you should certainly do that. A fundamental principle of the database relational model is the Information Principle (Codd's Rule #1). This requires that all data be stored as single values at column positions in rows in tables, and in no other way. This...

The attached file illustrates how non-normalized data from Excel (or any similarly structured source such as a delimited text file) can be decomposed into a pre-defined set of normalized tables in Access. When inserting the appliance data into a table, your current string expressions can be...

Be sure to have a referenced Lanes table, with a single column Lane as its primary key. Then create a relationship between this and the trees table and enforce referential integrity. This will protect the integrity of the database by ensuring that only valid Lane values can be entered into the...

As a variation on DHookom's solution you might be able to aggregate the relevant values in subqueries in a single query, rather than joining multiple queries. The following query is a simple example which, in addition to the individual transaction details, returns the sums of the credit and...

One context in which they are useful is in referencing academic sources. The following is an example of Harvard citation format, which is commonly used in the UK: Thagard, P. (1990) ‘Philosophy and machine learning’, Canadian Journal of Philosophy, 20(2), pp. 261–276.

Then I guessed right! Perhaps, as I approach 80, the grey matter is in better fettle than I normally assume to be the case.🦉

In the early days of spell checking we fed all our names in the family into a document to see what it came up with. My wife Fiona Sheridan was changed to Viola shredding!

I'm a little unsure about the relationship type between tblDwgReg and tblDwgTypes. At present its many to many, modelled by tblDwgRegDetails. This is predicated on the drawing type being an attribute of the relationship type, i.e. revisions of the same drawing can be of different types, rather...

I've just unzipped it again. Now it does open in Report View!

Not in my case. All open in Print Preview.

As noted in your earlier thread, I am unable to reproduce the behaviour you are experiencing. More fundamentally, however, I think your model needs amending as below to avoid the current encoding of data as column headings in tblProjects: PS: I've just noticed the redundant DrawingID column...

I've been unable to reproduce the behaviour which you are experiencing. All of the reports open correctly from the links in the frmDwgReg as expected, and can be printed without any issues. However, by having multiple columns for the different design consultant types in the tblProjects table...

There are many instances of this with authors' names, e.g. F Scott Fitzgerald, H Rider Haggard (though I did come across one edition of 'She' where the authorship is given as Henry Haggard). In bibliographical contexts I generally use a single Author column with the full name by which they are...

My American partner and I once built a database of enslaved persons for a museum in the USA (she, an archivist by trade, did the research, I built the app). In the source material an enslaved person was often referenced by their first name only, and there were varying forms of this in many...

I would favour modelling Editions by a separate table referencing a Drawings table. That way attributes which are common to all editions are recorded only once, in a row in the Drawings table, whereas attributes which are not common to all editions are recorded in rows in the Editions table...

Having separate FirstName and LastName columns in a base table will generally be preferable as it allows a person's name to be returned in whatever format you want in a particular context. (FirstName + " ") & LastName would be used in most contexts, but in the RowSource of a combo box for...

Take a look at the attached demo file. A key feature of this is that the passwords, answers to users' security questions, and users' Windows user names are hashed. Such data should never be stored as the original text values. The demo allows each user to be granted different permissions to...

The following is an example of a query which returns a count of distinct values, in this case employers of contacts per city. It does this by means of a subquery in the outer query's FROM clause. The subquery includes the DISTINCT predicate to return only one instance of each each set of...

You should not repeat the names in the Voucher Log table, as this introduces redundancy and the risk of update anomalies. All you need in the Voucher Log table is the VeteranID foreign key column. In the subform you can then bind a combo box to that column, setting it up as follows...

The attached file illustrates the use of the functions in the following module. To return the accounting year for any date call the AcctYear function, passing the month and day of the month when the accounting year starts into the function as integer numbers, and the date for which the...