Search results

I have two yes/no fields in my database and these are represented on a from by two check boxes. One field is called order won and the other is called order lost. I am going to add another field to the table called "status" and this will appear on the from as a label or text box. I would like the...

I have a custom pop up dialog on which the user enters certain criteria to search for records in the database. They can enter criteria such as customer name, account number, sales-person etc. On clicking the search command button the query is run and a report printed detailing all the records...

Good afternoon. This might be a thread more suitable for the reports forum but here goes. I have created a custom dialog form in which the users enters various criteria for a parameter query to search the database. Sales person name................... Customer name...

DLB Thanks, it's just about OK no. Can you have a look at my new thread regarding an SQL query and try and help. Once thats sorted I'm finished. Thanks again for your time. VC

Good afternoon Could someone please have a look at the enclosed SQL (on a word doc) and advise a correction on the text coloured red. It relates to a parameter query where the user selects a date range. At present the query only works when dates are entered. If the date text boxes are left...

AArghhh!!!!!!!!!!!!!!!!!!!! Can't get this to work, Thanks for all your help but when I set the query up with more than one criteria to search for I get zero records found. As soon as I return to just one query all the required records are found. I have checked all the query design and the SQL...

For Maxmangion............... Zip file is too large, do you have an email address I can send to. Cheers VC

I will have to make copy and then delete all the records and change names etc as some information is confidential. Will upload ASAP. Thanks

I can only do some sample screen shots as word docs. Will these be ok and which would you need. VC

I have just done what you need, do you still need any help with this. It is quite straight forward? VC

Thanks I have set this up but when I run a query I do not get any records returned, even when I search just using one criteria, for example using the original combo box to select just the sales person name. I've renamed the form and changed the query, command button macro etc but this hasn't...

I have a custom form set up as a parameter query dialog box. I currently have only one control (cmbNames) on this form which allows the user to select a sales person name from a combo and search for projects by sales person. I use the following in the query criteria. [Forms]![Project Database -...

Thanks I follow you now, appreciate your help. VC

Sorry Max I'm not sure what you mean by this. VC

Thanks I tried this but I just get the following displayed in a normal parameter dialog box, no sign of the custom form I created. [Forms]![SelectSP]![cmbNames] This is obviously what I entered as the criteria in query design. The form name and control name are correct. Is there something...

I have created a custom pop up form which has a combo box on it linked to a small table containing names of staff. I want to use this form and combo box to select the sales person name on a parameter query. This is just so the user doesn't have to type in the name as this causes errors with...

I'm using the NOT expression to exclude certain records in a query. I can't seem to get it working using more that one exclusion. For example I would like to return records for all sales people excluding............ Dave Smith Alan Jones Alice Carter Please advise how this works in query...

Works fine Thanks VC

Hi I have to calculate the quantity of records that are found each time a query is run. This information is displayed on a form that details statistics on my database. I can do this by creating a new query and adding a total field with the following expression...... Total: Count([Record...

Good Afternoon. I need to produce a report that will detail the number of records that are found in each query in my DB. For instance... Query Live Projects...........24 records found Query Dave Quotes...........16 records found Query Expired Quotes........21 records found etc etc I will...