Search results

I have some excel raw files ,under a subfolder namely daily ,lets say, called abc_220913.xls there are three worksheets in the excel called sheet1, sheet2,sheet3 only the extension which is "ddmmyy" meet today's date with be append into datebase and I need to append sheet2 only of...

Query4 is the result from left joining of Query3 and Query1 and I would like to delete some of the null data in query 4 while I execute the following code DELETE DISTINCTROW Query4.*, [working hour] AS Expr1 FROM Query4 WHERE (((query4.[working hour])=0)); I get the warning of "Could not...

I have two query called query1 and query3 having the following structure Query1 Project Name, Project desc, start Date,end date,sponsor, TeamA, TeamB, Team C The value of TeamA,TeamB,TeamC is -1 or 0 which is orignally the Yes/No boxes from table , A project can be catered by more than 1...

the [EFS] and [CB] is one of the team for handling the project but after I execute the query as below , it just show -1, 0 as the picture but they are orginally Yes/No box from the table, how can I display the result as a Yes/No box instead of -1 ,0...

When I right click the command button to build the event, how can I go to VB editing screen(b.pdf) instead of access interface (a.pdf)

I am very green in access, which I would like to search the project by team and more than team can take over on the same project. If tick the box for teamA and teamB, only project do by both team can be display, but my Access query as below cannot work, please help I have a table, form and a...