Search results for query: *

Hi, I got a new SQL Server database and are in the process of porting my Access databases to my new SQL Server. I have worked with Access and Oracle in the past but I am new to the SQL Server environment. I have a tool called ConVersion that is helping me rewrite my queries in Access into SQL...

I am currently experience something that is weird to me. A query is working fine for me in Access 2000 but when I or anybody else is trying to run it in Access 2002 it closes Access down completely. No warning no not just the query or the database but all of Access. Any suggestions? thanks, JCA

I currently have a query with 17 columns, sometimes there are only data in 14, or 15, or 16 columns and the other column(s) are left empty. Is there a way that I can delete empty columns automatically so I can set it up in a macro instead of manually check it each time. Thanks a bunch! JCA

All, I am hoping someone can help me out. I was having problems with DLL errors for IE6 and help and tried everything that I know of to correct the error to no avail. I went for the last resort and reinstalled Windows XP Home Edition (I know this is Professional Forum but I couldn't find a...

I am sure there is a simple solution to my problem. I have the following query but I am getting duplicate records in my output if I have more then one month of input. How do I change my query not to get duplicates in my output. Do I have to write a cross tab query or what is the problem in my...

I was wondering if anyone can help me change the following query to include a range. I have to change it to aggregate forecast and need include the last 4 months instead of just the last month. How do I change this to a between statement? It is the bold part that need to be date range. SELECT...

I currently have 2 queries that I need to combine one of the queries contain all the sale domestically and 1 contain all the international sale. They all include the same part numbers. I need to get all the line items in these 2 queries for my new query but my relationship choices limit me to...

I am trying to sum some different data. I have a column named [Price] and a column named [MonthDate] and a third with [Customer] I want to be able to sort the data out so that it sums it by different criteria for different fields. How will I be able to Sum one field for only Jan ’03 Price...

I have a field with dates that I formatted to YYYY/MM. I want to calculate how much I sold in the last year up to the previous month end which in this case would be 2003/01 and 2003/02. If it was Jun 11th 2004 I would need the data from 2003/01-2003/05 (not including June ’03). I was thinking...

How would I make an update to the following: I have a file and some of the part numbers have an –P in the end so instead of for example 1234 it is1234-P. what would my criteria in an update query be to delete all “-P’s” Thanks!

I have a lot of products and a client in Germany insist of sending them with comma instead of period in the name eg part# 321,2 instead of 321.2. Can I write a query to update all the commas to periods in my field in a table? I know that it is easy to do a search and replace but I prefer to just...

I am trying to find out how I can combine some of my records in my table. There are a few items that have been updated and have a new part number. I want to combine their sales history while leaving other fields such as description intact. For example if I have a record called 1234 and another...

I am not sure what the problem is with this. I have a query that change itself. It changes the field name from [095] to [95]. This is a calculated field. I am not sure if it is a Access XP or Access 2000 problem as I created the database in Access 2000 but modify it in Access XP. Thanks for your...

I know that this probably sounds like a very stupid question but I still need to ask as I don’t know the answer. I currently have a table with a lot of records I have another table with records that needs to be deleted from the first big table. How do I delete the records from the big table that...

I need to combine 3 different cross tab queries into one. They do not have the same column headings and I need all the column headings in the result. They all consist of the same rows. Is there a way I can write a query that sum up the total from each column heading and have all column headings...

This is probably a very simple question but I do not know how to do it. I have the following query to get my data out: SELECT [MMM - File with DRP Logic Applied].[Part Number], [MMM - File with DRP Logic Applied]![DomFcst01]*([MasterDate]![Weekly Days]/[MasterDate]![Monthly Days]) AS DomWk01...

I am trying to sort by more then one column. I am not having any problems sorting on one column and my code is working fine when it is like this: Private Sub Planner_Label_Click() Call SortForm(Me, "Planner") End Sub When I am trying to sort by more then one column such as...

I am not sure how I can do this. I have a table and I need to sort out certain part numbers and sort them by month. How will I do that when I have date in there. I need the whole month sale together and not by each date? Can I group it by whole month somehow? Thanks!

I get a division by zero error on the following query as [OH Qty] consist of null values. How can I change it so that null is 0 (That will get rid of my division by zero error right?)? MonthlyDemand: [OH Qty]/[UsageQty] Thanks!!!

I have a table that look up a percentage factor depending on units used, in this table I have set up values that correspond to the right percentage depending on how many units I have of a specific item. I am not currently getting all my records back as some of my items have a unit of 0 or...