I've a query and I would like to select all lines if the parameters is equal
to 1, over, I would like to list all lines wich the parameters equal to [NUM].
Re: loop help with inserting records ...projectId...Num with numbers 1-1000. ... I currently have the following query selecting projectId from ... The other field in the MonthsEntry... (microsoft.public.access.formscoding)
Re: #Num! ... The Report pulls the data from a Query.... > When the Reviewed field =0 the calculation returns a value ... > Is there a way to make it display 0 instead of #Num!... (microsoft.public.access.reports)
Re: Using DLookup on a query to set value on AfterUpdate ... I suggest you alter your query (Q_JobNumMax) to give Maxa field ... Then add quotes to your DLookup function call. ...Private Sub JobType_AfterUpdate ... (microsoft.public.access.formscoding)
Re: All Dates in a crosstab ... You could probably create a single table with a single numeric column... If you then create a query based on this table and just ... Are the dates used as column headings?... another crosstab question that grouped by weeks rather than days. ... (microsoft.public.access.queries)
Re: Find missing row ... I think your query gives wrong data ... select num from ... > Create and use an auxilary Calendar table. ... > Then you can easily query missing dates like ... (microsoft.public.sqlserver.programming)
