I suggest two ways to do that.
Way 1 – One Database in one file
Create a table for Categories
Create a table for Suppliers
Create a table for Authors
Create a table for Locations
Create a big table for Items
This last table has to have all fields for every detail of each item. Later in your...
I agree completely with Golom and lespaul.
I would do this:
a.Create a new T/F field in the main table: SpecialCase.
b.Create the other fields you need in the main table.
c.In the form, make all these fields invisible, but the T/F field. That way you do not see them all the time. Then when you...
Do this:
1. Create a new query.
2. Put your table you need to update
3. Take the field you need to update
4. In the criteria row, write: Is Null
5. Go to the toolbar and select Update query
6. In the Update To row put the number: 0
7. Now run the query (with the ! icon in the toolbar). You will...
I have a question. In the real world do you keep this particular film separated in three groups (by purchase price) or they are mixed?
If they are mixed, how do you know the 4 films you are selling belong to the first group?
No. That is not solve the problem.
For the first question, I suggest do this.
1. Create a table for Formats. Looks like FormatID, Format (to put DVD, VHS, etc.)
2. Create a table for the film. FilmID, Title, etc. Like your first table above.
3. Create a third table FormatReg. Looks like FilmID...
Hi!
I hope this solve your problem.
In your query add a field: LastWeek: DatePart("ww",[your field Date]), and in the criteria of this field put this: =DatePart("ww",Date())-1.
That’s it.
You did well. I'm glad you're happy now.
Your two first queries were correct. But the trick (suggested by dhookom & cheerio) was not to join them (like you did) but nest them (put one inside the other one).
Join them is like compare two tables and you cannot make changes. Nest them acts like a...
I did it. Perfect!!!
What dhookom and cheerio said it is worth a star!
Do this.
1. Create a new query. Put the Student table and create the field for the Name. (It will look like your qsel#2)
2. Now see this. It is your query a little modified: In ((SELECT DISTINCT SumAcadStudents.SSN
FROM...
1. Create a new table with the same fields the old one.
2. In the new table, add a field with Autonumber datatype.
3. Save it but do not open it nor write anything in there.
4. Create a select query with all fields of the old table.
5. Then, convert that query in append query and choose the new...
Ok. Again. You have to uninstall Office completely. Then Re-install it. Choose the option "Custom" or "Customize" (I don't remember), then when you see the Office Application-tree (each application has a little arrow), choose from the most up level "Run all from my Computer" to get installed all...
Mitchy,
You cannot convert a number field to autonumber field. You have to create another field with autonumber data type. Add a new field and the numbers to existing records will be added automatically. Same to new ones.
Thanks BnPMike. I thought I was missing something new. It's OK your point.
But if people don't understand relationships, they cannot build a very good application and can lose data in orphan records.
Orphan records can lead to inaccurate results.
Thanks again. If in the future you know something...
Hi!
Go to Tools->Database Utilities->Link Table Manager. If you don't see it, probably you have not installed MS Access completely. Then, You should install it again and choose the option "Complete".
Olaf4
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.