longmanm
Last Activity: Jan 6 '09, 01:00 PM
Joined: Dec 14 '08
Location:
-
Concurrent access
I am having problems allowing concurrent access to a database I have created. I have set up tools-options-advanced default open mode to sharing and with no locks. The database is found on a network drive. Can anybody explain how to resolve my issue. -
Thats it,
thankyou so much msquared i was beginning to tear my hair out thought i had tried every conceivable option. I had tried using the like operator previously in the criteria of the query.
thanks again -
SELECT Sum(IIf([Scan in Barcode]="HA2*",1,0) ) AS Expr2, Sum(IIf([Scan in Barcode]="ABR*",1,0) ) AS Expr4
FROM [Tran Scan In];Leave a comment:
-
quotes don't appear to make a difference i still get 0 for both queries.Leave a comment:
-
Have changed expression to include sum and still get duplication from the first column.
Query Example:
Column 1:
RHP: Sum(Iif("[Scan in]"="RHP*",1, 0)) returns a value of 0 which is correct
Column 2:
HAS: Sum(Iif("[Scan in]"="HA2*",1, 0)) returns a value of 0, should be 3
Please help!Leave a comment:
-
Count if query in access 2003
I realise there isn't a direct replacement of countif for excel in access but I am struggling to get aggregate functions to work for me in access 2003 queries. I am creating a stock management db, where I scan stock in (scan in table) and scan it out (scan out table) as it is used. Each product has a unique prefix which i want to use as a criteria to search and count both tables and then a simple calculation is required to find current stock....
No activity results to display
Leave a comment: