Needs advise

[richardplr]

Hi

I really need advise/help from you guy.

I intend to create a inventory database. (Currently, I am using Excel to do it) because I have converted all my work from excel to access. Attached please see my inventory record in Excel form.

I have created a table with many month field & also many field for stock, I think that take up too much space. So, I hope someone can guide me how I should be done.

Thank you

 

[ecniv]

Look up tables - each has a unique id field
- Items
- Units
- Scheduled Checks

Main table
- uniqueid to refer to
- ItemID
- UnitID
- Checked Date
- Amount

Then use queries to gather information into a format you want.

Vince

 

[richardplr]

Look up tables - each has a unique id field
- Items
- Units
- Scheduled Checks

Main table
- uniqueid to refer to
- ItemID
- UnitID
- Checked Date
- Amount

Then use queries to gather information into a format you want.

Vince

Hi Vince

Thank you for your respond. I have thought of this way but I could not get the month in horizontal like my excel format.

If I do it this way, i can only get my month in vertical. Can you should be example how should I come them.

Thanking you for your help.

 

[Rich]

Access isn't a spreadsheet, although a Crosstab Query will display the results horizontally you will not be able to enter data into the form.
If you want your form to perform in the same way as a spreadsheet you'll have to write the code for it

 

[richardplr]

Access isn't a spreadsheet, although a Crosstab Query will display the results horizontally you will not be able to enter data into the form.
If you want your form to perform in the same way as a spreadsheet you'll have to write the code for it

Wow, tough.

Anyway, thank for your response.

Bye