Search results for query: *

I am trying to create a query in Access to help identify non-approved database records. I have one table containing the standards [TABLE.STANDARDS] and another table containing records [TABLE.ALLDATA] . Three fields are used to create a unique approved combination: FIELD.CATEGORY FIELD.TYPE...

I am trying to create an update query based on parameters outlined in 1 table that correspond to values in another table. tbl_Standards has several fields: Category, Type, Subtype1, Subtype2, Phase, Hours tbl_MasterDataTable has about 50 fields, including the fields in tbl_Standards. I need...

I work with a 3rd party software which uses an Access database. The structure of the software is such that they provide a utilty for importing records into 1 table (via csv), but not into some of the other relational tables directly related to it in the app. I provide some clients with...

I have an Access database, with a field "Model Number". I need to remove the first 4 didgits of every record in this field. I'm having some difficulty with the syntax of the left or trim functions to complete this task. The answer is so simple, its going to drive me nuts, Please help!

I have been doing some very repetitive work for awhile now that I believe can be solved with an append or make table query of some sort. Please help! My situation: I have 2 data tables; [Master] And [Accessory Detail]. [Accessory Detail] contains 5 records, 40 fields [Master] contains x...

I need to have an "auto number" field to assign a unique number to each report generated. Is this possible?

Has anyone useed this VPN Router? Please give me any information you can whether positive or negative. I am trying to make a decision on a low cost router like this, but am willing to spend around $200 for a more dependable solution (ha ha). I would refer an easy to configure user friendly...

I am setting up a VPN between our 2 locations and both servers will be setup with a VPN Firewall and Windows Server 2003. I am wondering if it is possible to backup all the files from the Local LAN at each location to the remote Server of the opposite location? Basically this is just to add...

I am using Crystal Reports to make custom reports. When I insert this one report with a subreport inserted into it,I am not able to preview it in D-Tools, the software in which I am using the reports. Both reports are standalone, and they both work fine without eachother. Its just when I...