Adding fields from Switchboard or Form

J

JeswinJoseph

Hi, I am a total amateur at Access, and still studying it.
I wanted to know how I could add a field on an existing table, from the
switchboard or from a Form....

For example,
I have to put in different dates for different inventory checks, and I would
like to the user to enter the dates themselves(with the corresponding data).
how is it possible?
 
C

cmtrain via AccessMonster.com

You need a date field in the table. When you create a form based on this
table, the date field will be there. When you add a new record, users will be
able to enter their own date and other needed info.
Could you supply a list of fields you need and tables being used?
Chris
 
J

JeswinJoseph

Hi sorry for the late reply...
Thanks for your prompt response.
Yes I understand the need of a date field in the table.

The List of fields in my table:
1. Category
2. Item / Product
3. Unit
4. Date -> Number of items reported on that particular date,

but the problem i'm facing is that... the date is required to be entered by
the user, and under different dates, are "number of items counted on that
date".
Everything else on the table remains the same.

So when the main switch board pops up,
I want the user to choose the fields from an option group, and the user
needs to enter the date, and the number of items corresponding to that
particular date.

And the number of items comes under that date, so basically i want a date
field(entered by the user on the form), and number of items as its field
values.

I'm not sure if you understand what i am trying to convey.

I can send u an excel file, to get you a more clear idea of what i'm trying
to say.

It would be great if i could receive any sort of help.

Thanks,
Jeswin Joseph.
 
Top