Forum home » Delegate support and help forum » Microsoft Access Training and help » access database course - Maximum columns

access database course - Maximum columns

ResolvedVersion Standard

Mon 4 Jun 2007, 14:40 Delegate Andrea said...

Andrea has attended:
Access Introduction course
Access Intermediate course
Excel Advanced course
Access Advanced course
Excel VBA Intro Intermediate course

Maximum columns

is there a maximum number of columns I can have in a query?

Mon 4 Jun 2007, 15:26 Trainer Tracy said...

RE: maximum columns

Hi Andrea,

Thanks for the question

No you can as many columns as you like in a query as long as the information is available from your table.

Tracy

Training courses

98.2 % recommend us

More live stats...

Training information:

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

View all Access hints and tips