Capturing all of the data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Our firm recently switched to SQL. I have gone through all of the steps
necessary to link Access and SQL. However, within one of the queries that I
run it is not 'capturing' all of the necessary data that it is setup to
'catch'. I know this because in a different query where some of the same
data is is needed it IS capturing it.

For instance, when we get new clients, a secretary will enter the
information in our new client software that feeds into our Access/SQL
databases, I will then go into Access/SQL and query this data every month;
this info may include referral source of new client, the date the new client
was entered into the system etc. Specifically, however, this particular
query is not 'capturing' all of the new clients that have been entered and I
am at my wits end (probably becasue I am really new to the program!)

I have imported tables, tried to copy one database 'design' to the next but
I am getting nothing.

PLEASE HELP, Thanks in advance
 
Bruce:
If you are able, look at the SQL table directly to make sure the data in
question is there. If it is, look at the query syntax to determine why it's
not displaying. It could be many things such as joins and views etc.

You will probably have to post the DDL of the SQL table and the SQL
statement of the query to solve the issue.
 
Thanks so much for yoru response but I have no idea what you are talking
about!! Could you put it in layman's terms for me? Somthing way simplier?
Thanks
 
Back
Top