Search results

Great that did it. :) But, if I may extend the problem a little further. How would I acheive this: :confused: field_a count_a field_b count_b totcount XXXX 5 YYYY 1 sum(count_a+count+b) Edit: Sorry, it didn't work like I said. :o This only works if one or the other queries is empty. If...

I have two queries whose results I want to join together in a third. My problem occurs when one of the queries returns no records so that my third query also returns no records. I have created some pseudo-queries so that I can demonstrate my problem. Query One: select field_a,count(field_a)...

let a=300 let b=300 let c=450 let C=((a^2)+(b^2)-(c^2))/(2*a*b) print C -0.125 ' Calculate inverse cosine let answer=Atn(-C / Sqr(-C * C + 1)) + 2 * Atn(1) print answer 1.69612415796296 (in radians) let answer=answer*57.2957795 print answer 97.1808 (in degrees) The difference in the...

You don't CALL functions. var=myfunction(x)

When the records are created for the user add that users name/sign on/code or whatever unique identifier they use to the table for those records. Then when the records are retrieved just match their id to the id in the table. Am I in time?

In the Control Source use [DOB], then use mmm in the format field section as per my orginal suggestion.

Are you using a Label or TextBox for this date? Where are you putting the DatePart expression? try replacing DatePart("mmm",field) with Format(field,"mmm")

Why not just put the 'mmm' in the format field, rather than use the datepart function.

Firstly, Welcome. Secondly, where/how are you trying to use the expression? In a Report? Query? VB?

ok. In the design query screen Right-Click on the line that joins the two tables. Select 'Join Properties' Then select the option that says something like 'Include ALL records from 'qPrintHeader' and only those records from 'qPrintLines' where the joined fields are equal. When the query is run...

Assuming that the Header and Lines are in two separate tables. You'll probably need to use an 'outer join' rather than an 'inner join'. That way the header will print regardless on any line records. If my assumtion is incorrect then, umm, I dunno! :confused:

I think you need to add a quote " at the end of the first MySql line.

Would it hurt to try? I had the same problem as you (ADO help not working) and it fixed it for me.

From a previous thread Is this the same problem?

You are quite right. It was a reference to "Search Assistant 1.0 Type Library". Whatever that is. It must have come with the download. I unchecked the reference and Date() now works.

I have to admit to being a little confused by that myself. I would have thought it would have worked. But changing from Date to Now causes the 'Date' prompt to go away and the report will display the correct date. Its not something I spent a lot of time investigating.

In the Query, add this to the

Base the Quote report on a query rather than on the Projects table. Then use the quote no as the criteria. At the moment you are getting a page for every record in the Projects table.

try this: SELECT Count(MOL.Hand) AS CountOfHand FROM MOL HAVING MOL.Hand=True;

DoCmd.RunSQL "UPDATE Employees " & _ "SET Employees.Title = 'Regional Sales Manager' " & _ "WHERE Employees.Title = 'Sales Manager';" DoCmd.OpenForm "Employees", , , "LastName = 'King'" Both of these examples are taken from Access Help. Its the first place I'd look ;)