Search results

I used the same code I get the same error in the line set table

can you clarify more please .. maybe example or a thread that can How to adjust the code above

can you clarify more please .. maybe example or a thread that can help How to adjust the code above

The error I got is in (set table) line

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

Network drive Server based There are few who has full access It’s locked by one of us we know who but we couldn’t fix it

Yes I did Nothing there

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

I really appreciate your reply But I am not sure I understand

SELECT stdate, students.nationality , Sum(iif(nz(students.nationality,"")="US",1,0) as CountUS , Sum(iif(nz(students.nationality,"")="EU",1,0) as CountEU, FROM students GROUP BY students.nationality GROUP by stdate When I put the stdate in the selection it forces me to put it in the...

thanks you for the useful notes. i used sum and it’s working fine for the time being Do you suggest another way to do it? also, I wanted to add to that sql a condition to say If the “StartDate” is between two dates I failed to do this with the current “sum” statement

It worked Thaaanks!

Thanks for your reply I tried to do it But I am doing something wrong This is my sql I want US to show us count And EU yo show Eu count Even by using only US it’s not working i don’t get any error But empty results SELECT students.nationality, Count(students.nationality)AS US...

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!

Super Thanks

Ok it is working now It looks that my excel file was corrupted I created a new one and it worked Is there any way to delete a chart in a specific sheet Without deleting the sheet itself

Thanks for your reply I am exporting a table and I am specifying the type of field there already

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

I used [] in all table names and it worked

it worked now Thanks everyone for all your help Much appreciated