Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    Visual Basic




Compare Two Date Fields


How do i compare two date fields in VB

one comes from the table and the other is the system date?




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
How To Compare Date Field In MS ACCESS That More Than 2year Compare To Sysdate In Sql
How to compare Date field in MS ACCESS that more than 2year compare to sysdate in sql


this is my simple logic... but not work....


Code:
SELECT ACName,year(InDate)
FROM ACInfo
HAVING (year(date()) - Max(year(InDate))>=2)
GROUP BY ACName

Compare Fields
I'd like to compare the datas i'm typing in a Formular, to all the fields category where it is supposed to be registered....
how can i do that ??
(The database is Access 97, and i'd like to do this comparison in a macro or with VBA.
thanks !!

How To Compare Records In Different Fields?
Hi,
How do I compare the records in different fields in an Acess db?
For example,
Field1
1
Field2
5
Let's say there is a txtbox in my program. If I enter a number between 1 to 5, the program will check my db and look at the start field(field1) and end field(field2). If the number is in between this 2 fields' records, the program will spit out a unique message. If not, it will display another message.

So, how do I 'program' this program to work? Thanks.

Compare Text In Two Fields
Looking for ways to compare text in two different MS Access cells, and output "SAME" or "DIFFERENT" in a table. I have though about the CompareMode or the VbCompareText, but not sure of the code to perform this action.

Thanks,
Tim

How Can I Compare 2 RecordSets By Certain Fields
Looking for some idea's on how to compare 2 recordsets by a certain field..
Working with an access db and ADO.

Say I have two recordsets, the fields are close to the same.. 1 more than the other but,
I need to compare say rs1 field2 with rs2 field3(can I do this with an sql querry?).
The rows are in different order's so rs1 row 1 won't necessarily be the same as rs2 row 1
(I'm sure I could sort them to avoid this though if this poses a problem).

I'm also having trouble returning only a certain number of rows.
My recordset has 20,000 rows this crashes msflexgrid(error no memory '30006')
I've tried to use rs.maxrecord = 100
This doesn't work. It still tries to load all the rows until out of mem..I'm not home now but I will post my code later so you'll be able to see what I've tried..

:::EDIT:::
Code:
Private Sub SetCon()
    Dim strConnect As String
    
    strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
                 App.Path & "products.mdb"
    
    Set con = New ADODB.Connection
    con.CursorLocation = adUseClient
    con.Open strConnect
    Set rs = New ADODB.Recordset
    rs.MaxRecords = 10 '<---Doesn't Work
    rs.CursorLocation = adUseClient
    rs.CursorType = adOpenForwardOnly
    rs.LockType = adLockPessimistic
    rs.Source = "SELECT * FROM [Product1]"
    rs.ActiveConnection = con
    rs.Open
    
    mblnLoaded = False
    
    Call LoadFG
    
    mblnLoaded = True
End Sub


Thanks for any suggestions
$hep



Edited by - $hep on 10/3/2004 11:09:04 AM

Concatenate Fields And Compare With A Third One
Hey,

Can u tell me how do i concatenate fields
eg :
table1 : address_bk
Area_code char 3
phone char 7

table2 : phone
tel_no char 10

I want to concatenate both the fields in table1 , compare the results with table2 tel_no field and delete records from 1st table which are present in 2nd table...!

I use VB 6.0 as front end and SQL 7.0 as backend..!

thanx,
Twinkle

[SOLVED]Compare Two Fields From Two Tables
I have a problem to solve. I have two tables with same fields. Itch hour Table1 is renew with new values and Table2 is changed with all data from Table1. In both tables I have only two fields. Field1 of Table1 is identical with Field1 of Table2. Example after one hour the tables have these values:

        Table1 / Table2
Filed1 {} Field2 / Filed1 {} Field2
130011 {} 20.0 / 130011 {} 45.5
130012 {} 10.5 / 130012 {} 25

I need the SQl Statement to compare ALL Field2 of Table1 with Field2 of Table2 based on Field1 that is identical to both Tables. Can help someone//



Edited by - Shandy on 3/2/2007 1:51:18 AM

Select And Compare Records With Matching Fields
Not sure if this is something that needs code or not....

I'm currenting using the criteria:

Code:
In (SELECT [field1] FROM [table] As Tmp GROUP BY [field1] HAVING Count(*)>1 )
to select records where field1 matches. The next step is to check that all other fields for those records match. This is currently a manual process. Is there some way to filter the list so that records (there may be up to 10) where all fields DO match are not listed?
At this point, I am not looking to automate the update. Automation is next week's project. This week, I just want to avoid reviewing 1,000 records that don't need adjustment.

In Data Report How To Compare With Aggregate Fields
Hello Sir,
    I have designed a command in dataenvironment that has an aggregate field named NET AMOUNT. Now my question is that I'm querying to the user about the bill no he seeks that has a total sales amount >= his entered value.

How to use this filtering in runtime on that aggregate field        

Concatenating Two Fields To Form A String To Compare Against A UCase ?
Im trying to use a UCase LIKE Search...

This is okay if I only want to search a word/words from one field, but how do I do it if I need to join 2 fields ?

Eg. I have 2 fields CustomerFirstname and CustomerSurname

What happens if the user types into the search "VisualBasic Kid"
where VisualBasic is the CustomerFirstname and Kid is the CustomerSurname ?

It won't find anything...

Maybe someone can take a look at my string and tell me where I'm going wrong...


Code:
Select * From Customer Where UCase(CustomerSurname) LIKE
'%" & UCase(txtSearch) & "%' OR (UCase(CustomerFirstname) &
UCase(CustomerSurname)) LIKE '%" & UCase(txtSearch) & "%'", db,
adOpenStatic, adLockOptimistic
Thanks for any help once again

Compare Dates Multiple Fields Select Earliest
In a table that is named Budget  I have Six different dates in Six Different fields.  Well, the fields can vary whether or not they are null for each record.  Each one of the fields could be null.  Actually, I glanced quickly at the 32,000 records and noticed that one of the records had all 6 fields as being null.  What is the best way to capture the earliest date of the six fields when comparing all of the dates within one record.  Maybe we could create a seventh field to contain the earliest date?

Example: a record in the Budget table contains:

Field 1        01/01/2004
Field 2        04/31/2002
Field 3        02/04/2000
Field 4        null
Field 5        null
Field 6        01/05/1999

I want to capture the earliest date which is in Field 6 (01/05/1999) after comparing all of the dates in the record.  What is the best way to do this?


Concatenating Two Fields To Form A String To Compare Against A UCase ?
Im trying to use a UCase LIKE Search...

This is okay if I only want to search a word/words from one field, but how do I do it if I need to join 2 fields ?

Eg. I have 2 fields CustomerFirstname and CustomerSurname

What happens if the user types into the search "VisualBasic Kid"
where VisualBasic is the CustomerFirstname and Kid is the CustomerSurname ?

It won't find anything...

Maybe someone can take a look at my string and tell me where I'm going wrong...

Code:
Select * From Customer Where UCase(CustomerSurname) LIKE
'%" & UCase(txtSearch) & "%' OR (UCase(CustomerFirstname) &
UCase(CustomerSurname)) LIKE '%" & UCase(txtSearch) & "%'", db,
adOpenStatic, adLockOptimistic


Thanks for any help once again

Speed Optimization: How To Compare Memo Type Fields Fast? (Access)
Hello all, I'm new to both this forum and VB6, and don't know all the ins and outs with access either, so forgive me if I ask a dumb question.

I have a performance issue with an application. To illustrate I'll give a quick overview:

At a given interval, the application shell()'s a dump utility to extract all eventlogs from a computer (This because I don't know how to do this thru the API, and I couldnt find example code) It dumps in .csv format. In 5 days, some of these files can get 600MB big.

A second part kills all remaining procceses (by PID), renames the files, starts the dump again and starts importing the renamed files into a database.

It does this by opening the renamed .csv files as textstream and going over it line by line, checking if the attached Message is already in the database. If so, it adds a reference to the message. If not it adds the message to the database, and then adds the reference. Then the rest of the record is committed to the database.

Problem:

With 300k + records, the search process get's very slow, since I have to compare in VB (Because Access can't compare memo type fields)

My sollution:

Add a 'cache' which remembers the last 10k records with Message and MessaegID, and loop this array first when comparing new records. Use the first 10k records while still collecting new one's till we have 20k, then cut off the bottom part and do again till 20k, etc.

Problem with sollution:

Still slow. (Since Virus scanners and backup's will always have unique messages due to the inclusion of filename and date/time information in the log message, and will fill the cache with garbage)


Anybody any suggestions ? I would post code examples but I doný know how they would be relevant right now.
If needed I'll be happy to supply them.

Thanx,

Jeroen



Edited by - PLJ on 2/27/2006 12:03:01 AM

Compare The Date From Database To The Date Of The PC
Hi

In my vb form, there is a text box for date of expiry. I used SQL command to get the date display at the text box. But, I wanted to compare the date displayed with the current date, date at the PC. If the date displayed is less than one month from the current data, an error message box will occur. The date displayed must be at least one month before the current dare. Can u show me some guidances to do on this? Can this be done?
Thank you.

Compare The Date From Database To The Date Of The PC
Hi

In my vb form, there is a text box for date of expiry. I used SQL command to get the date display at the text box. But, I wanted to compare the date displayed with the current date, date at the PC. If the date displayed is less than one month from the current data, an error message box will occur. The date displayed must be at least one month before the current date. Can u show me some guidances to do on this? Can this be done?
Thank you.

Trying To Compare The Date
I have these 2 variables where i set the date giYear and giMonth (both integers) and they can be increment or decremented as the user changed the calendar month that they're viewing.

this new value is store over the other, so giYear and giMonth correspond to the current month being viewed on the screen.

this is my code:


Code:
If giYear <= CInt(Year(Now)) Then
ElseIf giMonth <= CInt(Month(Now)) Then
response = MsgBox("Months prior to the current date cannot be saved or modified", vbInformation, "Cannot save")
Set ExcelSheet = Nothing
Exit Sub
End If

what i'm trying to do here (and yes i realize that there is an error in the logic checking to see if the month is ok) is verify the date. if the date is before today's date (month and year only) then exit the sub, otherwise continue it....

anyway, what i don't know how to do is compare the 2 dates, the current being viewed and the current month and year now.

thanks for any advice,
-munch

Compare Date
hi everybody..I need to compare two dates (it can be any year from 2003)...I remember that one time I used a function which convert the date into a number from a specific year, but I don't remember right now...thanks

Date Compare
Hi, what is the best way to compare dates, I need compare date but I don't want use the Regional Configuration of every PC


Thanks !!!

Date Compare
hello,please help.how to compare date??basically i have use dtpicker for date select.what i want to do is the system will alert if the date selected by dtpicker is greater than the system date will alert a message.

example:
dtpicker: 13/11/07
system date:14/11/07

please help!

How To Compare Date
Hello
i want to compare Current Date with the field (entry_date) in My Access Database DB.

How can i do. plz plz help me.

i open recordset and write select statement with where clause . What comparison criteria in where clause will search records in rs. Tell me. plz.

Compare Date
Does anybody know how to compare date in VB? e.g. 12/23/98 is earlier than 12 30/98
Thanks

Date Compare
hello,please help.how to compare date??basically i have use dtpicker for date select.what i want to do is the system will alert if the date selected by dtpicker is greater than the system date will alert a message.

example:
dtpicker: 13/11/07
system date:14/11/07

this is my current code.
Code: Dim date1 As Date
Dim date2 As Date

      
date1 = Format(DTPicker1.Value, "dd MMM yyyy")
date2 = CDate(Format(Now))
If DateDiff("d", Now, date1) > DateDiff("d", Now, date2) Then
   MsgBox ("THE DATE Overtime IS After THE CURRENT DATE")
 End If
 End If


please help!



Edited by - monchichi on 11/5/2007 10:16:30 PM

Compare Date In Vb?
Hi: there

How can I compare date in vb?

I only compare date not time, it's really trouble that I have to format

long time to date, but I can't comare two string?


any ideal?


thanks


George

Compare Date
user enters (or selects) a date range

from 2003/01/15 to 2003/01/30

how to check if the date (date field) is within that range in a table? That is, how to compare the date?

Compare Date Question
I am trying to populate a Flexgrid from a Database. I want load records that have a matching date to a DTPicker. When it gets to the comparison line of code it moves to the end of my If statement. When walking through the code I stop at this line and put my curser over each value and the DTPicker which I named OrderDate shows date and time. I am guessing that this may be why I am not getting a match. So I formatted the DTPicker but that didn't work either. Here is my code, could someone help me out with this? Thanks

Code:
Dim c As Integer
Dim r As Integer
Dim oConn As ADODB.Connection
Dim MyRecSet As ADODB.Recordset

Set oConn = New ADODB.Connection
oConn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & App.Path & "Orderdb.mdb"
Set MyRecSet = oConn.Execute("SELECT ODate, CoName, PName, PNumber, Price, Ordered, Received FROM OrderTable")
r = 1
If MyRecSet.EOF Then
oConn.Close
Exit Sub
Else
If MyRecSet.Fields("ODate") = Format(OrderDate.Value, "MM/DD/YYYY") Then 'Problem is here.
If MyRecSet.Fields("CoName") = CNametxt.Text Then
MyRecSet.MoveFirst
With OrderGrid
Do While Not MyRecSet.EOF
.Rows = .Rows + 1 'ADD ONE ROW TO THE GRID, FOR EACH RECORD, IN THE RECORDSET.
'THEN - FILL GRID ROWS, WITH RECORDS
For c = 0 To MyRecSet.Fields.Count - 1
.TextMatrix(r, c) = MyRecSet.Fields(c).Value
Next c
MyRecSet.MoveNext
r = r + 1 'counter keeps track of which row to add the next record
Loop
End With
oConn.Close
End If
End If
End If
Exit Sub

How To Compare Date Values
i want to compare the two values of my textboxes let say:

txt01 contains 01062006 (w/c means dayMONTHyear)
txt02 conatains 03062005 (w/c means dayMONTHyear)

the condition is:

if txt02.text > txt01.text Then
MsgBox "txt01 should be lesser than or equal to txt02"
txt02.Setfocus
end if

my problem with this code was obviously txt02 is lesser than txt01
but still it recognizes txt02 as greater than txt01 because txt02 starts with 03
w/c is bigger in numeric but in reality when we talk about DATE txt02 is lesser than txt01

is their any workaround wherein i could be able to treat txt02 as lesser than txt01...by the way txt01 & txt02 get the values from my MonthView


bst rgrds,
ebyong

Coding Compare 3 Date In Vb...
how to make a comparison between 3 date....??

example of scenario is

'start date >= key use date <= end date'

i do a control with my 'key use date'.....
i want to display a item if the statement is true.....

but i don't know how to do... i try all possible coding but still didn't have a true result.


is there anybody to help me?? plz.........

Date Compare Returns EOF
The code below always returns EOF, but the parameter I passed for date is in DB exactly as I passed with SQL.


Variable type for date on SQL Server side is "datetime".

Below is my test code :


Code:
Dim odate As Date

odate = CDate("01/30/2004 3:58:40 PM")

dep.getTickets odate

If dep.rsgetTickets.EOF Then
MsgBox "EOF"
Else
MsgBox dep.rsgetTickets.Fields("ticketID").Value
End If
dep.rsgetTickets.Close
End Sub

And the simple SQL :


Code:
SELECT ticketID FROM Orders WHERE (orderDateTime = ?)

If I change this simple SQL to :


Code:
SELECT ticketID FROM Orders WHERE (orderDateTime >= ?)
then everything works fine?

What am I doing wrong ? any ideas?

Thanks

Date Compare In Sql Server
i'm trying to get some records according to a RecModD field which keeps the record's last modification date. what i do wrong? (i need hours,mins,secs etc)


Code:
Dim bigDate As String
bigDate = "22/11/2005 10:59:42 PM"
Set rs = cn.Execute("SELECT * FROM clroot.Material WHERE RecModD > '" & bigDate & "' ORDER BY CODE")
if bigDate is String the error i get is:

The conversion of a char data type to a datetima data type resulted in an out-of-range datetime value

if bigDate is Date the error i get is:

Syntax error converting datetime from character string

Compare Time And Date
hi,please help.how to compare the time and date.current have 2 database table one is employee attendance table and employee overtime table.i want to compare the date and time to make sure the employee are preform the overtime on time.from the employee attendance and employee overtime table are contains the the date,time fields.

please guide.
thanks.

Date Compare Problem
Hi,

Im trying to compare a start and end time. It is for validation purposes, If the end time comes before the start time it sets the end time to the start time. However, this logic seems to work except when the start date is any second in the 21st hour and the end date is any second in the 22nd hour.(using military time)

If Not IsNull(Me.PM14_Completed) Then
If FormatDateTime(Me.[PM14_Completed], vbLongTime) < FormatDateTime (Me.[PM14_Start], vbLongTime) Then
Me.PM14_Completed = Me.PM14_Start
End If

I put in some message boxes to see the values of the dates that were entered. If I put 21:00:00 in the start time it shows up as 9:00:00 PM, and if I put 22:00:00 it shows up as 10:00:00 PM. However, it saying that 9 pm is greater than 10pm.

Im lost, pls help
Thx.

Compare Date And Time?
are there ways to compare dates and times?

Compare Time And Date
hi,please help.how to compare the time and date.current have 2 database table one is employee attendance table and employee overtime table.i want to compare the date and time to make sure the employee are preform the overtime on time.from the employee attendance and employee overtime table are contains the the date,time fields.

please guide.
thanks.

Date Compare Problem
I have Access database file OrderDetail which has DateDeliver as Date type field .
I want all order record for the next 7 days from today .
 But when i use the code below , the recordset.recordcount returns zero though the table contains some records within that date period.

    Adodc1.RecordSource = "select * from OrderDetail where DateDeliver >= '" & Date & "' and DateDeliver <= '" & DateAdd("d", 6, Date) & "' "
    Adodc1.Refresh


Pls help me to solve the problem .



 

Edited by - edward on 1/24/2004 2:30:22 AM

Date Compare!What Am I Doing Wrong
I am trying to compare two dates but am getting nowhere. I have formatted the text variable and none work. Please tell me I'm an idiot and have done something really silly. Below is what I have written and tried. Am using msaccess.

Any suggestions would be great
williery10


strSQL = "SELECT * " & _
                 "FROM Resultados " & _
                 "WHERE Resultados_Competicion = '" & Trim(txtCompeticion.Text) & "'" & _
                 "AND Resultados_Fecha = " & Format(CDate(Trim(txtFecha.Text)), "mm/dd/yyyy") & ";"
     


strSQL = "SELECT * " & _
                 "FROM Resultados " & _
                 "WHERE Resultados_Competicion = '" & Trim(txtCompeticion.Text) & "'" & _
                 "AND Resultados_Fecha = " & Format(Trim(txtFecha.Text), "mm/dd/yyyy") & ";"
         

How To Compare Date And Time
How do I compare the date and time like 8132 11:15:40 AM.

My datebase has column with entry like 8132 11:15:40 AM and I want to retieve data with date and time earlier or after then this time. How do I do that.

Thanks,
DKV

Compare DATE Field In Word
How can I compare DATE field in MS Word? I use this but giving error about testing condition, I tried with single quote. short date format (05/30/05) but all give error
{IF {DATE} = "May 30, 2005" "Today" "Not Today"}

Please help

Compare Timer Date Against A Field
i have a timer set to show the current date from the computer inside my application. I need if possible a way to have this date compared any in my data field. Problem the current data is also together with current time so i need for it to split and only compare the date????

in other words i have it display in my application 08/25/2004 01:23:48

i need for it to compare only the 08/25/2004 against a value in my database field, how anyone please very urgent?

If you wonder why i want this is because everytime the application is turned on or changes from one day to another i need for it to delete the old transactions. I need for to compare against this timer because there will be noone there to input the date??

Date Compare Database Field??
I am using this code here to compare a text box with a date and todays date.

dateD = DateDiff("d", Form2.Text26, Date)

I would like to be able to compare to a database record field I have but I cant seem to find a way that works. I want to compare the date with the record field in database.

thanks Nick

Major Date Compare Problem
Ok work with me I have never made a program like this before. Here is my code.
Private Sub Command1_Click()

Open "c:Autodosi.mdb" For Input As #1
If (Now() - RaExpires) <= 7 Then
Open "c:Autoexpired.mdb" For Output As #2
Write #1, Name, Rate_Alarm, RaExpires
Close #1
Print "C:autoexpired.mdb"
End If
End Sub

Ok what i m tryin to do is make the program compare the RAexpire field to the current date, Then write the ones that r true to expired.mdb then as the finally print out the text in the now overwritten expired.mdb to the printer. I know the print command is wrong but I am just all out confused about this.


Thanks Sincerely to everyone who helps me.

Compare Current Date To Datelastmodified
i'm trying to look through the files in a folder and compare the datelastmodified to today's date/current date...if it's today's date, then take the name of file and write to a text. how do i compare this current date and datelastmodified...do i need to convert it to a specific format....please help. thanks.

Compare Date/Time Elapsed...
Can anyone show me how to compare a date and time (that are hardcoded) with the current date and time ?
And then show the elapsed time in seconds ?

Any help is greatly appreciated.

*Resolved* Date Compare Problem
I have Access database file OrderDetail which has DateDeliver as Date type field .
I want all order record for the next 7 days from today .
 But when i use the code below , the recordset.recordcount returns zero though the table contains some records within that date period.

    Adodc1.RecordSource = "select * from OrderDetail where DateDeliver >= '" & Date & "' and DateDeliver <= '" & DateAdd("d", 6, Date) & "' "
    Adodc1.Refresh


Pls help me to solve the problem .

[EDIT: Changed title to Unresolved]

 

Edited by - dilip347 on 1/24/2004 4:24:43 AM

Access Date Compare Datatype Problem
Hey guys,

I've got a problem withe the WHERE clausule of my query.
In my database records are stored and all have a field Start_Timestamp and Stop_Timestamp (both Date/Time format)

When I execute a query like :
CODESELECT * FROM table WHERE number = 1000
  AND Start_Timestamp > '1-3-2005 14:32:17'
  ORDER BY number

Suggest A Finest Way To Compare/check Date...
Hi,
Which is the finest way to compare/check date? I use the follwing code, but which is not giving correct result every time.

Please suggest a good idea.

Code: If DateValue(Format(Date, "mm/dd/yyyy")) >= DateValue(Format(DateValue(dtstr), "mm/dd/yyyy")) Then
    ' do stuff

 Endif    


Thanks

Haris

_____________________________________________________________________

Fail To Compare Date Retrieved From ACCESS With DateTimePicker
here's my code:

Set rs1 = adconn.Execute("SELECT * from ApplDetail where appr = true and level1 = false and apprdate >= " & DTPicker1.Value)

apprdate is a date type data, in Access.
however, i failed to compare it with my DateTimePicker's value... it doesn't return the expected result.
the rs1 recordset is to be retrieved by a DataReport, so only SQL statements can be used...
can you help me this time?
thanks.
Yih

Date Fields
In my acccess database, there are many Date/Time fields. However, I have encountered a problem when I change the Regional Settings for Date format on my computer. I couldn't successfully compare the dates anymore. How do I overcome this problem? Thanks in advance.

SQL Help With Date Fields
I am using VB 6.0 and MS Access 2000. I have table titled tblOrder which has 6 fields OrderID(autonumber), StoreName(text), BudgetName(text), OrderDate(date/time), ConfirmNum(text) and Sum(number). My SQL for the insert is:
strSQL = "INSERT INTO tblOrder (StoreName, BudgetName, OrderDate, ConfirmNum, Sum) " & _
        "VALUES ( '" & _
        varinfo(1) & "','" & _
        varinfo(2) & "','" & _
        varinfo(3) & "','" & _
        varinfo(4) & "','" & _
        varinfo(5) & "')"
When I run this SQL I receive the message Type Mismatch. If I change the code to:
strSQL = "INSERT INTO tblOrder (StoreName, BudgetName, OrderDate, ConfirmNum, Sum) " & _
        "VALUES ( '" & _
        varinfo(1) & "','" & _
        varinfo(2) & "',#" & _
        varinfo(3) & "#,'" & _
        varinfo(4) & "','" & _
        varinfo(5) & "')"
I get the same error. Can anyone please help me? I want to keep the field as date /time as I need to run queries and reports on this table in Access.

Thanks in advance

Date Fields
I am a cobol programmer moving to VB and access. I have been told that I cannot set a date on an access database to blank or zeros. In cobol I am used to accepting blanks and controlling the logic programmatically. How do I deal with the fact that I want blanks to be enetered on a date field in case no date needs to be enetered but also want to have the date definition in the access database for correct sql query function?

Copyright 2005-08 www.BigResource.com, All rights reserved