I need some help writing this query. This should be simple, yet I can't get it to work as I want. I have a simple database to keep track of incidents. I...

I have a query that returns a monthly count of an activity as a crosstab, but I need the query to group by 6 monthly instances. Can anyone help with the...

Hello, I am looking for a way to calculate a date start + 6 months and then sorted by the current month we are in. If this can be done in a query please...

Hi, I'm running the following query through an ASP script: SELECT COUNT(*) AS resultcount FROM facilities WHERE mod_date 12/21/2005; I know for a fact in...

how to identify data greater than 60 days old

Would like to see older birthday logos on here

Drivers Firmware R4i Dsi . Firmware R4 Dsi nintendo http://www.elotrolado.net/hilo_firmware-drivers-nintendo-dsi-r4-i-upgrade_1214985 Firmware Drivers R4i...

Access 2003 I seem to have this limit. The rest of the text is simple cut off after 65. My table has the field text set to 255 characters. Is there somewhere...

I have a like Query that the user puts in a date. I would like the date to be the start date for a week. How can I make it so that the Query will show 7 days...

I am running a monthly report to summarize the inventory & commodity spend for our department. The way the chick prior created the queries is rather...

I am using Microsoft MDE 6/ J++6 to work on a webpage which takes information a prospective customer has submitted to an ASP6/javascript webpage via a "send...

I have a start date for a client stored in a table. Each client needs to be reviewed every 90 days (do not care about working days or holidays -- just a...

I'm trying to figure out hoe to calculate 90 days from hire and the first of the month Example: HiredDate Insurance activated 1/3/2010 ...

After converting from 97 to 2003, text datatype is defaulting to binary. I've checked the 97 tables and the datatype is text. This is sure upsetting the many...

I'm trying to build a single SQL statement to return all patientID that have had codes 99222 or 99111 rendered but haven't had code 00007 rendered within 8...

Thanks, that helped bunches. -Scott

I just found new solution for some problem. Understand that it is obviously that it is far away to be compared with American continent discovery but anyway. As...

Hi I am trying to create a query to group pathnames when all I have in my source table is a fully qualified filename. ie I have a record that looks...

ULW: IIf(40,,IIf(40,)) More specifically, this needs to return: If If is equal to OR less than 40, How do I work in the "equal to"? Thanks in advance!