« When I go into contacts to send a group email and select all of the contacts it only sends it to the first?
How do I make a Database using MS Access to organize movies with my clients who rent them? »

How do you add a field in a select query in access 2003?

I’m doing this UIL Computer Applications test and it want me to add a field to the select query that says AMOUNT = Rate from the ToolsRented table and multiply it by DaysRented from the ToolsRented table. Me and my UIL coach tried to find something in the office help but came out empty handed. So if anyone has a the correct form please tell me. Me and my coach think there is a typo in the test itself. Thank you for ur help.

In QBE you would add a ‘calculated expression:’

AMOUNT: [Rate]*[DaysRented] to the next available column in the Select row

Writing it in SQL:

SELECT [Rate]*[DaysRented] AS AMOUNT FROM ToolsRented

No Typo there

This entry was posted on Sunday, January 17th, 2010 at 9:18 pm and is filed under query. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “How do you add a field in a select query in access 2003?”

  1. In QBE you would add a ‘calculated expression:’

    AMOUNT: [Rate]*[DaysRented] to the next available column in the Select row

    Writing it in SQL:

    SELECT [Rate]*[DaysRented] AS AMOUNT FROM ToolsRented

    No Typo there
    References :

  2. In your query designer create a temporary field by going to a blank field column and typing in a name. Give it any name and a colon so as an example

    TotalAmount:Rate * DaysRented

    For FREE Access ebook and videos click here
    http://access-databases.com/ebook
    References :

Leave a Reply