Search results

Perfect It worked except one small problem When I run it, it askes me to enter a a parameter for (under 1) and for (1-6) When I click ok without entering any value for both it runs the query perfectly how to avoid these parameters messages?

My ID is not autonumber So I built sql to get me the following table Similar to above except that I added the unit ID Unit Under 1 1-6 34 Unit a 0 1 34 Unit b 1 0 34 Unit a 0 1 60 Unit c 1 0 60 Unit c 1 0 I want to modify it to be like this; ID Unit...

Thanks for ur reply What do u mean by: In the query window, change Group By to Where

hi, I have below query. It’s working fine .. i just need to group the results by the ID i tried to create group by ID, datex, [under 1], [1-6] It gives me error message (status = 'Open' And [table1].datex <=#3/31/2022#) is not part of the segregated group by What is the best way to group the...

This is helpful thanks

Thanks

Hi How to add one more condition to the following query I want to say where name=‘abc’ SELECT Name, COUNT(ID) AS Duplicate FROM Products GROUP BY Name,ID HAVING COUNT(ID)>1

That’s a good workarround I can create another query for the other uses and specific one for this report can u help me or maybe share a link or something How to run a query from that temporary variable (form textbox) what would I write in the criteria that indicate that variable

How to do this I have the variable in the form How to pass it and run it to the base query and execute it before I run the report ti make sure that i am reading correct data

Very complicated I tried this at the beginning

Thanks your reply in the load event in the report I read a variable from a form which filters me query 2 and populate the report I just noticed thar my report is reading a query that is depending on another query that I need to filter as well. Is there any way that I can filter query 1 in the...

here is my question I have a report that uses a query (query 2) Query 2 is actually using another to build up (query 1) In the report load event there are few sqls that populate data in text boxed mainly using (query 2) How to run the report in away that make sure that query 1 also get...

Thanks it worked with single quote

I have sql query Datediff(“m”,date1,date2) How to replace the “” Access is expecting the end of statement with this syntax

Hi I have a query that has a certain number I want to creat a new column in the same query an expression: If this number between 1 and 10 then put the value 1

I can’t do attachments from my machine I guess it’s difficult to explain the issue. it happened to me several times where an entire column disappears with blank although the filter looks good Even when I extract it to excel it shows blank why this specific field I am not sure anyway...

this is helpful It worked Thanks a lot

Hi, I am really learning a lot from this amazing forum i have a query that is working perfectly One of the fields is date is it possible to add one more filed to this query to calculate the date difference between that date and today (by month) i just want to add one more column to the...

Normal text box Plain text

Sub form Sheet view There is one coulmn that keeps dispearing after two seconds Strange