Search results for query: *

Jimmy that Works Correctly (and Easy!) Thanks Again Miletracker

I shall try that later busy right now thanks for the reply miletracker

I Would like to do the following : 2 tables named "catagories" and "items" linked to a form that would contain a combo with catagories and a 2 page tab control 1st page would contain a subform or continues form with items filtered by the catagory combo and the second page...

Mark's Idea Works Perfect What I Did is create a combo with field names and 2 buttons (a to z) and (z to a) works great any field can now be sorted thanks miletracker

Guys Have been gone all day Will try Marks Idea in the Morning thanks for the reply miletracker

I Would Like to create a continues form with multi columns and above Several of the columns buttons would allow the user to sort the form (a z) or (Z A) Where do I start???? The Form Is Based Off A Query Thanks Miletracker

I am sorry for not being clear I need to count how many rows of a list contain formulas without checking that sheet rows could be blank or contain data Thanks for the reply

I HAVE A LIST OF VALUE 1100 TO 1500 I NEED TO COUNT ALL VALUES BETWEEN 1200 AND 1299 also need to count how many rows in a list contain a formula MILETRACKER

Taking this question 1 step further I would need to do the same except i would like to add several buttons to a form and attach a clip to each one but i want the f1-F12 keys to activate the buttons miletracker ps sorry for interupting

dhookom's answer works perfectly thanks again guys miletracker

The Following Does Not Work As Expected If Both Locations Are Blank A Blank Is Returned CurrentLocation: IIf([FinisherID] Is Null,[NurseryID],(IIf([NurseryID] Is Null,"No Location Given"))) Changed slightly from CFBaber's Tip Both do not work

Thanks For the Reply Could not seem to get it will try your tip thanks

In a access Query I have 3 fields "Location 1" "Location 2" and "Current Location" Using the if function I want "CurrentLocation" to show the following : If "location 2" is null return "location 1" if location 1 is also null return...

thanks for the response guys what if the crosstab headings keep changing? how to assign that value to my report correctly and as for the first filtered qry i have noticed that it can also cause errrors mile tracker

hI everyone access 2000 I use a form with 16 combos to select items for printing certian conditions must be met or item will not print. ? is after print i need to know wich ones failed to print such as a popup form or msgbox. also on same form items will print in ascending or descending order...

Why does a crosstab not allow filtering or limiting records to date parameters . or am i missing something? miletracker

hI everyone access 2000 I use a form with 16 combos to select items for printing certian conditions must be met or item will not print. ? is after print i need to know wich ones failed to print such as a popup form or msgbox. also on same form items will print in ascending or descending order...

Ok guys I have this data that was collected in access OutDate refers to a column of Datetimes (shortdate) same as Indate and in access i would simply take date column minus the other to get the #of days. when i try to add the expression DateDiff("d",OutDate,InDate,,) in the SQL...

I am atempting to create a stored procedure or query on which to connect a data control and then a report or grid is that impossible or is there a easier solution I am used to working with access so I am tring to do the same things miletracker

Guys I am not at my PC all day so it seems a long time between replies please be patient with me this is not my REAL JOB. Mile tracker