I never thought that there was a limitation to the fields or calculations in
a query. Now I get this message and I know I need to change what I
something.
FieldName: Wed

I am using the two lines of code below  Each in separate columns of a query
(or two text Boxes on a form) to calculate the elapsed time between two dates
formatted as General Dates.  The first line of code (in column A, "txtTime1")
calculates to the total minutes between the two ...

In my conference registration database, there is a group registration option.
An agency can register 5 or more people.  I want to print name badges to
send to the agency and permit them to identify the person for each badge.  
Having the badge from the agency will be the ticket ...

Having problems working with fiscal year data since our fiscal year starts
October 1st, not January 1st.  Therefore FY05 (Fiscal Year 2005) actually
started during calendar year 2004 (October 1, 2004).  Here's my problem:
I need to create a query to return a list of all personnel ...

I'm working on a Personal Information Database.
I want my system to do the following whenever I
enter a person's ID:
If the ID is already entered before, I want all

A column in a query:
 Data: Eval(FieldName())
In a general Module:
 Public Sub FieldName() As String

Here is my expression:
TotalHours: DSum("Hours","tblHoursCalculated ","EmployeeId<=" &
[MyEmployeeID] & "dayofweek<=" & [Mydayofweek])
MyEmployee and MyDayofWeek are aliases

Access 2K.  I need the field name in a Query to be the result of selecting
a name from a Combo Box on a Form.  The form name is Main Form and the
Combo Box name is ToBrand  [Forms]![Main Form]![ToBrand].  Is this possible
to set up in a Query grid?  

Example apps in the books are only .mdb based or some of them are Sql Server
project ?
Thank you.

I've created an expressions dividing two fields in my query.  When I leave
the total row as defaulted, 'group by', I'm prompted for parameters (which
are already in my query).  When I change the total row to 'expression', the
query runs.  Now I want to sort assending by this ...

I am creating a booking database for hotel bookings for meetings and I need
to create an output report.  The records that are entered for the bookings
are of the format;
Person1, HotelName, Date1

Hi, I know that my biggest problem is in understanding what I am doing but Im
hoping I can get some help here. Ive added two tables to a query window. The
tables are related one to many. When I run the query it allows me to enter
info into the first table ( the one side), but it ...

I guess this is a simple question for you guys:
I've got a table that contains first and last names in one field separate
with a comma (e.g. Jerry,McIntosh). I would like to have this table
displayed as Jerry McIntosh

I have form with combobox, that ask user to chose client name.
What can i do if user did'nt chose client name to display all clients.
Because , now if user did'nt chose  client name the query return nothing.
query look like this:

My question deals with duplicate queries. I have duplicates that resulted
from a query and I want to know the number of duplicates or if I can number
the duplicates with the same number.
For example: