Recent content by PeterDuthie

Hello all. I'm stumped with this one and would be very grateful for some help. I have a Form with contains a tab control with a subform on each of the three tab pages. (It so happens that there is a one to many relationship between page 1 and 2 and page 1 and 3. The database is growing fast and...

Hello raskew. I don't know how clear this will be to you but I'll be happy to try and explain. I'll try and keep this short. These are the columns I've been talking about in table [Daily Record Sheet] (a sheet filled out by work gangs and recorded in the database every day - or so). This table...

Thanks for your interest Pat. A stacked query is a query that is stacked: a query which uses the result of another query(s). There is a solution to my particular problem using UNION. What I did was split the recordset into 5 parts, each having one just one column which was identified by the...

Hello John and anyone else who reads this. John, you were right about the UNION. It took a while for the penny to drop but what I've done is split up the rows to return 5 recordsets with each discrete Column(X) along with the rest of the data ... then UNION(ed) them. So now I can do my grouping...

Thanks very much raskew - and you have understood the jist of the problem. But the code you suggest would need to be called from a procedure or function where a sql string was being built up. I was hoping to do something like MyColumn & str(NumberFromStackedQuery)right from the query. I'm newish...

Thanks a lot for your help John. I hadn't tried the Union approach because column1 ... column5 are in the same table. I have tried now tried a union but it doesn't work - not the way I've coded it anyway. Cheers, Peter

Hello All. I have a stacked query which returns a series of rows of numbers (1-5) which refers to one of 5 columns in a table. How can I (or maybe I can't do this) code the column names with the numbers returned from the stacked query. Here's an example of what I want to do. I want to end up...

Hello All. I have a stacked query which returns a series of rows of numbers (1-5) which refers to one of 5 columns in a table. How can I (or maybe I can't do this) code the column names with the numbers returned from the stacked query. Here's an example of what I want to do. I want to end up...

Hello again Psychpt. You're obviously way ahead of me on SQL. Do you have a book recommendation? I have the excellent Access 2000 Developer's Handbook set but a more detailed discussion (with worked examples?) would be really useful to me. Cheers, Peter

Very good Psychpt - this works perfectly. I see that DCount helps here too. Cheers, Peter

Hello Everyone. I need to get back two values from a query - 1. the total number of rows in a table and 2. the number of "incidents" which have been "signed off" (i.e.) dealt with successfully within 48 hrs. The two values are intended for a pie chart. Here's what I've got...

Hello Everyone. I need to get back two values from a query - 1. the total number of rows in a table and 2. the number of "incidents" which have been "signed off" (i.e.) dealt with successfully within 48 hrs. The two values are intended for a pie chart. Here's what I've got...

Thank very much CaptainD and Paul. I've copied your code to a text file and I'll play around with it when I have bit of time. The CDate() will do for now, but I keep thinking I'm missing simple ways of doing things - or rather, letting VBA do the things for me:) Cheers, Peter

Thanks Boxhead - I've done a search but can't find (or missed) the thread you mention. If you come across it again I'd be interested to see what solution was put forward. Cheers, Peter

Hello All. I've found "an" answer: CDate will convert the number to a date. This works OK on the report side but I'm still interested in a solution to the problem at the SQL side - if there is a solution. Cheers, and thanks for reading this, Peter