Search results

Here is my code, as you can I see I am sending a query form to send to a list of email address. These are selected via a tbale of addies. what I would like to do is chnage the code, so not only does it attachment the report but also opens up a browser window so users can add additional...

I have created a report based ion a query based in atable using the inbuilt tools for MS access I went for the email report and send to file options. the code looks like this:- Private Sub Mail_Report_Click() On Error GoTo Err_Mail_Report_Click Dim stDocName As String stDocName = "Data...

ok, thanks for your help and apologises for misunderstanding:) Ill try what you suggest with the table ranges. Sounds too complicated for me. Might go back to Excel :D

agreed, approached in an excel way definately. I understand Excel a lot better, trying to use what I know but trying to convert the if statements and using in Access. So any ideas how to fix ithe problem of counting only once it has reached 30000? BTW, deleted prior string as you suggested it...

I am trying to count the hours each year a plane acrrues. for the example :everytime a plane has done 30K miles it needs to be checked for repairs. If i do a range say if hours are between 30000-60000, it continues to appear(be counted) till it gets past 60000. I need to say if it appears...

any ideas ? could i put "sum" in somewhere

OHYR10/1: IIf([ohyr1/1]+[ohyr2/1]+[ohyr3/1]+[ohyr4/1]+[ohyr5/1]+[ohyr6/1]+[ohyr7/1]+[ohyr8/1]+[ohyr9/1]>=1,0,IIf([fh10] Between [yr1engoh] And [yr2engoh],1,0))*[TotalACCperaircraft] the OHYR1/1, OHYR2/1 etc are expression results within the same query It works up to...

I am trying to write a query( design view), I need to count how times someone is in a certain mileage range each year, the problem is because the range is large 30K, once the car/person reaches that range they continue to appear . How can I restart the counter for the next 30K, so they only...

I have created a price list based on a customer's request. I now need to mail merge this list. how do i do this and how do i get around sometimes having a shorter or longer list than the mail merge template thanks for your help, couldnt find a "MS Word " forum

OK thnx, Ill tomorrow when back at work. If we are talking inner join i guess I have to use sql instead of query design? thnx again

Here is the query in design view I cant link product and products directly, i have trimmed product to remove spaces etc. customer product(trimmed) products prices if i could i would just join product-products to pull in prices, b utu i need to trim first. cant upload, settings disable by...

forgot to add, I need the table to be saved as a record of the prices the customer has been quoted

Where do I link the query, I have trimmed[product] in table1 and [products] in another table2 how can i link the two fields, if i link product to product before trimming i get no results If I run the seperate query, 1 with the trimmed product, then link that field to the [products] i...

ok, Table1 holds customer and product details - I have to trim the products in this table to align with table 2. I want admin team to be able to run query ( Make table query1) based on selecting any customer "user input". Table 2 is prices, and products. What should happen when "Admin"...

I have two Queries, 1.A make table query which uses "user input" as a parameter filter. 2.I then want to save the table as user input "customer A" 3 Then used the saved table as "customer A" 4. Then uses this newly created table in another query I want to save the first make table with the...

I have created an access database for work. Due to the size(70MB) of the database our internal network appears to have difficulty executing any queries or has long delays. I dont think the size is the issue, however I am now looking for ways to place on "internet" page but only want users to...

I have created an access database for work. Due to the size(70MB) of the database our internal network appears to have difficulty executing any queries or has long delays. I dont think the size is the issue, however I am now looking for ways to place on "internet" page but only want users to...

Its good to have a sound board in this place just added more text at end of expression &"%") thanks again all Results now look like this:- Sum Of Qty Sum Of USD Value Sum Of WIF Margin %Margin 4 0.00 5,405.76 -5,405.76 free of charge 261...

OK , Thanks EMP and Egg "n" Bacon its appreciated Had a bit of a play and came up with this Margin %: IIf([Sum Of USD Value]<=0,"free of charge",Round(((([Sum Of USD Value]-[Sum Of WIF])/[Sum Of USD Value])*100))) Only it doesnt allow me to format with a % symbol , but I have the Column...

thanks that works well and I can format as a percentage etc, I would now like to highlight the "null" value cells and show some text such as below FREE of Charge" Margin%: IIf([Sum Of USD Value]<=0,"free of charge",NULL,([Sum Of USD Value]-[Sum Of WIF])/[Sum Of USD Value])