Forum home » Delegate support and help forum » Microsoft Access Training and help » training for microsoft access - MS Access

training for microsoft access - MS Access

ResolvedVersion Standard

Wed 17 Oct 2007, 15:14 Delegate Khilan said...

Khilan has attended:
Access Introduction course

MS Access

When creating a query, is there a list of things you can have for the criteia? for example such criteria like '>1 and <=2' OR 'Between 1 and 2'. Is there a list of where all these can be found? Thanks

Mon 22 Oct 2007, 16:19 Trainer Richard said...

RE: MS Access

Hi Khilan

This particular website will give you some excellent references rehgarding criteria.

http://office.microsoft.com/en-us/access/HA100666111033.aspx

Also, have a look at the attachment to this post, as it contains some of the major operators.

Regards

Richard

Attached files...

Training information:

Access tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips