Search results

Smart, I was working just that scenario last night and it worked as long as the form stayed open. If the form was closed, when the query ran it would ask for the parameter of forms![Yourformname]![yourcomboboxname]. I also found out that my crosstab queries would not work with...

Yeah, I thought of doing what you wrote but this means entering the department number too many times. The actual department data for the five department is not planned to be on a server, more of a stand-alone. The database is more than just tracking documents as it allows quite a bit of drill...

I have built a database with only my department in mind that tracks three types of documents; Which works fine. Now some of my fellow department heads desire to use what I have built. This is not a problem as their data structure is the same. The difficulty lies in changing the 30 queries...

I did not look at the attached db, but wouldn't the CONCATENATE function work? It would be separate columns in the table but could be printed as one field on a report. Gunner...

Success! This is the format of the one I used: =IIf([subreportname].Report.[HasData]=True,[subreportname].Report![fieldname],0) Entered in the Control Source of the unbounded control on the Report (proper). Gunner...:)

Much appreciate your assistance! The HasData functions like a charm. Question: How would I have known to use the HasData function? Not being a 'experienced' DBA. Gunner...:)

Rich, Do you realize there are five pages of messages :eek: containing the word "HasData"; And you have answered nearly every one of them. I now have quite a few examples. Will be using one of them! Appreciate your assistance! Gunner...:)

I have a report with 8 sub-forms, based on 8 queries, which works great. Four are under the heading issues; the other four receipts. The sub-reports are for four specific time periods. It looks like this; Issues | Receipts Period 1 (10) | Period 1 () Period 2 (5) |...

Success! FoFa, There is always a space when there is a "P" present. Not sure whether one is there when a "P" is not. It gave the same error. I change the last parameter by removing the VAL function at it works; It now reads; QTY...

Here is a sample of data in the QTY/Partial column Could it be the "space" between the number and the "P"? Gunner...:confused:

FoFa I now get a "Data type mismatch in criteria expression". I mentioned in a earlier post that the field is "text", will that matter? Gunner...:confused:

This command, QTY: iif(Right([QTY/PARTIAL],1)="P",VAL(LEFT([QTY/PARTIAL],(LEN([QTY/PARTIAL])-1)),VAL([QTY/PARTIAL])) produces, "The expression you entered has a function containing the wrong number of arguements". Gunner...

nieleg, The "PARTIAL: iif(Right([QTY/PARTIAL],1)="P","P","")" is working great! However, when I add "QTY: val([QTY/Partial])" as a calculated field, I get a "Data type mismatch in criteria expression.". I looked up the VAL function, however the description was pretty vague in the book I...

FoFa, That is where I am stuck. I am unable to configure the query to split the original field. I tried the MID([QTY/PARTIAL],1) but this leaves the "P" in the QTY field and puts whatever is in the last position in the PARTIAL field. Your assistance in showing me how to split the field...

I use a Make-Table Action query to import data from a linked table into my database. The linked table is on a network server that is automatically updated. One column of the linked table is named "QTY/PARTIAL" and approximately 10% of the 500 records have a "P" after a number i.e. 1000 P. I...

I am looking to produce a graphic representation ie. ...Report1 is made by ......Select Query1 which uses .........Table1 which was modified by ............Update Query2 Or is it just not possible from inside Access? Thanks. Gunner...:confused:

My database queries, tables, and reports is growing. Is there a function/utility that will show me for a particular report what queries, and tables that are used to gather the data that populates the report? Thanks! Gunner...:confused:

Found a utility Found a neat Find and Replace utility ADD-In that did what I wanted. It is located at http://www3.telus.net/starthere/findandreplace/. Gunner...:cool: Edit: Initially entered the wrong URL.

I have a database with 20 queries designed specifically for my department (SAM). A friend would like to use my database i.e. queries, reports, etc., but her department is named different (PAM). The the field names in the each of our imported 'data' is the same, EXCEPT, each record in her...