I need help,  I have a query where I rounded some numbers with:
Margin:Round([Sales info.Salespgactual]+0.0001,2) this rounds my number to
whole numbers.  So if I have 40.27 % it rounded it to 40.00% so on and so
forth.  My question is this I need to do a dlookup that looks at ...

I want to use column created in the select statement in the where statement
like this:
SELECT tbl_RAP_Award.PO_Number, tbl_RAP_Award.Inspection_Id,
tbl_RAP_Award.Property_ID, tbl_RAP_Award.PIH_Project_Number,

I have generated a query from combination of a few tables. This query has
data in numeric format, often with decimals. The Datasheet view shows the
numeric data with all decimals and fractions. But the PivotTable view ignores
the fraction portion. It does not display digits to ...

I am getting "InValid Argument" when trying to name this query
SELECT BUQ.*,Format([TimeOfMessage],"@@:@@:@@")
FROM BUQ;
What am I doing wrong ?

Often the SQL posted here and elsewhere is difficult to read. Therefore I
created the Word macro below. It's not perfect, but it helps to format and
read the sql. I paste the sql into a blank Word document then click on a
button that runs the macro below. Please feel free to use ...

I have a database that is designed as FE/BE. There are two users and each
one has thier BE in their own folder which resides on the same server.How do
i go about merging the two BE so the data from both users can be in one BE?
The BE from both users have the same fields and only ...

I am joining fields on two tables and find that when I run the query, the
results reflect a duplication of some of the entireson the tables.
Anyone else suffer this dilemma?

Ok.  I understand that this problem is due to Office sp2, now how can I get
around it, besides the lame methods listed on the Knowledge Base.  I am sure
that MS's lawyers told them to state that, but.....
I am about to uninstall the Office sp2, but I am hoping that someone has a

I am having a problem opening a form and specifying date as link
criteria. My table has these fields:
childId
crDate

I have a group of records that I need to create a sub query by I don't know
how to go by doing it.
Say I have the following group records.  I need to pull the record with the
latest date.  However, the max function does not work.  I still receive the

I'm sure this is simple, but I can't bang my head on the desk anymore today! :0
I'm trying to query and show only dates within a 14 day range.  The query
accesses the period end date off of a form (as you can see), since it's
attached to a macro that will print all my reports out ...

I'm missing something really basic, I just can't figure out what. I need to
calculate the difference in time between 2 fields. I've figured out the
formula:
DateDiff("s",[SiteData]![TranscriptionDate],[BirdData]![Autotime])

How do I write a function in a query that assigns values 1,2, so on to an
empty field?
Thanks in advance

Equipment Utilization
Ok, I need to figure out equipment utilization, the table I have is the
shipping table with the ship date and receive date.
The problem I have is if it shipped out on 7-1-05 and returned 7-1-06 how do

My database has 3 tables that I am trying to show in a query but
nothing comes out of the query if one of the tables has no information.
Let me explain further.......
Table 1: Request (this table shows details of a request that has been