Search results

Starr for starters double check your spelling... (Select Count(*) from [CERT June] where OS =[Catagory IIs].os and [Sum of Catergory] >=[Catagory IIs].[sum of categroy ]) Also take a look at your spaces: (Select Count(*) from [CERT_June] where OS =[Catagory_IIs].os and [Sum_of_Catergory]...

Duh !! Thanks Jon!

OK I got it to work. I went back and changed the original table name to take out the space and that took care of it. Now.... It is pulling the last 5 entries for each trailer. I would like it to just pull the last entry. What do I put in to replace the Between 1 and 5?? Sorry for the...

Thats what I did first. Is there a setting somewhere I am missing? As far as I can see everything is spelled correctly and _ in for the spaces.

Shafh thanks for the question because I am working on something very similar and Jon K thanks for the replies but I'm affraid I need a bit more help... I copied your SQL statement and when I run it I get: "The Microsoft Jet database engine cannot find the input table or query 'Shipment_Table'...

Wayne, I do have a table with the zip, lat and lon. I am pulling that data and from there I want to attach the zone based on the lat and lon rectangulation. I am quite the rookie at code. I was going to use iif statements in a query but it was too complex.

Ok guys here i am again with probably a simple problem... I have a form "manafest" and 2 subforms with detailed load information one pick up and one delivery. within the subforms the pick up and deliver locations are designated by zip code. In a seperate table I have latitude and Longitude for...

Yeah guys I found the space issue after i viewed it. Thanks for the help. Lets go fishin!

That did it thanks!! I knew it was something simple.

Hi Guys I am working on a form letter and would like to have a paragraph on the form but in the middle of the text I would like the members name (which is from a field) IE your candidate [member name] has been found worthy to bo initiated into our illustrious order. I can get it to work by...

are you sure your relationships are set up right? It sounds like it should be one to many from capts to teams not one to many teams to capts.

your company actually looks directly at the table??? It seems dangerous to me. but to answer your question no you can't set formulas in the table as far as i know.

this site has saved my butt many times I'll be happy to help out. I have a New Jersey fishing site njstriper.com and I'll get those links up for you

Thank you sir that should do very well!!

Hey guys its been some time since I have made any updates to my DB but the time has come to create Ver 2.1. Anyway I have a form with a list of shipments. I would like to calculate the miles between zip codes on seperate records. What i need to do this is to select the zip code from the previous...

Thanks Guys! I ended up creating a report from the form. I know it is not the normal way but some of the info on the subforms I wanted to print is not related after it is entered. Thanks again for the tip!!

Ok guys Heres the skinny... I am working on a form with 2 subforms. The form is to be used as a confirmation print out. Problem is when I try to print the form it only prints (or displays in preview) the parent form and no information of the child forms. As always any input is greatly...

Ok guys new issue.... I have a report with 3 subreports. The totals of the 3 subreports transfer back to the main report and are summed to the right. Now I need to sum down. Example: detail (below works fine) Truck #------Inventory sum-----sublet sum------labor--------------sum...

SELECT [master ro invoice 1].[RO number], [inventory RO tracker].[Inventory number], [inventory RO tracker].Qty, [parts list1].[Part Number], [parts list1].Manufacturer, [parts list1].Description, [parts list1].CURRENT, [parts list1].Cost, [CUSTOMER BASE].[PARTS MARKUP RATE]...

There is only 1 record in the table but the query returns it 4 times. The tables: RO number- RO number RO Date customer unit number 343 07-29-02 yadda 774 344 07-30-02 mikes 888 inventory- RO Number Part Number...