Recent content by dmaier

I need help with an update SQL. Basically if there is a phrase at the end of a column that I want to remove. Example: Hawks' co-Owner stays optimistic-September 1 Keeping Camby a taxing issue-September 1 Nuggets strive to aim higher-September 1 There are a number of these and what I would...

I run a site on a dedicated web server and am trying to solve a problem with a program I have installed. It is in mysite\databases folder and the problem is there is an Access database which can be downloaded if you go to the URL of the database such as entering...

I am trying to work on a query and am having trouble getting it to work correctly. I am trying to use two ranges to pull troop information. I am looking for all troops below 6000 and all troops between 7000 to 8000. Does anyone know how to write this as criteria in the Design View of a...

I just tried this, for some reason it doesn't seem to work. It just loads the regular page and not the new page.

I have a site that I am creating pages that adapt to different screen sizes. I am using a script for the regular pages that works like this: <script language="Javascript"><!-- if (screen.width < 1000) { document.location = "showArticle2.asp"; } //--> </script> Some of the pages have news...

Chaz... A further question...My field name from the table I am getting this from in my query is e_begin_date. How would I use this with the DateAdd function?

Is there a way in a query to convert an integer to time. In otherwords 570 would be the integer and I would like to show 9:30 AM or 840 being the integer and showing 2:00 PM. Thanks in advance for any help.

I have a report I am running for events with subevents. The report runs off a query where the event code is inputted and the query lists the individual and the subevents they are in. The output of the query is like this: EventCode, SubeventName, Name, Address, Phone The query is a simple...

Roy Thanks. sorry for the oversight in being in the wrong place. Your suggestion worked perfectly.

Thanks but sometimes there are 3 and sometimes there are four characters...eg C061 so I need something that will get rid of the first three characters to the left somehow.

Thanks for the help I got on the previous question. Your solutions worked well. I have another question I need some urgent help on. I have a value for a field that can be outputted as example 05_C06 or 05_C07, etc. depending upon the values for the field. I would like to output only the C06...

I have a query which uses a cryptic value of me21 in all records for someone who has registered via the web. In a report I want to show all of the values of me21 as WEB. I think there is a way to do this but don't know how. Can anyone help?

I have a table that needs to have data moved from one with identical fields to another. I want to move data with an id higher than 75615 to the other table. The fields are headline, link, team, and Pdate The idno field is a field which is auto increment. Is there a good way to do this...

Is there a way to reverse or juxtapose(I guess that is the word) a column of names.... Example: Bob Miller Change to Miller, Bob Do this for a whole column of names. Can this be done?

Doesn't really work for me I tried reformatting the cells to text and then pasted and it still comes up wrong. I tried paste special and using text and it puts everything in one column instead of multiple columns.