Search results

Thus, why I suggested it. When adding a new instance of an error, check to see if the ID exists in the error table then add the instance to the instance table (or occurance table...)

By The way I did some toying around and it seems the reason sub reports were floating behind others was due to page break issues (atleast, for now). I guess I gave too much credit to how intelligent this software was.

I will work on that. One more thing to add. When I drag in a report (not a subreport although I want to use it that way) the field names disappear. The header is still there but it is blank. It does not appear to be a font issue either.

Im no architect but this comes to mind: Error table Fields: Err #, Name, description Instance table (err# = FK into error) Fields: Err #, user, date time, etc... Populate a dropdown box with Names from Error table.. select from instance table where err#=err# from error table (the one the user...

Ok Im in formatting hell here. 1. When I drag in sub reports (or reports to be used as subreports) The first one usually drags in fine. The second one will sometimes float behind the second one. And the third one will usually either drag in correctly, or float behind one of the other two. 2...

Apparently you can union... Take this example I found.... SELECT pub_id, pub_name, city INTO results FROM publishers UNION SELECT stor_id, stor_name, city FROM stores UNION SELECT stor_id, stor_name, city FROM storeseast

http://www.sqlteam.com/article/using-select-to-insert-records You might also be able to use a union with two selects select * into newtable from tbl1 union select * into newtable from tbl2 Not exactly sure if that would work, you may have to wrap that in another select.... the first solution...

Id rethink your DB structure. If you have identical properties (Assuming fields) in 2 tables and you want to copy from one into the other you are duplicating lots of data. If you want to access data from another table, either create a lookup table or add a column in one of your tables with a...

Weird. Youre not really running a subquery, its only another column with an expression. But come to think of it - what youre seeking doesnt make sense. That value will be returned in every row which would be a lot of duplicated data. If you just want that value, for whatever reason, put it...

Why would you want the avg of the difference? Or you do mean the avg of all the values in the diff column? If so, sum(diff)/count(diff) as avg should do the trick.

My intent is to reuse top 10 bottom 10 without having to store it 20 times with a changed WHERE clause. These queries (which make use of other queries, ie nested) will be run on other tables as well, so the more general I keep them the more beneficial (and reusable) they are.

Ok I think Im still being misunderstood. Ill demonstrate here: Report1 Subreport: X Subreport: Y Subreport: Query: Top 10, Parameter: "EASTERN" Subreport: Bottom 10 'EASTERN' Report2 Subreport: Top 10 'WESTERN' Subreport: Bottom 10 'WESTERN' Report3 Subreport: Top 10 'CENTRAL' Subreport...

The problem with this is that Ill be running a top 10 and bottom 10 for each username's data. Looks like theres not going to be an elegant way to do this.... Any ideas?

You must spread some Reputation around before giving it to neileg again. Thats what I ended up doing. I thought, perhaps, there was a single query that could round up that info, and there was a function/statement I was uninformed about. Thanks again.

the tables are not linked, but they have the same fields and represent a different occurrence (dont ask me I didnt create them). I want to count the amount of times "UserID" is in one table and count the times it appears in the other table. I want to be able to count multiple users names (thus...

http://www.w3schools.com/sql/sql_update.asp http://www.w3schools.com/sql/func_sum.asp

bump ^^ :eek:

Yuck, whyd I agree to work with access? :D Cheers

about 10 reports with 2 subreports on them. The two subreports make use of the initial query I spoke of. Each report has a unique header as well. The subreport queries are nested and fairly complicated thus without refactoring them they only differ by that one input. (We used to have 20-40...

I want to count based on 1 (same) field from each of two tables, based on if ID is in "X". select a.groupid, count(a.id), count(b.id) from ta a, tb b where value in ('a','b','c') group by a.groupid Thats sort of the psuedocode but Im not getting the right results. Any help would be appreciated.