Search results

:confused: I am working in Access 7 I have records with attachments, the attachments are between 0 and up to 4 attachments. How can I print the attachment names for each company on 1 page of a report. As of now my report is printing 1 page for each attachment the company has. So if a company...

Thanks, Will this alow the end user to enter the quote number they are looking for?

Sorry for the stupid question having a brain fart here. I want to be able to pull up one record based on the Quote number which is also the Key, What do I enter in the query?? Thanks

Thanks Rainman

I have a check box on a form that is checked when a job is complete. Within the query how can I set it so that when a form is opened it only shows the records where this check box is not checked?

I have a form for a quote request, it is made up of 4 seperate tables conected within a query. Date from three of the tables stores in the quote table based on the Key for the record in the other tables. However I can see all my controld in the edit mode but when I open the form in the add mode...

I am building a database to collect data that at one time was only an excel form. I removed all the text boxes etc from the excel form and pasted it onto an access for. I put all my text boxes, check boxes etc on that imported form. However, when I open the form to input data the form is blank...

Thanks for all the input but I am still confused I tried select but do not know how to start or stop it then I dont know if the exit sub is used with the Else IF or the Select. Select Case (Text2) Case Is = "1" DoCmd.OpenReport First_class_permit_report, acViewPreview, , , acWindowNormal...

This is the code I have on a form to open a reportt based on ehat is choosen in a list box.... Private Sub Command5_Click() On Error GoTo Err_Command5_Click If Text2 = "1" Then DoCmd.OpenReport First_class_permit_report, acViewPreview, , , acWindowNormal Else If Text2 = "2" Then...

I have a query to run a report. The query is limited by job number "this is also the key". However when I run the report it asks for the job number once that is entered it returns 3600 duplicate records?? How can I get it to only return 1 copy of the record I am looking for?? SELECT [Job...

If I don't have Jaro or soundex is there any way to do it?

Where would I use the left() command?? SELECT First([union duplicates].name) AS [name Field], Count([union duplicates].name) AS NumberOfDups FROM [union duplicates] GROUP BY [union duplicates].name HAVING (((Count([union duplicates].name))>1)); Thanks

I have two tables I deleted the duplicates from each then did a union query based on name. However the two tables named things different like vermont college vs vermont college inc. Can I do a find duplicates based on sat the first 5 characters? If so how. Thanks in advance

I have a linked excel spreadsheet, and the fields are: office #, Main office #, office name, # of units sold, The "main office #" can have multiple "office #'s" I am trying to sum the total for all "# of units sold" based on the "Mail office #" My problem is if the office name's are not all...

Gemma-the-husky Thanks works great, had a brain fart over here.

I have a report that I need a text box to show 1 if the number is <.3 and show 2 if the number is >.3 and <=.7 then leave it blank if over .7. This is my statement: =IIf([text17]<=0.3,"1",IIf([text17]>0.3<=0.7,"2","")) However it gives a 2 even if the number is over .7 Any help appriciated...

I have a query and it can be a null value if it is null I want it to return 1 if not null I want the calculation. This is what I have but it will not work. Please help!!! repo on sitePercent of copy jobs not rejected:IIF([Rejected Job Percentage]=0,1,(1-[Rejected Job Percentage])

The queries are screen shots on a word Doc. I don't understand what the ISNULL function for second argument is and in which query would I put it?

Have you tried something like this? http://www.access-programmers.co.uk/forums/showthread.php?t=110203&highlight=sort

Attached are screen shots of three queries used to get a percentage of jobs. If there is no jobs within the date range query 3 shows nothing. Can anyone tell me how if there are no jobs within the date range requested to get the query to give me 100%? Any help greatly appriciated. thanks