Search results for query: *

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...

I used cdate() in my sql query only problem now is if the field is null or blank then #error is displayed in the table

I am importing a txt file into my mdb. Only problem is the date value on my import is taken as a text field. If I change the text field to a datetime field it tells me type conversion error. On an Access report, is there a way that I can convert the text value to a date value? Will this be done...

I would like to use the SendObject (macro) and send the email VIA Lotus Notes. If this cannot be done, is there a workaround? I need to run it as a macro..

I have two fields, lname and dateentered. I want to have a query in Access 2000 that will display only the names where the DateEntered is dated yesterday... somthing like currentdate -1

Do you guys know of any websites where I can download a pratcice exam for cheap? How difficult was the exam?