Recent content by LebronJames

I placed this in the Report Footer : =Sum(Nz([Totals])) If there is no records then the #error appears.

I have the total placed in the report footer. If the there is a value then the value will appear but if there is a null value #error is displayed. Anyway to get around this?

Using VBSCRIPT how can I add the value of my variable (var1) to the html page?

I am importing an array field into a field within my access database. The field value will show like this: Vermont, New York Dallas, Texas Is there a way to say take the values before and after the comma and place them into seperate fields so it shows like this: Field1...

Thanks PHV the first day of the month no longer appears!! Thanks

My Excel spreadsheet is setup like this: Cell A Cell B Cell C Cell D John Smith Yes Alberta,Ontario,Quebec How can I code it so that I can turn that into this: Cell A Cell B Cell C Cell D John Smith Yes Alberta John Smith Yes...

It worked... how can I say give me the records for this month... How can I say give me records for the year up to today

I have a datetime field where I want take the lastfullmonth... ONLY problem is I am getting the first of the current month as well.. Here is what I am using in the criteria field: >=DateAdd("m",-1,Date()) This displays all of October but also giving me the first of Nov... WHY???????

Problem is the unique field is blank or null... removed the blank or null value and append worked....

Problem is the unique field is blank or null... removed the blank or null value and append worked....

Yes I have a temp table (table2) setup identical to table1. Where the data in table2 is not found in table1 append.... this works on smaller tables but if larger than 150000 it does not work. There must be someowhere the max records can be changed..

When I use an append query on a table of 1000 records, the new fields are added ok. When I use the same append query in table of 300000. Not all the records are brought over. I am using Access 2000. Is there an option in Access that allows me to change the Deafult Max records. Or can I program...

Here is the query I am using: INSERT INTO Table1 SELECT * FROM Table2 WHERE (((Table1.field1) Not In (select Field1 from Table1)));

When I use an append query on a table of 1000 records, the new fields are added ok. When I use the same append query in table of 300000. Not all the records are brought over. I am using Access 2000. Is there an option in Access that allows me to change the Deafult Max records. Or can I program...

This is my query in Access: SELECT Table1.DateEntered, Table1.LName, Format(CDate(nz([Table1].[DateText])),"yyyy\/mm\/dd") AS Expr1 FROM Table1 WHERE (((Format(CDate(nz([Table1].[DateText])),"yyyy\/mm\/dd"))>=Format(#1/1/2004#,"yyyy\mm\dd"))); In design view, there is a criteria field, here I...