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

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

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

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

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

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])

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

I have a a table that changes monthly, and each month I need to find the records from the old table that are not in the new table and visa versa. I made the entire row in the table the key. and wrote two find unmatched queries. However, the queries are not finding all the information that is no...

I have a an employee table and am setting it up to print labels for different distribution lists. however sometimes the labels need to be marked "Confidential" or 'Conflicts" etc. Is there a way to have a pop up box open on report open with a pull down menu to pick the heading of the labels???

I have a table of 50,000 reccords. The table has 8 fields of theses eight fields I want to remove duplicates based on 4 of the fields in a query. Is there a way I can do this and keep the uniqe identifyer so that after the duplicates are removed from those 4 fields I can match them back up with...

I have a button that runs a macro to insert NOW() into a text box. This is how it is coded; Private Sub Start_transferred_job_button_Click() On Error GoTo Err_Start_transferred_job_button_Click Dim stDocName As String stDocName = "Start transfered job" DoCmd.RunMacro stDocName...

I have a burron to run a query that auto populates 'start time' with NOW(). It has worked for 3 years and now I get an error message see attached. The only thing I did was change the program fromm 2000 to 2002. any and all suggestions welcome. Thanks

I have a table with a "NOW()" field I need to change the now() to a Date() in a query so I can pull information by date values. Because of the time in the now() field it pulls incorrectly. I have tried this: cdate(int([job log in]![time qc totally complete])) this will give me what appears to...

I have a report that calculates "total pages" by group and then overall. If I run 1/1/05 - 1/31/05 I get 10326 pages for report total If I run 2/1/05 - 2/28/05 I get 11206 pages for report total If I run 3/1/05 - 3/31/05 I get 9567 pages for report total this totals 31,099 pages for the...

SELECT [Job transfered to].[Job Number], [Job transfered to].[assigned to], [Job transfered to].[Start time], [Job Log in].[Client Number], [Job Log in].[Matter Number], [Job Log in].[Client ID#], [Attorney Profiles].[Client Name], [Job Log in].[Work Type] AS [Job Log in_Work Type], [Work...