Thankyou all for your replies.
I have decided to go with gmmastros's suggestion. This is because the other two solutions do not always produce the desired effect:
set nocount on
declare @tbl table(
tbl_id int IDENTITY NOT NULL PRIMARY KEY,
PersonCode varchar(6) NOT NULL,
DataValue int)...
This may seem a very simple question, but I am trying to find a way to list say the top 5 values (or less if fewer exist) for each person in a table witout having to resort to cursors.
Here is a simplified version of the problem:
CREATE TABLE tbl1
(
id int IDENTITY NOT NULL PRIMARY KEY...
Code for DotNetDoc:
Private Sub Timer1_Tick(...)
sec += 1
Call SetDateAndTimeDisplay() 'this shows the current date
'and time on the form
If sec >= REFRESH_INTERVAL Then
sec = 0
Call ClearControls() 'clears the txt and cbo boxes
Call...
I have written a small VB.NET application that accesses an mdb database and then dynamically creates controls based upon it's values. A timer runs and refreshes the screen every so often by clearing the current controls and recreating them.
When I run it, unless I close it soon afterwards, it...
There are several ways to do this but the safest is to import the spreadsheet into Access as a table (make sure the spreadsheet is in a suitable table-like format first), by doing New|Import Table.
Then make sure the datatypes of the imported table are the same as your existing table.
Then...
I have devised a workaround that I regularly use:
Firstly, forget about Crosstabs.
Say you want to return Columns A, B and C where B has no entries but you want the report to display B=0.
In your base query 'force' the desired columns to return a value like so:
B:IIf([field] In...
Here's a slightly simpler (if more limiting) possibility:
In your query use this in place of forename
fnms:iif(max(fnm)=min(fnm),max(fnm), max(fnm) & " and " & min(fnm))
The only trouble with this is you can only have a maximum of two names per household. Enough in most cases I...
Does the number of copies match the number of rows returned by the query?
If so, then you probably need to move your 'aggregate' functions into a group footer, and hide the detail by setting it's height to 0.
Could you not just have both sets of tables permanently linked, and prefix the Access ones with, say mdb_ and the SQL Server ones with say sql_?
That way the Queries could be built on-the-fly to connect to the selected tables.
This also simplifies the syncronising of the two sets of tables.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.