I have a back-end db where I store lots of tables. I join the PO table to the
PO Line table by the PO ID. Works fine, shows as a one-to-many relationship.
Why is the referential integrity box greyed out? I need to enforce
referential integrity.

Hi to all,
I need some help into creating an interface between a already made program
and my payroll program.  The other program database is made in MS Access and
I can have access to it.  My problem is that their transaction list is in

Let me paraphrase a query I want to do.
First, I have a table called 'Components'
This table has these fields:
RecNo (Primary key)

Hi, I have this query that runs for minutes. I have SQL Server experience but
somehow in Access I get confused. Does anyone know how to improve the
performance? Here is the query:
"SELECT Codes.Code as CodeId, '',StringHeader.Reviewed as EnglishString, ''

Hey all,
 I have the following query on my ASP page that is giving me a
"syntax error in JOIN opperation" message.  I found this query from
someone who posted it in PHP format, so I had to convert it over to

Using Access 2000, I have two tables, one is Debts, the other Sales.  Sales
table has 3 fields: AccNo, Week and Turnover, Debts table also has 3 fields:
AccNo, Week and Outstanding debt.
I want a query to show all accounts in the Debts table for a given week

Hi,  Using Access 2000.  I have a statement in a Union Query that is
([DEBT]![BAL]/[SALE]![TURNOVER])*7 AS [Calc DOC] which works albeit I want
to round the result, I have added CINT but running the query now fails as
says the query maybe to complex, try setting variables

I've got a table that lists parts and prices.  Prices are down by Years.
Currently Years are 2007, 2008 & 2009.
What I need to do is determine IF year = 2008 & Price is Null, THEN i need to
take the Price that is listed in year = 2007 and escalate that price by a set

how to get the number of years between a date and a "start" date already in
table

I am trying to run the following sql in MSAccess 2003, however, I get an
error 'Runtime error 3075' Syntax error (comma) in query expression '(
Asset_Info.AssetID , 'SYSADDEQ' , 'SYSTEM' , 'SYSTEM' , #03/03/2008 12:4200#)
'

Hello everybody. I have this query which works fine. It takes its parameters
(date from - date to - reasons) from a form. This works also fine. I
sometimes need to be able to see all the reasons "causali" between specific
dates. I would like to know if and how that is possible by ...

Can someone assist me with a query?  I need field  Expr1: [Results] to
divide [Rate Total] by [Contracted Rate].  Rate Total and Contracted rates
are in 2 seperate tables I brought into the query but can't seem to get the
right syntax for the division.

I have a form to run reports.  All reports are run based on the month and
year but the table data contains actual dates.  On the form the client enters
03/2007 in a text box to select reports containing data for March 2007.  The
text box has a format mm/yyyy.  The table data has ...

I have a calculated field in a query that returns the difference between two
times with a time format of h:nn; for example, one hour and thirty minutes is
displayed as 1:30.  I need the value of 1:30 displayed in minutes, so I need
to see the value as 90 minutes.  If I use the ...

Can someone please explain this query?  Thank you.
SELECT A.[DR CNTY], A.[DR ID], A.[DR NAME], A.[DR PH], A.[DR FX], B.[DR PH],
B.[DR FX]
FROM [Main TRKG TBL] AS A INNER JOIN [Main TRKG TBL1] AS B ON A.ID = B.ID