Search results

I'm sure this is easy but as ussual can't get it to work I have a pull down list box in a form - List is off a table I've sorted the table (asending) but canot get the list box to do the same. I'm already to slap the forehead and go "duh" so don't hesitate to show me my error Thanks

Hello all - I've done this before but for some reason it doesn't seem to be working now. I have a table with auto number as the primary key. In testing my database i made up stuff to test and am now ready to begin using it. the problem is I would like the auto numbers to be in sequence and not...

where to start? I have a report running off a query. Criteria is entered off a form. when I enter the criteria by running the query I get the result I need but when I run it from the report it goes through the motions but I get no results (blank report). I know more info is needed but as a...

Hello all - Is there a way to have an imput mask for you criteria in a query? I'm asking for a "short" date, (I don't want it displayed in the query though, not sure if that makes a difference) and right know I'm relying on the operator to type it without an input mask, which is causing some...

hello all - kind of new at access but know enough to get around. I have a report being generated off a query that is asking for a start and end date. Problem is I can't display the dates (or don't know how too) because it screws up my sum command. no big deal in the query but I need that...

I'll try and put this a simple as possible - I know it can't be that hard. I have 2 tables - chemicals purchased and chemicals used and two querys that give me the sum of each the 3rd query is the (sum of chemical x purchased) - (sum of chemical x used) which gives me the sum of chemical x "on...