Search results

when you say the field 'produces a value of 10 minutes', what do you mean? how are the produced 10 minutes being displayed?

You can put many subReports on a single report. As far as unmatching queries, if you are using Access, go to Queries, click on New, and there is a Wizard called Find Unmatched Query. That should help you out.

What do you mean by different sections of the report? Are you embedding multiple subreports? If so, just create 3 separate queries. If you are talking about 3 columns, you can build each column in a query using the iif() function. I would be happy to give you an examply, but I need to know what...

Just to expound on Dennisk's solution, there are a few steps to accomplish what you are asking. Presumably there is a field with the date the new record is added. To extract the distinct months and have them returned in a sorted order, you would need a query that would resemble the...

If i understand you correctly, your query is returning fldOwner, fldDate, fldValue. The easiest way to create a report the way you want it would be to add another two columns - OwnerA_Value, OwnerB_Value. These columns would be derived columns, so the SQL syntax would...

That's what i was trying to understand - what did you want specifically. If you just want to manipulate the string of the row source, follow these instructions: in the reports OnOpen event, put in this code: Me.RecordSource = "SELECT top " & OpenArgs & " percent ... FROM ... WHERE ...;"...

It shouldn't be too hard, but just to get a clearer picture of the data, could you either itemize your fields, what they can contain, and how you would like to display them on a report?

remove the second grouping level, or remove the text boxed from the second grouping level.

Check out http://allenbrowne.com/ser-66.html, he has a ECount function that would allow you to do exactly that.

If you don't plan on using any grouping levels on the report, where would you want to display the totals? usually totals are displayed in the group footer, but you are saying you don't want to use any groups. You could include in your query a DLookup to have each record return the total for...

Is the record source of the report a SQL string, or a query saved in your database?

I think I understand now - sorry. You have a lookup table that returns an amount based on the number of records returned (in your case $75 for 3 records). I don't know the names of all your columns or controls, so I will use brackets and you can fill them in. Here is the syntax for your DLookup...

It was a pleasure - thanks for letting me know it worked.

You almost got it right, it should say Space(9-len(tblFoo.amount)) & tblFoo.Amount as PaddedAmount you don't have to call it paddedAmount, you can call it whatever you want. The function to use is Space() not Spaces().

The easy way to pad it in the field would be to put in the query the following: SELECT... Space(9-len([Amount]) & [Amount] Basically saying first give me spaces - 9 minus the length of the Amount field, then concatenate this with the data from the amount, and you will end up with a field that...

precisely. The specs are actually stored in hidden access tables. If you want to see what they look like, you can create a query with the SQL SELECT * FROM MSysIMEXSpecs and SELECT * FROM MSysIMEXColumns (Just in case you were interested)

First of all, when you are in the VBA IDE, go to Tools>References, and make sure you have a reference to the Microsoft DAO Object Library. Second, make sure that you created and saved a query with the name MyQuery. Next, when you are in the Export Text Wizard, you can click on Advanced... to...

First create a query and save it, the SQL of the query is irrelevant. For our case we will call it MyQuery. Then, create a button and the OnClick event should be: Dim daoQueryDef As DAO.QueryDef Dim strSQL as string Set daoQueryDef = CurrentDB.QueryDefs("MyQuery") strSQL="SELECT tblDate.Date...

you have to point it to a query or table, but you can use code to dynamically alter the sql of a query.

Access won't let you export the data when the query is parameter based. In your case, it is looking for a parameter from the form. Are you runnning this export query from a form with a button? If so, you can code it so that it actually replaces the query with the frmFoo.ID using the queryDefs...