Many to Many/lnktable/query
Tue, 9 Dec 2008 15:03:00 -0800
I have a table of patents with the primary key of PatentMasterID. I have a
table with Inventors with the primary key as PatentInventorID. I have
created a link table using both of these fields as primary keys.
The PatentMaster table is joined to the link table by the field Patent
MasterID to include on ...
|
Normalizing semicolon delimited rows
Tue, 9 Dec 2008 13:47:08 -0800
Is it possible to transform data in a semicolon delimited field into
individual rows by using a query in Access? I can write VBA to do this but
would prefer to use a query if possible.
Each entry in the field is 6 characters in length separated by a semicolon.
Patrick
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
...
|
Size of QueryDef.SQL property
Tue, 9 Dec 2008 12:54:13 -0800
Does anyone know the maximum string size that can be accepted by the
DAO.QueryDef.SQL property?
Patrick
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Patrick Jackman
Vancouver, BC
604-874-5774
...
|
Historical Data for comparison
Tue, 9 Dec 2008 12:34:01 -0800
is there a way to run either a query or report that returns a series of dates
each month but rather than simply reporting what is currently in the fiels
also report the previous 12 months of information for the same fields. ex
Start Construction Current for each month Jamuary through December. ...
|
Any way to create "reversed" cross tab query?
Tue, 9 Dec 2008 11:54:07 -0800
Please see example below. Is there is a quick way to create botom table from
the top one? The only thing i know is to write 3 select and than 3 append
queries. But for my task i'll have to create about 120.
Week GM_2010_03 GM_2010_05 GM_2010_06
1/1/2010 562.02 702.41 2641.32
1/8/2010 562.02 702.41 264 ...
|
Selecting top records based on multiple fields
Tue, 9 Dec 2008 11:51:01 -0800
I have a query shown below:
SELECT data.[Account-Sub account], data.[Account Unit], data.[Account Unit
Description], data.Account, data.[2007 Actual], data.[2008 Actual],
data.[2009 Actual], data.[2009 Budget], data.Description, data.[Description
Order], data.[LEVEL 1], data.[L1 Order], data.[LEVEL 2], data ...
|
How do I set the ColumnHeadings property?
Tue, 9 Dec 2008 10:48:17 -0800
I have a report based on a Crosstab query. So far, so good. Then I added a
subreport also based on a Crosstab query to the footer. Now when I open the
report I get an error, "...you can't use a non-fixed column crosstab query as
the record source for a subreport...set the query's ColumnHeadings property
f ...
|
|
|
Decimal places and Date Range in Expression Builder
Tue, 9 Dec 2008 09:34:01 -0800
I am trying to output a range of dates and times in a query that will show
the max and min of the dates like this: 1-99
I have used this expression in the expression builder which works:
Time to Arrival Range: IIf([MinOfTime to Arrival (hrs)]=[MaxOfTime to
Arrival (hrs)],Null,[MinOfTime to Arrival (hrs)] & ...
|
Unable to sum new + old columns (of like data)
Tue, 9 Dec 2008 09:13:01 -0800
Hi and thanks for helping,
I created 2 new columns today (currency format) in my Access DB with new
data (i.e. not available before and so historical data isn't updated as well)
but after including them in a build formula to sum, the historical data
doesn't compute. Here's what I mean:
field1 - on runnin ...
|
equivilant to trunc function in access
Tue, 9 Dec 2008 08:02:26 -0800
Hi there,
I used the round function but it rounded my numbers - I really just want to
cut of the decimals at the 2 decimal. I read about the trunc function on the
internet however it only works in excel and I need to do this in a query.
Any help would be great as my numbers are off by a little.
Thanks
...
|
