hi,
I have the following, in which the syntax is wrong:
SELECT Tbl_MasterPop.[Loan Acct #], Tbl_MasterPop.PopEnterDt
FROM Tbl_MasterPop

I am currently trying to compare two tables to one another that have the
same field "Sku Number".  The problem I have is that I want to create a new
table from a query that matches up the skus that exist in both tables, but
also include those that do not have a match.  As of ...

I have a query and I wish to restrict the returned values to only those
where, for a particular field, the value is the highest.
For example, a property can have had a number of rent agreements but, in the
following example, I don't want ALL the records, just the one where VarNo ...

I posted this a couple of days ago and we were unable to resolve the
issue. Anyone else want to give it a try?
My query calculates the percent of hours worked on a project compared
to total hours worked.  Here are the relevant fields:

Hi, I don't know if this is possible but here goes.....
Database been created to log incoming mail to be tracked, some users would
like to use excel to input the data and have it merge into the main query.
Possible problem: the database table/query creates a LetterID using

I posted this a couple of days ago and we were unable to resolve the
issue. Anyone else want to give it a try?
My query calculates the percent of hours worked on a project compared
to total hours worked.  Here are the relevant fields:

I can't make this work.
I have an unbound form with a combo box.  I am trying to create a subform
based on the combo box.  Is it possible.
Thanks in advance

I need to write an update query that updates a Date field with data the user
enters on the fly.  Is this possible?  For example, I have a field called
Contract Cycle that needs to be entered on the fly as a criteria for the
update query.  I know how to prompt the user to enter ...

Greetings!  Have a UDF being called in an append query to fill a calculated
field.  It reads two dates from the source file, then decides what to do.  I
realized that the UDF only fires when both dates are present, but I'd like
it to run whether they are present or not.  What are ...

I have about 20 or so queries that I need to run at diffrerent times. There
is only one element that changes in each query and it is the same one. I
created a form to select my query. My changing varible is in a ComboBox. Here
is the code behind this query. What is wrong with my ...

Greetings!  Have a simple append query, to which a filter was added to
exclude input records via Not Like where a field starts with "7B7".  That
field in some records is empty.  Applying the Not Like criterion causes
Access not only to block records satisfying the criterion but also ...

i have 2 numeric fields and i want to compare them
if the values of the filelds are "equal" i want to create a new field with
the values "not ok" , else "ok"
i wat to do this in sQL plssssssssssssssssssssss

Greetings!  Is there some Access query shortcut available when using a
function that requires an argument (such as Left( )) to tell it to use the
value of the field with which it is associated, e.g. Left (*,2) to mean the
left two characters of that field's value rather than having ...

This is a stupid question but I can not see clearly in my query, please help.
I selected a query, click on design and view in SQL, the font very tiny
...so how can I change it ? Thank you.
MN

I have an inherited Db with a query that calcs a date via dateadd: -
 DateAdd("yyyy",[Term],(DateAdd("d",[Adjustment],[EmployStartDate])))
This works fine but I can not seem to put a criteria against this calc
field and keep getting data type mismatch error.