Search results

On the product details form in the Northwind database there is a "Go to Product" box that has the coding below as its row source. I cant make out what the <>Nz function is doing here. Could someone please explain this? SELECT [ID], [Product Code], [Product Name], [List Price] FROM Products WHERE...

Thank you immensely!! I probably should know that but of course I didn’t. I appreciate your time.

sorry typo QR#:[TOTAL]*0.02

I have a field expression for a query as follows QR#:[TOTAL*0.02 this this obviously returns 2% of my total field. My desire is to get the number 1 if the result is less than 1. How would I go about this?

Obviously I’m missing your point here. What is the hurdle I may need to clear?

So if I do this, then on my form how would I have the date formatted?

So, I have a table with a date column populated as mm/dd/yyyy this table will store rows from dates throughout the year only (meaning at the end of 2017 a new table with 2018 dates will be created). I have a query that I am creating in access from that table (the table is called tTeamScores) and...

I have a form that I have users enter/select information on but I would like to add another feature where they can be provided a comment once they completed their data entry, to paste into an outside application. This comment might say "Ive added this to the Other database". Is there a way I can...

I have a table on which I post the volume of items, total less than 10 days aged and total greater or equal to 10 days for three separate ledgers each day. What I'm trying to do is write a query that looks at this table and returns the total of the three items for the three ledgers combined...

I have the following formula to use in an access report to populate it with the previous business date. What I need to know is where/how to add to this an additional part that also excludes any holidays from a range or separate table. I guess I could place all the dates that I know are holidays...

Im trying to figure out if there is a way I can obtain the previous business days date in an access table. Im trying to create an aging list and I need to have it automatically populate one field with the previous business date. In excel I can do this using a formula like this...