Search results for query: *

Hello, I have not come acrossed this problem ... I created a .mde from an Access 2002 file so that users without MS Access can use it. Isn't that what Runtime .mde is for?? I'm new to using .mde files ... please advise.

Hello, I am using CRW v10. I cannot figure out how to show the first and last date of the date range the user inputs to show on the report. The report needs to show the range the data is for based on what the user enters in the date range parameter prompt. thank you!

I have a spreadsheet. the 1st sheet is linked to external data that refreshes each month. The 1st column is RegGroup which could change each month and the number of customer records for each rep could also vary. Is there a macro that i can use to update other worksheets per RepGroup so that...

i have this formula: column AE =IF(AC399="na",0,IF(AC399=0,0,IF(AC399<I399,I399,(ROUND(AC399/I399,0)*I399)))) and column AF =IF(AE399="n/a","n/a",IF(AE399="na","na",(AE399*H399))) but b/c you can't divide by 0 the result ends up being #DIV/0! in this field i get "na" in column AG...

I have a query that links two other queries for the final result. one of the query is a crosstab query as management needs to see the month buckets in columns (hence the use of the crosstab query). but each month it rolls showing the last 12 months. i have to manually delete the column from the...

I will start with the query from where the data is coming from and show how that looks. Then the UNION query that is used to combine the Parent in ProductNumber with the ComponentItemCode as the ProductNumber. SQL: SELECT ShowroomOrdersDetails.CustID, ShowroomOrdersDetails.Division...

I do not know why i am now getting a data mismatch error DB_UDF_IMH_ARTIST is a chartext field Data in it are as such: ABC ABC.DEF OriginalArtist: IIf(Len([DB_UDF_IMH_ARTIST]=3),[DB_UDF_IMH_ARTIST],Null) what is wrong with my syntax?

i'm new to Union queries and having a problem trying to figure out how to correct my query. I have a query named "Kits" this links the tables with the parent and the component items that make up the Kit. The Kits query result is basically this: OrderNo ProductNumber Qty Unit_Price...

Hope i will explain this correctly. i have a query that lists the parent item and then the component items that makes up the parent item. OrderNo ProductNumber Quantity ComponentItemCode QtyPerAssemblyStd S101500 GX260 1 GX200-STAND 1 S101500 GX260 1 GX260NS 1 S101500 GX266 1 GX200-STAND 1...

is this possible? if so, how do I accomplish this?

Has anyone created a VI job to import into the BOM Production Entry? I am having a problem figuring out why a component is not showing the Production Entry when done manually. whatever that reason is I have to apply to my query so that it won't show that component. When I do a comparison of...

I'm not sure how to write this query ... i have a table named CurrentBill with: Bill Component I want to write a query that will give me the a list of Bills and Components where the Component does not exist as a Bill from the same table. SELECT CurrentBill.Bill, CurrentBill.Component FROM...

Hello everyone! I have the following question / issue. i need to parse out the 3 letter ArtistCodes as some items have more then one Artist that designed the item. I am using the following at the moment: 1stArtist: Left([DB_UDF_IMH_ARTIST],InStr([DB_UDF_IMH_ARTIST],".")-1) and getting this...

Hi all! Happy New Year! i can't figure out how to modify this query so that it will ignore nulls in the Description field? Expr1: IIf([Description] Like "P/S*","Emplyr Match","401k Ded") currently it updates ALL the nulls to say 401k Ded but i need to have the Descriptions left blank if there...

I have the following query: SELECT Bill.BillNumber, Bill.BillDescription1, Last(Bill.CurrentRevision) AS LastOfCurrentRevision, Bill.DefaultWhse, Bill.ProductLine, Bill.BinLocation, Bill.ComponentItemCode, Bill.ItemDescription, Bill.ComponentRevision, Bill.QtyPerBill INTO CurrentBill FROM Bill...

Run-time error ... no value given one or more required paramete from: UPDATE GuitarOptionDetails SET GuitarOptionDetails.OptionCombo = Concatenate("SELECT Option_Item FROM GuitarHeader WHERE GuitarItem & Option_Item =""" & [GuitarOptionDetails].[GuitarItem] &...

Hello, i need some major help. i think that the only way to obtain the result required is through VBA code (which i struggle with because I can't get it %-) ok, the objective for this project is: To eliminate manual look-up on a physical chart the correct set of guitar programming codes...