Queries

[Guest]

I am working with the WMS Intellitrack Data Base. This program contains
Reports that are managed thru Access. I am attempting to customize, or
create a report of my own so that I can view the products with the cost of
each product. I'm pretty blind to the deep part of Access........the system
is telling me that the "Query must be created and added to the back end
before the customized report can be added to the front end to access the
query." I have no clue how to add a query to the back end of anything!!!
Can anyone help? Thanks

 

[Joseph Meehan]

I don't know what program is telling you this, but it is common to
"split" an MS Access database into two parts. One placed on a server and
shared by users. That part is called the back end and usually will only
contain data. The front end, is on the user's machine and usually contains
queries, forms and reports. This results in fewer problems and faster
access.

It is possible to have queries in the back end, but normally it would
not be the best idea; however there are times it is a good idea.