Recent content by JMay0816

Sure hoping someone can assist me. I'll give a little history first. A while back, I created a very nice report with a couple different content sections. This report utilized one query. To keep it simple, we'll say this: select item1, item2, item3 from tbl1 where item3 in ('A','B') Very...

I have an interesting item here. I am trying to pull records from a table by comparing two fields (a.Field1 <> a.Field2) It works fine when both fields have actual data. However, there are several records where Field2 is NULL. Is there a more efficent way of coding the WHERE clause without...

I'm a little baffled on this one. Here's what I have: 2 tables which both share several common fields. I'm only dealing with two. It's a one to many relationship (only one record in table1, as opposed to possible many in table2) Snapshot of data: Table1 RecNum ------- Item 2009001...

I can't place my finger on this one and need some assistance. It seems that users in my Power Users group can not access anything anymore. For instance, if they attempt to access an Excel file, they get access to read-only file is denied. If I move them to the Administrators group...all is...

Need some help retrieving a additional field for a query. Here's my sample data: DB1: PartNo: PDescription: Status: Master: 100 widget assembly #1 Active 101 widget assembly #2 Active 102 widget assmebly #3 Active 103 drive line...

Can you add a text prefix to a field you select from a select statement? Example: Select field1, field2, field3 from table2. I would like it to look like the following: field1......field2........field3 Pre-<data> 34 square Pre-<data> 22 circle so i want to append...

Not sure if this is the correct forum for this question (please redirect me if it is). I am looking to connect a remote location to our main LAN via a wireless bridge (Cisco 1310). I was going to use a WAP (Cisco 1100) at the facility end but someone told me that a bridge can only communicate...

Not sure if this is the correct forum for this question (please redirect me if it is). I am looking to connect a remote location to our main LAN via a wireless bridge (Cisco 1310). I was going to use a WAP (Cisco 1100) at the facility end but someone told me that a bridge can only communicate...

I have a tough query that I am trying to hammer through. Hoping someone can help. Trying to use three tables. So I start with this: select a.field1, a.field2, b.field1 from table1 a left join table2 b on a.field1=b.field3 where a.field4='W' and a.field5='N' group by a.field1, a.field2...

i'm using PHPMailer currently.

I have created several different system generated email messages using phpmail. One question that was recently brought up to me was if I could make certain items BOLD or even change the font color to red. I haven't found much about this...so is this at all possible? thx

Finally got it: select distinct email from ( (select a.fileid, a.outby, a.adddate, b.email from table1 a, table2 b where a.outby=b.uid and a.adddate < date_add(now(), interval -6 day) and a.status in (1,2)) UNION (select a.fileid, a.outby, a.adddate, b.email from table3 a, table2 b where...

Finally got it: select distinct email from ( select a.fileid, a.outby, a.adddate, b.email from table1 a, table2 b where a.outby=b.uid and a.adddate < date_add(now(), interval -6 day) and a.status in (1,2) UNION select a.fileid, a.outby, a.adddate, b.email from table3 a, table2 b where...

that still returns four records instead of the desired two.

I am selecting records from two tables: select a.fileid, a.outby, a.adddate, b.email from table1 a, table2 b where a.outby=b.uid and a.adddate < date_add(now(), interval -6 day) and a.status in (1,2) UNION select a.fileid, a.outby, a.adddate, b.email from table3 a, table2 b where...