Search results

hi guys i have a form with a combo box. The combo box information comes from a query, in the query i have sorted the information in the query to ascending which works fine (the information is a list of drill sizes for example 0.5mm 0.6mm etc up to very large sizes). the issue is when i want to...

Hi guys Ive got a form with a text box that has a date field that the user has to pick a date. I also have a combo box on the same form with different lengths of time in there the user also chooses eg 6 months 1 year 2 years etc. What I want to happen is the third date field text box To look at...

hi all i have created a query based on a form i have created. however the form will not have data in all the fileds how do i create a report from that query but exclude the fileds that have no data in them please help!! thanks

hi guys can anyone explain to me how i can get a query with specific information including a date field to start april the 1st as week 1 and month 1 please bear in mind i am new to access and need it in simple terms thanks simon

hi guys please help me!! i am trying to extarct information from 2 different queries. basically thje first query gives me the number of quotes per month from a class customers. the second query gives me the total quotes per month across the board. what i need to find out is how many quotes as...

hi guys i have a form called quote number which stores the information about the quote then i have a subfrom for the details of that quote. i have set the subform to show the last record entered. this has worked fine however i have now come across the fact that if i enter a new set of figures...

hi guys i am running a database at the moment. i have a select form which allows me to select a specific piece of data which highlights when i select it. however if i want to select more than one item of data which is usually the case when the report is printed out the is no order in which...

hi guys i have a query that sorts date information into weeks. i use the function format([date], "ww yyyy") for doing this my question is how can i sort the date information so April starts as week 1 and month 1 thanks

hi guys i have a query which puts a date field in order i use format([date], "ww mm"] this in my query to give me the date in order by weekthis works but now ive got week 10 in the query this goes to the front of the list which is correct because it recognizes the 1 in the ten to come first...

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 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 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...

hi can someone please help me. i am trying to create a query where only the last date record is displayed and i can choose multiple criteria to display eg i have a table with a field name of quote number and quoted date what i want to do is select several quote numbers and only display the...