microsoft training access course - date time

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft training access course - Date$ Time$

microsoft training access course - Date$ Time$

resolvedResolved · Low Priority · Version Standard

Clare has attended:
Access Introduction course

Date$ Time$

Can you please tell me what the dollar sign represents in the Built in Functions under Functions under the Build option.
There seems to time, time$, date and date$ - what is the difference between them?

RE: Date$ Time$

Returns the current time. Time$()gives it as a string.

Gives today's date. Date$() gives it as a string.

A "string" is a series of bits that represents some piece of text in human language. What you're reading now is text. Strings are how this text is represented inside a computer.


 

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips


Server loaded in 0.09 secs.