Search results

hi all i have made a multiple selection form which selects a 5 digit number from a list in a list box. when i select the numbers (which could be a anything from 1 number 2 twenty numbers) i then press a command button to print out a report based on the numbers i have selected. my question is...

hi again thank you very much for that this works fine will probably need to ask a few more things as i go on!!!!!!!!!!! thanks again

hi i am now getting the error message data type mismatch in criteria expression!! any idea!!!!!!!!1 thanks

hi guys ive done what you suggested however i keep getting an error message which reads syntax error (missing operator) in query expression "(quote number in (47258,47588))" the full SQL view is below i have altered to include my tables Private Sub cmdOpenReport_Click() On Error GoTo...

hi do apologize!! yes didn't see the link to the sample this is exactly what im looking for thanks ever so much and for your patients im going offline now

hi again thanks for that this is to find a single record im guessing so how do i now select several different numbers ie if i want to display the records for a number of different quote numbers using the same query? or am i barking up the wrong tree???? thanks again in advance

hi sorry for my ignorance!! im not sure what you mean when you say use like and wildcards exactly how do i write this??????? this information is then going to be part of a report based on the information the user has selected again sorry for my ignorance!!

hi again sorry i should have explained it better i have tried this (as above) however when i run the query it doesnt show the result if i just do one parameter ie [enter quote number] it works if i do [enter quote number] and [enter quote number 2] it asks me the second quote number but doesnt...

hi all my question is i have a query that shows the last record for specific sets of data. this works fine however what i want to achieve is the user to be able to select a number of different values within one field then display this information in a report i have tried [enter no] and [enter...

hi any luck on the question or do you need more info????????

hi QUOTE NUMBER table consists of QUOTE NUMBER (PRIMARY KEY) SOURCE, NEW/EXIST, CUSTOMER, INDUSTRY and finally SUB CON/PROD QUOTE VALUE table consists of QUOTE ID (PRIMARY KEY) QUOTE NUMBER, QUOTE RECIEVED DATE, QUOTED DATE, MIN QTY, MAX QTY, COST EACH MIN, COST EACH MAX and finally STATUS my...

hi thanks for your reply ok i have written a sales database which is driven by quote numbers each quote number having a unique set of data. in this example if i do a number of quotes for one customer i would like to let the user type in the quote numbers (which could be several) and the query...

hi all i am trying to create a query so i can input several items from one field and display the data in a report is this possible????????????? i have been trying this for a while!!!!!!!!!!!! thanks

hi all i have 4 tables consisting of Quote Number,Quote Value, Late Quote Reason and An order Detail table i have set up a relationship for the quote number table to have a one to many relationship to the quote value table and this is fine however from the quote value table i need to create a...

thanks i got this to work now however there is a part two to this query. in the quote number field i want the user to be able to select multiple quote numbers to eventually create a report to display the selected quote numbers as a customer order because the customer will not always order 1...

hi yes this works for just the quoted date hovever how do i then do it to inclued the information i need??? the extra information i need is ordered date drawing number issue number customer del date appologies in advance if this is something simple!!!!!!!!

hi this is the sql view i also have a parameter value in the quote number field this is to choose a specific quote however i want to choose multiple quote numbers and only display the last quoted date in that quote number if this makes sense please help!!!!!!!!!!!!!!!1 SELECT

hi this is the sql view i also have a parameter in the quote number field to choose a quote number however i really want to choose multiple quote numbers and only show the last record in that quote please help!!!!!!!!!!!!!!!!! SELECT

hi this is the sql view SELECT

hi i have tried this i have the query as a totals query then put the group by to max however i dont get the answer i want all the records are still displayed