Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Schmals

    "search key not found in access"

    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]
  2. Schmals

    having zeros appear in a query

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

    sorting by dates in access

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

    sorting by dates in access

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

    sorting by dates in access

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

    sorting by dates in access

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

    sorting by dates in access

    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]
  8. Schmals

    having zeros appear in a query

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

    having zeros appear in a query

    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]
  10. Schmals

    Calculation problem in Access!

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

    Calculation problem in Access!

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

    Calculation problem in Access!

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

    Calculation problem in Access!

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

    Calculation problem in Access!

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

    Sick of typing out a calendar in word from info in excel!!!

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

    Problem with printing in ACCESS 2000!

    I have created a report in access. I am having trouble printing this report. Sometimes it works when i go into print preview, and print from there. Other times it will print 5 out of 15 pages, or go to 16 of 15 pages and not print everything and i will get errors on the last few pages. I have...
  17. Schmals

    Help in Access 2000 with a Query

    Hello Everyone, quick question, i am trying to create a query in access when i notice that i need to filter/omit certain lines. the problem is that in this column are id codes, that do not follow a particular order (ie. 1-200). they are things like wxy342 or credit. is there an easy way for me...
  18. Schmals

    Microsoft Access Overflow Problem when running reports

    hello everyone.. i am trying to run a report in access.. when i go into the print preview, sometimes it works, and other times it prints errors on the page.. also, when i print, sometimes it will skip pages (ie. print page 9, 10 , 12). now i am getting a "microsoft overflow" message...
  19. Schmals

    vince.. i need parameter help again in access...

    Schmals (TechnicalUser) Nov 26, 2002 vince, I am actually copying the tables from d-base III into access. then creating a query from 4 different tables, but no filtering. i just have the one column that has text 01-12 and the other column is text 00-99. i am not positive that it actually...
  20. Schmals

    access help for parameter values!

    vince, I am actually copying the tables from d-base III into access. then creating a query from 4 different tables, but no filtering. i just have the one column that has text 01-12 and the other column is text 00-99. i am not positive that it actually restricts 01-12 or 00-99, that might be...

Part and Inventory Search

Back
Top