Search results

  1. C

    Print preview

    This question deals with ACCESS 2002 and 2007. When I want to print a table or query, I bring up the print preview and make adjustments such as margins. Can this be saved so that I don't have to go through changing margins every time I want to print a table or query?
  2. C

    left justified field name

    In ACCESS 2002, can the field name be left justified? The same question for ACCESS 2007. If so, how?
  3. C

    Date format

    I inherited a table with a field for Birthday. In the design view the data type for this field is Text. The mask is 99/99/00;0;_. Thus all the entries are of the form mm/dd/yy. When I change the mask to 99/99/0000;0;_ I can now enter the complete year. However it does not change the existing...
  4. C

    Query satisfing two conditions

    I'm using Access 2002 A table contains a last name and first name field. There are an additional 14 fields A, B, C, ..., J indicating jobs assigned using the yes/no data type. Generally an individual is assigned only one job. A check mark is put in that cell. There are a number of individuals...
  5. C

    Maximize opening screen

    The window I'm referring to is the window after opening, the window that gives you the choices: Table, Queries, Forms, etc.
  6. C

    Maximize opening screen

    When I open an Access file, the box that appears first is not maximized. I have to click the maximize button on the top right of the screen. Is there any option available that will maximize this screen always when opening a file?
  7. C

    adding values in a table

    In a table there are two columns with values. I want to insert another column so that when I enter values in the original two columns the sum will automatically be entered in the new column.
  8. C

    Uppercase

    The table has a field which lists the titles of books. Only the first letter of the first word is uppercase. How can I change each word's first letter to uppercase?
  9. C

    #error

    I created a database at home, and everything works properly. When I took it the office, the REPORTS, which are mailing labels did not work. When I click on any of the mailing label reports, a dialogue box appears stating ‘Enter Parametric Value’. Under that is the word TRIM above the space to...
  10. C

    Entering month only in a report, NEW

    In a table I used a mask to enter a date, as for example, 1/23/08. In the report, howerver, I'd like only the name of the month with 3 letters only: Jan, Feb, etc. In addition I want the months to be in month order, not alphabetized. Above is the original message I sent. The responses I...
  11. C

    Entering month only in a report, NEW

    In a table I used a mask to enter a date, as for example, 1/23/08. In the report, howerver, I'd like only the name of the month with 3 letters only: Jan, Feb, etc. In addition I want the months to be in month order, not alphabetized. Above is the original message I sent. The responses I...
  12. C

    Entering month only in a report

    Entering Month name in a report NEW In a table I used a mask to enter a date, as for example, 1/23/08. In the report, howerver, I'd like only the name of the month with 3 letters only: Jan, Feb, etc. In addition I want the months to be in month order, not alphabetized. Above is the original...
  13. C

    Entering month only in a report

    In a table I used a mask to enter a date, as for example, 1/23/08. In the report, howerver, I'd like only the name of the month with 3 letters only: Jan, Feb, etc. In addition I want the months to be in month order, not alphabetized.
  14. C

    Entering month only in a report

    In a table I used a mask to enter a date, as for example, 1/23/08. In the report, howerver, I'd like only the name of the month with 3 letters only: Jan, Feb, etc. In addition I want the months to be in month order, not alphabetized.
  15. C

    Combining two cells

    In a query design view, I have two fields, LastName and FirstName. In the Field of a blank column I enter [LastName]&[FirstName]. In the query the last and first names are now connected , like SmithJohn. How do I put a space and or a comma to separate them?
Back
Top Bottom