microsoft.public.access.queries | Forum profile

  >>I was trying to add the 1 in the query until it equals the 20 and then stop. What field in table 2 is it being add to? How about posting the SQL of your query. -- Build a little, test a little. "accesshacker" wrote: > The query I have been working on is populating the 1. No fields are being > reduced to zero. Table #1 is only a holder for what is remaining. I am > testing right...

  What do you mean by "publish those results"? Do you want to display these results in a report? If so the only way to get 200 of anything on a page would be to use Karl's suggestion. Or do you want these results to be posted to an Excel file, 200 records per page? Or something else? ---- Dale "Biss" wrote: > Access 2007 > > I have a simple table that has about 2,300...

  What happens when you run just the following? DCount("*","Deductions") It should return the number of records in that table. If that crashes there's a possibility that your database is corrupt. First make a backup copy then do a Compact and Repair. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Brad P" wrote:...

  Try the following criteria Not Like "########" Or Is Null or optionally you could use Not Like "[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]" or Is Null John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County Todd wrote: > I've got an access dbase that has a link to an sql dbase table. I didn't > create the sql table and...

  Perfect! thanks a million ! "John Spencer" wrote: > IIF([C0] like "[*]*","HP" & Mid([CO],2),[CO]) > > OR you could use > > IIF(Left([C0],1) = "*","HP" & Mid([CO],2),[CO]) > > John Spencer > Access MVP 2002-2005, 2007-2009 > The Hilltop Institute > University...

  When suggesting there is an error, always provide the error and/or results. Why are you mentioning "control"? Are TimeStart and DateAppointment both date values? Are either of them Null? -- Duane Hookom Microsoft Access MVP "Sam" wrote: > I am trying to view records where the date value of one control equals that > of another. The following clause causes an error: > >...

  I tried to follow the steps, I created a query with the SQL indicated, but when I connect the query with the report, I get a message that says "Multi-Level GROUP BY clause is not allowed in a subquery" "Allen Browne" wrote: > You can use a subquery to calculate the sum of previous transactions. > > Type an expression like this into the Field row in query design: >...

  Need2Know wrote: >Good Morning All, Is there a more efficient method of finding closest >date between unrelated tables? Any assistance provided is greatly >appreciated. Thank you all in advance. > > SELECT TOP 1 tbl1.[SomeDte], tbl2.[SomeOthDte] > FROM tbl1, tbl2 > WHERE tbl1.[SomeDte] < tbl2.[SomeOthDte] And tbl2.[SomeOthDte] >Between tbl2.[SomeOthDte] And...

  Hoachen - Yes, this can be done, but I would worry about multiple matches occurring... I also don't like the special characters in the field names... To do what you want, make the query an inner join, but don't join on the Dep$ = Return$ at all. Then add a field in your query for ABS([Dep$] - [Return$]), and set the criteria to <=0.10. You can test this, and then uncheck the 'Show' box for this new field...

  You second SELECT is missing its FROM clause; try adding FROM Competitors just before the last GROUP BY. Vanderghast, Access MVP "Hugh self taught" <Hughselftaught@discussions.microsoft.com> wrote in message news:B76B9916-EC93-498A-99B4-5705E2EBE250@microsoft.com... >I was given this sql code but have the following error which I can't >resolve.. > > "The...