I need help. Can someone help me with this topic. I need to trunacate a
decimal with the integer function.

I have 2 tables tbl_Date and tbl_ASX_Data.
Based on tbl_Date.ImportDate I want to find the dates for which a record
does not exist in tbl_ASX_Data where tbl_ASX_Data.ASXCode = "XAO". The field
ImportDate is the PK / FK respectively.

I am getting this message and of course cannot add any new info / records to
the DB.  Why would this be?  
Note: the main form is based off of a query.  I also just added a new table.  

I'm building a log file of action queries that execute, and looking to obtain
the counts of records updated, and records appended from the queries that get
executed.
Anyone know where/how I can get that info programmatically?

I get this message when I run this query, but I run the same query with dates
between Jan and Feb and it is fine
SELECT dbo_Inspection.Inspection_Id AS [Inspection ID],
dbo_Inspection.PIH_Project AS [PIC Development Number],

Hi. I am at the point where I need to start creating Queries and Reports. I
am hoping someone can provide some links to information about entering
criteria. I'm looking for examples and different options and the proper way
to enter them.

I'm not sure how to begin on this.
I want to check two tables and based on certain criteria generate a
list, PMDUE. I've gotten this far. Then I need to relate the PMDUE list
to a table, WO, in a many to one relation using the WO primary key

I am having a problem with a query that is using a form to get its
criteria.  there are several comboboxes on the form and i want to be
able to leave them blank to search all for that category.
i am using this sort of format

I used lookupwizard for a field to list some items.  When I created it, I
selected that I would type in what was needed as these items are not in a
table.  I Typed in the items and saved etc.
Placed this field on my form, all ok so far.

Greetings all,
I have a table (tblProduction) that stores date of production, actual
production, and production goal for that week.
ProductionDate    | DailyProduction    | WeeklyGoal

I have a table called Tbl Melissa Timesheet and a query called Melissa Hours.
I am trying to make a timesheet so that the field called Billable rate in the
query will populate with "70" if the field called Billable vs Non-Billable
returns a result of "yes" if the result is no ...

I am trying to display a list of available instructors between two given
dates. I am using the following in my query:
SELECT [Employee Details].[Employee #]
FROM [Employee Details] INNER JOIN EmployeeAvailability ON [Employee

I have a couple of fields QtyYear & QtyAmount.
QtyYear contains the year (2002, 2003 etc) for the given amount (QtyAmount).
However, if there was no amount for that year, then there is no QtyYear & no
QtyAmount.

I am using a querry to find a percent. Is there a way to format it to 85.6%
instead of .85666666. Thanks in advance...

i need a report to show info based on two seperate query fields. i currently
have the criteria for one of these fields set as "[Forms]![Frm: Report
Selector]![Customer]" however i need the [Customer] info on [Frm: Report
Selector] to search two seperate fields to see if the customer ...