Adding feild

[dkbrostyle]

Hi i would like to use a query to add a field. What i have done is designed two tables one is a supplement table and the other is a pricing table. The pricing table has the prices which can be changed by my end user. The supplement table which is an upgrade in breakfast, would define the number of each item would need to be upgraded.

What i have tried to do is design a query which adds the prices together than a total query which would add all the prices together, but the problem i faced was that i wanted to hide the pricing column and i insert a new column to add them up together. But this did not work at all.

I'm confused and i would like some help with this coursework deadline is for wednesday.

Thank you very much for your help and time.

 

[anvil19]

Hi dkbrostyle

To add a Field (Column) to a database you use the ALTER TABLE statement, like so:

ALTER TABLE <TableNameHere> ADD <FieldNameHere> {DataType};

where {DataType} is a valid data type eg. Text, Short, Byte, Memo, Boolean etc, etc, etc. If the datatype is a number or text etc. then add a size or Access will add a default size that can be huge (in the case of Text it's 255).


Remember to back up your database before trying this, just in case.....
Try that.

anvil19