The following SQL Statement will only show 3 items no matter how many  items
meet the criteria and I cannot understand why:
SELECT [Meals Defined].MealDate, [Meals Defined].Meal, [Meals
Defined].Quantity, FoodItems.ServSize, FoodItems.ServUnits,

Here is my challange
Simple one table database.  Two types of records can exist but only differ
by "Work Type", if so, only one type is needed to be reported on if the
following conditions match; "Region", "Dest", "HTLCode", "Contract Start

I have a query that shows data for all current employees, but filters out
those who are no longer employed here by looking to see if the Termination
date field is null or not.  What I actually need it to do is show all current
employees plus those who terminated any time during ...

I have an Access app that does a lot of number cruching and exports the data
in Excel. However, I notice that when my long running queries are running, I
cannot jump to another application on my PC and jump back to Access (using
the task bar at the bottom of the screen). What I ...

? have a table of names and addresses including a 7 digit postcode  E.g BA16
7TY in a list of other BA* together with TA*, GL* etc. When I create a query
with Like "BA*" in the criteria it counts individual postcodes and as few
people have exactly the same postcode I get a list ...

Using Access 2007.
I have a database in mdb format that records the information of customer
sales on  a web site. In the OrderDate field I am using Now() to record the
date and time the order is placed.

Does anyone know how to change the Font color using an IIf statement? I wan  
Past Due to be in red.
=IIf([Text61]>0,"Past Due")

Is it possible to create a table via code (create table ........) in an
access 2007 database from a Vb.net 2008 application?
Any tips/samples/links on how to do this ?

I have two tables here, one contain the basc info of several items, said 10
items, and using an ID to identify them; the second table, store the records
related to those items at the first table, using a different id to identify
these records and linked the first table with the ...

I have a situation where I store data row by row, such as
ProjectID    CategoryID    MonthID        ValueID
   1                     1                  1                  203
   1                     2                  1                  32

I have two tables with this structure:
table1:
1) ID (Counter + primary
2) lfd_nr (integer)

I created an Access 2007 append query.  I try to run it but it tells me
disable mode won't allow the query to run.  What the heck is disabled mode? I
searched office online help and could not find a reference or topic on it.

I have linked an XLS file to a dataabse and I  need to convert the following
to short time
Appt Time: 815 (Number), Return Time: 1455 (Custom hmm).
I have no control how the xls file is formatted or what field are made

How can I pad a field with spaces if it’s a character, numeric or date?
For example Customer Name (14)     Telephone Number (20)    FeeAmt (15)
“Jones         “         “          8772774000“        “           15.41”
What should I do in my query to tell it to pad each field with spaces if the

The combobox in table2 is reading from table1 which contains two fields, an
autonumber ID field and a textbox field. Table2 also includes other fields
which I want included in the query.
When I perform a union query on a combobox field it is always returning the