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

Thanks JHB, I finally completed by implementing a left join, the database is not first design by me and I know it is poor but as JHB said, some data have be in the table and I have no choice but try to get over it. Thanks you guys.

if my query has a GROUP BY clause and also union what can I do if I really want to return the relevant row only

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

Thanks, I am done

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)

you are right , use check box

if the project is catered by team A , then team A will be set to yes , if the project is taken care by team A and B, both team A and team B's box will be set to yes

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