Originally Posted by
mariekeb
However, not sure what you mean by spreadsheet design. I'm making a database for publications from my organisation, and the fields I want to filter contain info on author, publication date, title, etc. These are the collumn headings. That's the right format I believe?
"Committing spreadsheet" would be a table design that looks like it was designed for a spreadsheet.
An example of a table designed like a spreadsheet would be to have fields
Code:
OrderNumber, CustomerNumber, OrderDate, Qty1, Item1, Product1, Qty2, Item2, Product2, Qty3, Item3, Product3, Qty4, Item4, Product4
To add a 5th product, you would have to add 3 more fields (Qty5, Item5 & product5). This means you have to modify tables, queries, forms, reports and probably VBA code (every time you want to add another product).
In a normalized table design, you would just add another record - no modification required.
This is why I made the comment about "Committing spreadsheet".
In your first post, you have an example of searching 6 fields using the text entered in "Tekst24".
Code:
[Field 1] Or [Field 2] Or [Field 3] Or [Field 4] Or [Field 5] Or [Field 6] Like "*" & [Forms]![Query2]![Tekst24] & "*"
If you are searching 6 fields for the same search term, this is generally an indication of a non normalized structure. For example, you have fields "author, publication date, title". If you are looking for an Author, doesn't make sense to search Pub date and Title fields..... but I don't know your table structure....
I am probably wrong...... the search code just looked wrong...