Is it possible two compare database and display only current projects to show? Control of the project status of previous year and the new exercise must be, however, possible as the status the same is.

Hi
Can you explain please? What database? What is a project? What is "current", what is the project status?


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)

Sorry
financial accounting system

databese = .dbf
project = project costing (customers)
current status= state of the project  progress

DBF is a file format (DBase in fact)
Project and Status are concepts applicable to your financial system and not actual entities.
Your financial system is stored in a structure within the DBF (in fact, probably more than one DBF).
Do you have the structure of this DBF, and the project and status values?


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)

i know how to read the column from the DBF file

Conn.Open ("Driver=Microsoft Visual Foxpro Driver; UID=;SourceType=DBF;" & DBPATH)

structure of the DBF

column = proj_code project name

column = pro_stat   state of the project  progress

proj_code  proj_desc  pro_stat  ....................................

i need to compare this two columns from 2 of more difference DBF files