I can calculate a total value of 3 incomes and show it correctly as "total income" on the form. "total income" which is a field in file is not updated when I...

Hi. I am a new access user. I actually posted my query already but I couldn't find it anymore. Anyway, I hope someone can help me. I have only a month to work...

For example; I have a list box that has Mr., Mrs., Ms., and Miss in it. When entering data I want to be able to hit "m" and have it go to Mr. (Which it does)....

Hello, I have created (almost finished) my database. I have a table called Users which holds Full name, email address, user id, phone, manager and analyst....

How is to apply a different Id for each field in the database for many tables ?

I have merged data from an Excel spreadsheet into Access, but there is only one field for "NAME" and it is in this format: LAST,FIRST. How can I get Access to...

A small annoyance this morning that my users are reporting, when they're entering info re the lettering in an Act, in this case when we're entering a "c", the...

Have a database for voting. There are districts, then towns, then parties (dem / repub). I need to filter down to parties by possibly one district - possibly a...

I'm using three different tables from MS Query but I can't seem to merge them. When I first tried to import them into access it wouldn't allow me to add them...

Hi I'm a total newbie to this seemingly complicated Access database malarky. I am trying to build a database that will also eventually appear on my website...

Require template for relational database for car sales Keep records of customers, quries, sales, vehicles, etc

I used a button to create a navigational button between two forms. When I open up the target form manually, I get the datasheet view which most resembles the...

help for WCB injurried worker(legal advise)

I have been using the lookup wizard, and I realize that some of the options that go in it do not fit, is there a way to increase the size where I write my...

Hi, I'm creating a database to store weather data. The data is organized in a table by Date, Station Name, MaxT, MinT and Rain. The Reports for the data are...

I have a table of contacts with a field for cards. I want to use a query to produce a report that will print labels for all the contacts that have "YES" in...

I tried to build an SQL statement from 2 Queries. I keep getting a Syntax Error. Any help appreciated!! Thanks DS SELECT MenuCats.MenuCatID,...

To All, Can I please trouble the group for some assistance? I have a number field named "stoplength" in a table that I convert to time with an append query...