Search results

Hello, I'm trying to make a query to look for value in my column called 'Category'. The text I want to look for is as follows, *Logical Application*. The asterisks are within the text it needs to find. However every time I try to put "*Logical Application*" in the criteria access changes the...

Hello, Is it possible to output the results of the DateAdd function as a string in a query? I'm currently using the DateAdd function to work out a date 6 months (Field Name: DueDate) from a date specified from another field (Field Name: ValidatedDate). I'm then wanting this to output a status...

Thanks all this is perfect and exactly what I'm looking for :)

Hello, I'm trying to get the last date of the previous month based on a current month. So for example if the current end month is 30/06/2018, I'd like it to return 31/05/2018. I have a text box called txtCurrentDate (Value: 30/06/2018) I then have a second text box called txtPreviousDate...

Thanks Ridders! How would I use a reference table in an update query?

Hello all, I have a single table to which I'd like to update certain records. I'd like to update certain fields for these certain records. For example I'd like to update the 'DataClassification' for Record ID 001 to "Public" but then I'd like to update the DataClassification for Record ID 002...

Hi all, Following the posts using two queries and then comparing for differences that way the problem is solved. Thanks to all that has been involved in helping with this one!

Thanks so much to all that has contributed so far! bastanu, thanks for your upload of your example. I've used this to start building the query I need and what I've found is it's returning the all data (whether there are differences or not). I have data for each month since January as ooposed...

I don't have an import table as an interim of getting to the final destination table. The table I want to do the comparison on is the final destination table. It's simply using Access tools to import the data from a spreadsheet.

Both, Thanks so much for your help! I've understood what you've both recommended. The area where I'm struggling is I don't have a linked table or linked spreadsheet. Each month I upload the data to a single table. Therefore I'm looking to a comparison within the same table. I've tried adding...

Hi all, I have a table called tblAppInventory to which I upload data from Excel spreadsheets at the end of each month. The columns in my table and sample data are as follows: ID | AppID | AppName | AppDeveloper | CodeTestingStatus | NumbOfVuln | DataDate 1 1004 AppOne Internal Passed 0...

Thanks Ridders! You've been most helpful, I'm truly grateful, the main reason for staying with the crosstab is that Low, Medium, High, Very High are the row headings so I get the option to set the text box control sources to those fields. So I have Month, Low, High, Medium, High, Very High If...

So if I keep the crosstab query, you mentioned the subform, would I be right in assuming your thoughts were to have a subform on the main form? Both forms have the record source of my query, one combobox updates the main form and then the other updates the subform? Not sure I understand the two...

Hi Ridders, Thanks for you reply! I'm struggling to understand how that would work on a form. Perhaps this is more a form forum query. As I have 4 text boxes which have the control sources of Low, Medium, High, Very High - I want to have another 4 text boxes so I can compare side by side on...

I have a crosstab query which I am using my forms record source. The query itself looks like this: Month | Low | Medium | High | Very High | February 2018 0 5 1 2 January 2018 0 4 2 6 I've used the statuses as column headers as that is what I wanted my text boses to be populated...

I’m looking to open the query in a new window and this query won’t have any relation to the form. So my form uses another query. I don’t want to change the query on the form but open a query that is based on filters from the form.

Hello all, I’d like to open a query from a form, and with that query filter the data from a series of combo boxes and text boxes. Either through an existing query or a new query. Is this possible to do? I’ve been googling it but I’m struggling to find something.

Wow thank you so much Ridders & Mark_! This has worked perfectly! This is exactly what I was looking for! Thank you so much!!! I truly appreciate all your efforts!

I'm creating a risk map and need the scores per app to use as part of a calculation to plot. It's a little complicated to explain how I'm using the scores, but this scoring system helps me to plot on the map.

Thanks so much for your help ridders, trully appreciate all the support so far! :):) The attachment looks fantastic! Although I'm not sure it's caculating correctly. For example, AppID has two App Issues at 'N' so I would like it to be scoring a '2' but is returning a zero. App ID 3 & 4 is...