How do I create a report using data from MS SQL database

[trooper]

Hello people.
I have this situation.
I have a database in MS SQL. The users connect to database via MS ACCES ADP applications.
Some tables (like a TV Station or Names of employees) in the database have fields that serve as the flags. If the flag has a value of one, then such a record is used in the query to create a report.
Because there are multiple users of the database, frequently happens that flags overlap. One user sets the flag to one, and second sets the flag to zero. Therefore, it often happens that the received report incorrect.

Has anyone had a similar situation and to resolved.

Thanks!

 

[Pat Hartman]

If you are using a "flag" in the actual record to indicate "selection", you CANNOT support multiple users simultaneously.

Remove the selection box from the main table.
Create a new table with the following columns:
tblSelections:
SelectionID (autonumber primary key)
SelectedBy (FK to tblEmployees)
SelectedID (FK to tblwhatever)

Then use tblSelections to drive the report. Be sure to include the employeeID as part of the selection criteria and don't forget to clear out the selections, either before new ones are made or after they are used.

 

[trooper]

Thank you Pat,
This is a good idea and I'm going to implement.