Search results

  1. J

    Cross Check table

    Hi I am trying to create a query but couldn’t figure out the logic. I need your help I have tow tables: Table A: Item Start date End date Table B : Item Date (first date of each quarter) I want to create a query to get me something like Column heads are the list of...
  2. J

    SQL to find the year

    Hello, I have a field that contains the date in this format 201109 integer Each row includes cost and that field I want to build sql that gets me the the amounts by year?
  3. J

    First record is showing

    Hi I am facing a very strange issue. I have a form Inside that form there is a subform When you click in any record in the subform. Some fields are filled in the main form I update those fields and save them through a save button the save is fine But when I refresh the main form It is...
  4. J

    Sql redundant values

    Hi I have a table with duplicate values. What is the sql that gets me the result 5 (total of values of redundant fields) from below table. And is there any way to get the redundant values only without keeping the original. In the case below, how to get the result 3 Number: 8 9 9 9 2 2 1 5 3
  5. J

    Subform locked fields

    Hi I have a subform container in a main form. That subform is locked I can’t edit the fields. After investigations, I found that the reason why I can’t edit them is because I am using a subform to read a query that uses sql join. I still need to use that subform and edit it. Is there any...
  6. J

    Enter Parameter value

    Hi, I have deleted a field in one of the tables in my access file. Now when I run the interface main file I started ti see this new window asking me about parameters of other fields that I didn’t remove. I went through the code the queries I don’t see anything relevant to the field that I...
  7. J

    Run Excel Macro from Access

    I am trying to scrape data from web from my app in access but I couldn’t find a perfect way to do it. however It’s working perfectly from excel macro using querytable function i am trying to run a code from access to run a macro for me to get the result into excel then take them back to my...
  8. J

    Laccdb are not deleting from share drive

    Hi I know a lot of threds talk about this issue but I tried all ways i have full access I tried to remove it I killed everything from task manager what else I can do Any suggestions
  9. J

    Count based on value

    Hi I have sql statement That shows the total number of students in a table I want to add a condition to the count based another value in the table Nationally: US or EU So I just want to count those only how to this in sql or in query design thank you!
  10. J

    Export to excel

    Hi I am exporting a temporary table in access to excel. It transferred all the complete data. However, the format has some issues I am using the exported figures to create a detailed report that contains charts and some information all in excel when I export the data to the excel sheet, I get...
  11. J

    Group by not working in this sql

    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...
  12. J

    Sql query (having)

    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
  13. J

    Filter query from a query

    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...
  14. J

    Sql statement with datediff

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

    If statement in query

    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
  16. J

    Add a new filed to a query

    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...
  17. J

    Fields disappearance

    Hi, I have a sub form that I am filtering by code everything looks fine The filter is fine and correct However, when the form opens one column shows data (correct data) for three seconds only and then the data in the whole coulmn disappears Rest of columns are fine did anyone face this...
  18. J

    Union table with a query

    Hi I find this forum very useful specially when I get stack with something that takes me long time to figure it out I have a query that gets me certain records. I want to merge the results of this query with another table Example: the query gives me a lis of department name from a table Now...
  19. J

    Duplicate values with a condition

    Hi I have a table ID, Unit, Department I need your help to extract the records (not the count ) but to filter those IDs that are duplicates but the department for them are not the same 1 Unit1 Dep1 1 Unit2 Dep1 3 Unit3 Dep3 2 Unit1 Dep1 5 Unit2 Dep3 2 Unit3 Dep2 I...
  20. J

    List empty status

    Hi How to check if the list is empty and has no data if I put len or value=0 It works only if I select a record I just need to make sure that the list is empty without selecting any record
Top Bottom