|
|
 |
| found 44 articles for 0.302 sec |
  |
Group: linux.debian.bugs.rc · Group Profile · Search for 3db0 in linux.debian.bugs.rc
Author: Gabor FUNK
Date: Dec 24, 2008 08:40
The query is a SELECT and therefore can not be changing the data. If somethings actually changing the data in the table, it's not a Select query. Is either the CBF.[ASSGN ORG] or [OrgCode to Org].OrgCode fields the primary key field for their table? At least one should be. If you can't make at least one of them the PK, then there's a chance that you have a Many to Many relationship which
|
| Show full article (2.45Kb) |
|
Group: microsoft.public.access.tablesdbdesign · Group Profile · Search for 3db0 in microsoft.public.access.tablesdbdesign
Author: rickw
Date: Sep 4, 2008 14:00
Here's the SQL of the query for the form I use to view data: SELECT [OrgCode to Org].Org, CBF.[REG NO], CBF.[VE TP MKE], CBF.[WK ORD NO], DateValue([1stofYr]+[RecDay]-1) AS [Rec Date], CBF.[TI REC], CBF.[OLD ETIC DATE], CBF.[OLD ETIC TIME], CBF.[NEW ETIC DATE], CBF.[NEW ETIC TIME], CBF.[SHOP STUS], CBF.REMARKS, Right([DT REC],3) AS RecDay, DateValue("1 January 2008") AS 1stofYr FROM CBF
|
| Show full article (5.70Kb) · Show article thread |
|
 |
|
1 ·
2 ·
3 ·
4 ·
5 ·
next |
|
|