Reserved Words..what else?

[Guest]

I know there is a list of reserved words but i need to use fields like Date,
Description, etc....what can I use instead? Does anyone use anything else or
just ignore it?

Thanks

 

[BruceM]

I use words such as StartDate, EndDate, DueDate, ReportDate, or what have
you. I think you will make things easier on yourself in general if you use
descriptive rather than generic names for your fields and controls.

 

[Brendan Reynolds]

A list of what you could use instead would be practically endless. What I
would advise is, think about what date is this? What happens on the date you
are recording? Is it the date an order was placed? Call it OrderDate. The
date an invoice was raised? Call it InvoiceDate. The date an employee was
hired? Call it HireDate. Etc., etc., etc.

On those rare occasions when you really are forced to use a reserved word as
a field name (because you need to work with a database that was designed by
someone else and you're not allowed to change it) you can usually avoid most
problems by enclosing the field name in square brackets, e.g. "SELECT [Date]
FROM SomeTable" if the table "SomeTable" contains a field named "Date".