Recent content by cr84net2

I have a classic asp site that is being partially updated to html5 and responsive design. There is a poll in an iframe that I am trying to move to a div. To do this I used $.get('Poll/poll.asp', function(data) { $('#poll').html(data); }); This loads the page/content into the div without...

Sorry, still no luck. I am going to step away from this and reevaluate how I have this set up. Perhaps I should merge the tables and add a field that identifies each as either apparatus, department etc. I truly appreciate your help, and you sticking with me on this. I will post again if I...

I changed table to Menu2 with the same result.

Sorry posting at the same time again.

O.K. Maybe I need to start from scratch. I have five tables that are identical. apparatus, department, news, public_inf and training_center. I need to create a recordset with the following fields from each table. ID, title, sorder and display. display needs to ='1' and I need to sort each table...

When I run your sample it says I am using a reserved word. When I bracket the word [Table] that error goes away and I am back to the error: You tried to execute a query that does not include the specified expression 'ID' as part of an aggregate function.

Skip, we must have been posting at the same time. I will give your query a try.

I also tried this: select 'table1' AS app from(Select Count(app.ID) AS Acnt, app.ID, app.title, app.sorder, app.display From apparatus AS app WHERE app.display='1' ORDER BY IIF(ISNULL(app.sorder), 999999, app.sorder), app.ID) UNION ALL select 'table2' AS dept from(Select Count(dept.ID) AS...

I tried it like this: select 'table1' AS app from(Select Count(*) AS Acnt, ID, title, sorder From apparatus WHERE display='1' ORDER BY IIF(ISNULL(sorder), 999999, sorder), ID) UNION ALL...

After making the changes my select looks like below and is returning the same result. select 1 AS menu from(Select Count(*) AS Acnt, 'table1' AS app, ID, title, sorder From apparatus WHERE display='1' ORDER BY IIF(ISNULL(sorder), 999999, sorder), ID) UNION ALL select 2 from(Select Count(*) AS...

Currently, I am not getting a resultset. This version is of the query is generating this browser error: You tried to execute a query that does not include the specified expression 'ID' as part of an aggregate function. Sorry I am not skilled at using the query tools in Access. Almost everything...

I need to create a recordset from 5 tables with identical fields then reference the records by table. I also need the record count for each table. I am using this for a menu and I have been banging my head against the wall. Any help would be appreciated. This is the select statement I am...

I need to join 5 tables with identical fields then reference the records by table for a menu on a website. The database is access (I know). I have tried literally hundreds of different approaches with no luck. Here is the Select statement that I am currently trying. dSQL="select 1 AS menu...

You know, I am wondering the same thing now. This is one of those things that just got out of hand. First the client wanted one misc page to use as they wished, whenever they needed it. Later, after I was done with the bulk of the site, they said let's make it two...still later , how about 5...

Hello, I have five access tables each with the same fields named misc1, misc2, misc3, misc4, misc5. There is a number field in each table named display. If there is a 1 in the display field, I need to display a linked image to a page where the content from the table can be shown. I have done...