Search results for query: *

The first one was actually right. I had an error in one of the tables! Thanks to you both

Maybe I did this wrong, but it seems that the results are coming back as the approved records as opposed to the Non-approved. The example below is based on the actual field names from my SQL query. Anything you can see I did wrong? SELECT MasterDataTable.* FROM [MasterDataTable] LEFT JOIN...

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...

THANKS FOR THE TIP, YOU GOT ME ON THE RIGHT TRACK! THANKS!

Well that would work for that particular combination right? the tbl_Standards has hundreds of combinations. I am trying to avoid creating a different query for each scenario, which is what I have been doing in the interim for a few combinations. So ideally I would have a query that just...

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...

Thanks! I used an iteration of this, but I got what I needed to solve my problem. Thank you very much!

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...

Thats what I told my boss--but he insists that we need to have this functionality on our network. Any ideas?

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...

It previews fine in Crystal Reports with the subreport inserted. It is only when I try to preview it in the application that I am having problems. I took the subreport out of the report and it previewed fine in the application, as does the sbreport on its own. Its only when the subreport is...

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...