I am having trouble figuring out what to do with this here…
We have a web-based form where people enter times for employees that take
care of consumers. Most employees have more then one consumer so they have to
fill out more then one time sheet to be entered into the web-based ...

I running  an update query and  getting an overflow error.
 I have run this  before and no problems just  this  time. Any ideas  on
how i can correct it. Thanks
Function TimeConv(dteStart, dteEnd As Date) As Double

To summarize, I have an Employee Query (all queries pulled directly from
tables, where applicable), a Skills Query, and an Employee-Skills Query, that
constitutes all of the skills that each employee has (ie. Employee 1 - Skill
3, Employee 1 - Skill 7, Employee 2 - Skill 1, ...

I am tring to add a number of years to a dob. im doing this by adding my
date+years*365.26 I get a string of numbers. I then convert the number in
the next column to actual date again. I'm getting the correct date. Now I
want my criteria on that column to allow me to return only ...

I am trying to create a check in my form that looks for any duplicate client
names.  I am using the below code to return the ClientID value if a record
is found.
DLookup("[ClientID]", "[Clients]", "[ClientLastName] =

I want to interpolate missing data. I want to run a query so that it will
return all the real and interpolated values. My rable looks like this
Week  Value
1            5

In my database are all text fields.  If it has duplicate carrier number I
want one, not as many as the table has “ It could have two, three, up to
five” same carrier numbers .  Can some one help me with the query?

Any ideas how to display out from query below
 qry02StrategicGoals02 SG AboveBelow CountOfAboveBelow
     1 Above 254
     1 Below 30

I need help figuring out the critera operator expression when you're trying
to exclude a piece of information.
For example, here is what my Tests field looks like:
Customer ID    Tests

I created an append query to update a Comments field on my database.  It puts
any new comment for a given project that a user types in this field on a form
at the end of my Comments query.  I want to create a report that will only
show the current Comments.  How do I do this?

I have 2 tables, table 1 contains product info, inc a colum called Short
description. In table 2 I have a list of recognised brands names. What I want
to do is write a query that will return two colums, the Short Description,
and the brand name. The brand name should only appear ...

Hi Friends,
I need some help in devloping a simple query. I developed a database
application which will take a user "FIRST NAME" or " Last name" or BOTH to
retive his detials. The problema here are:

I built a query with a parameter. Then I built a Form from the query with
the parameter, I put a button on the form to go to a word document using
the Mail merge wizard. When I open the word document my mail merge buttons
in Word are ghosted out. This only happens when I have the ...

Hello all,
I'm trying to build a report which would look like a statement.  I have all
the purchased transaction's in one table, and all the payment transactions in
another table.  In my report, i want to list both the purchased items and

I want to format the output of a query that selects a date column so that it
outputs for example as 15 March 2005.
That is, in a query where I SELECT customer_name and date_ordered:
It currently outputs the data as follows