Recent content by Schmals

hi everyone... i am having a problem importing a certain table in access. everytime i try i get the error "search key not found in access". i have tried the compact & repair,but that does not work. any other ideas??? thanks schmals [ponytails]

sorry this is so late... here is the SQL code... when i created this query, i had to do it in 2 parts in order to do sum the columns... here is part 1 SELECT ARHIMAST.AR_MM, ARHIMAST.AR_YY, ARHITRAN.AR_WEIGHT, ARHITRAN.AR_SALES, ARHITRAN.AR_PROD, INMAST.IN_PACK, INMAST.IN_DESC...

Yeah! that worked!!!! but here is one more question for a different report... the same problem is occuring in a number column. if the guys don't have sales for an account, that account isn't showing up on the report, it is just skipping it.. i think it is the same problem, but i am not sure...

SELECT [Product Detail tbl].[Shipment Number] AS [Product Detail tbl_Shipment Number], [Product Detail tbl].Brand, [Product Detail tbl].[Number of Cases], [Product Detail tbl].Species, [Product Detail tbl].Form, [Product Detail tbl].Pack, [Product Detail tbl].Size, [Product Detail tbl].Cost...

i tried using [] but when i did that, i got the error message: This expression is typed incorrectly, or it is too complex to be evaluated. Try simplifying the expression by assigning parts fo the expression to variables.... anything else i could try?? thanks schmals

Ok, I tried Or IsNull(ETA USA) = True as well as (IsNull(ETA USA)) (fyi...my column is called ETA USA) i think it might be a tuesday morning thing... but neither one is working..i tried both ways in the criteria section of my query.. thanks in advance for all the help... schmals [ponytails]

Hi! I am running a report sorting by date. When there is no date available, the field is left blank. When i run the report, the info that has dates appears, but the ones that are left blank do not. How can i make those fields blank appear in the report... thanks schmals[ponytails]

i don't think i am using a SQL code (not really sure [ponder]. basically i have 5 columns. customer sales dollars (most have sales, some are zeros) salesmen year (ie. 04, 05) month i need to specify the month and year for the query. when i run the query, it is only showing the customers that...

i am trying to run a query where there are some zeros in one of the columns. when i run the query, it only shows the items that have numbers, and the zero rows are gone. is there a formula i have to put into the table or query to avoid this?? thanks, schamls [ponytails]

hey leslie & golom.. here is all my info... hope this makes sense... Sales Query Tb1: Franchise products (these are the #’s I need) *Product # Description Tb2: Master Product list *Product# Description Weight weight X cases=ttl lbs. (5*10= 50 lbs) Cases Brand Tb3: Actual...

leslie & golom, thanks for all the help. here is the scoop. i am using 4 tables for my sales query and 4 tables for my inventory query. i tried connecting all the tables together in one big query but that was a mess.. so i thought i might be able to do it in a report.... i have a few...

thanks for all your help golom, the problem is that if there is a zero in the sales column, that product is not being displayed on the line. (ex. if i sold 10 out of 13 products, only 10 would show up in the query not 13). right now there is a 0 if there were no sales.. any ideas??? schmals...

isn't there a rule that would let you see the value 0?? schmals [ponytails]

hello everyone... got a really quick question... i have 2 queries that i need to put into a report. the report wouldn't let me use both queries, so i combined both queires into 1. i have a few columns, 1 i have specified product #'s (10 out of 20) and the other i need sales $. what would be...

At the company i work at, we have to track our incoming products. Right now, my boss puts it into an excel spreadsheet and then i inturn retype it and put it into a word doc. (calendar template). does anyone know if you can go from an access database to creating a "calendar". or if...