Search results

Actually it's working. I forgot to add something. Thanks a lot for your help.

It doesn't seem to work. It returns product A but sales column is empty :(

SELECT [Table1].[Product], Sum([Table1].[Sales]) AS [SumOfSales] FROM [Table1] GROUP BY [Table1].[ Product] HAVING ((([Table1].[ Product])="A")); Sorry it should be "A" and not single space. Do I still use the same syntax with A in the place of sinle space?

Please find the sql syntax below SELECT [Table1].[Product], Sum([Table1].[Sales]) AS [SumOfSales] FROM [Table1] GROUP BY [Table1].[ Product] HAVING ((([Table1].[ Product])=" "));

Hi all, I am trying to use criteria for Product column (i.e keep only product A) Total for Sales column to aggregate the values and it seems that is cannot be done simultaneously. Product Sales A 34 A 45 B 21 A 11 B 23...

It works perfectly!!! Thanks a lot

Thanks for your reply. The function I used to convert the Date-string column to Date is the DateSerial. This works perfect apart from the fact that I get an #error in the Date column for the empty cells in the Date-string column. If I used the formula iif(iserror([Date]),””,[Date]) I still see...

Hi all, I am experiencing a problem which seems so simple but eventually so hard to do. I have a column with Dates as string. I want to convert this column to date which I managed to do as seen below. Eventually I want to replace the #error with an empty cell. If Date column is formatted as...

it works perfectly! Thanks a lot

Many thanks for your quick reply. However I am new to VBA so please forgive me if this is a stupid question but do I just copy(changing the variable names of course) and paste your syntax above in an SQL statement in a query? It seems that I get the following warning: Invalid SQL...

Hi all I am currently trying to do a range join query in access (not an expert at all with it) but I realized that it’s not easy. It probably needs a VBA code but still not sure how to do it. I basically have a column with number of days e.g Number of days 18 1 0 56 8 -19 369 Eventually I...