Search results

Hi, I have a query which returns values from a column in my table and a split form which shows the table. I have a command button which I want to use to filter the records. I know how to use VBA filter strings for example this one which filters according to a combo box value: Me.Filter =...

Hi, I'm using a pass-through query in Access to trigger a stored procedure which is on my MSSQL server: USE Raptor DECLARE @return_value int DECLARE @ActivityNumber int EXEC dbo.SWACCESSResults @ActivityNumber = '140040024' As this runs on the SQL server (because it's a pass -through...

Hi, I have this pass through query: USE Raptor DECLARE @return_value int DECLARE @ActivityNumber int EXEC dbo.SWANSTAResults @ActivityNumber = '140040014'Which works fine. I would like it to prompt for the value of @ActivityNumber but I'm not sure how to achieve this - is there any way to...

Hi, I have a simple query that returns retailer name, month, and a value figure. I have plotted retailer name as series, month as X axis, and the value figure as data. There are multiple entries with the same retailer name and month because there are lots of branches. The only aggregate...

Hi, I have a report as shown in 1.jpg. First issue: I'm trying to add a field on the 'Activity Code Header' line which calculates the SUM of the field 'Taxable' which is on the 'PMI Code Header' line. I've used the formula =SUM([Taxable]) and this doesn't show an error in design view but asks...

Hi, I have a query which extracts the year and the week number from a date and appends another numeric field on the end so that for example 01/12/2010 1234 becomes Y10-W50-1234 (I may not have got the week number correct but you get the idea) WeekBranch: "Y" &...

Hi and thanks for taking the time to help with my question. I have one table with two fields: Date (dd/mm/yy) Sales (number eg 17) I have a query that returns both columns and hence the sales on each date. I would like to add another field to the query that returns the sales on the previous...

Hi, I'm sure this is a really basic question but I can't seem to find how to do it. All I want to do is add a paragraph of explanatory text in a box, to my form. Something like 'Welcome to the xxx application. Please remember that xxxxx etc' I've tried labels and they let me enter text in them...

Hi and thanks for looking at my question. I'm using Access 2010 and have question about queries, apologies if it's really basic! I manage an SQL server and have a reasonable knowledge of Access, I can make tables, create select/update/delete queries and create linked tables using SQL data. I...