I write to write a Query that can return all rows or a specific row by passing a parameter. parameter custparm integer; select * from customers where...

Hi. I think I'm got Subqueries (semi-) figured out... except for one I'm trying to create now. I want to search for owners of properties. The owners are...

I have a datbase with 5,000,000 records. I need to work with records 1,000,000 to 2,000,000. I see that Access assigned unique ID's to each record. Can I use...

Hello Again, I have a spreadsheet with 10428 line of vendor contact information, I need to parse the lines as there are multiple duplicates for one reason or...

I've been struggling with this for hours: I have records with date/time column (having date AND time). I need to select based on date only. No matter what I...

tblRouter:RouterName tblUtilization:routerName, weekending date, utilization % What I want to do is output the routername, and weekending date columns to...

Can I create a query where it displays a list of choice for the user to select. For example I have a query that ask the user to type in a departmen name. Can...

Hey Everyone, I have a table that has a 6 checkboxes and 6 memo notes boxes. Everytime the checkbox is unchecked the agent has to leave a comment in the...

Test

Para ocultar los mensajes omitidos de modo que no abarroten las listas de mensajes

I'm creating a database to track inventory movements for reserve calculation purposes. I start out with two tables, Inv Mov and Inv Bal. From Inv Mov, I...

Hi there everyone, as a new one to computers I appear to have a problem, on start up of my computer it takes around a minute before I get to the user log in,...

Hi everyone. I want to set up a followup process for our customers. The customers receive one or more of several services. The services can be one of 3...

I have a table and three of the fields are AmountBought, AmountSold and AmountInStock. In a query how do I subtract AmountSold from AmountBought to come up...

I have aYes/No field in a table. When I output it's select query to Excel, the field is printing out as True/False. How can I make it print as "Yes" or "No"...

As part of a safety stock - reorder point analysis, I want to compute the historical consumption during specified time windows. As a start point, I have a list...

I'm designing a database so i can keep track of queries at work... I have designed it but I want queries that are over two days old to be escalated there is a...

This is also on the forms- and have not gotten an answer need to know if at all possible as soon as possible- Thanks Thanks for your help I am still not...

I have a table with two fields, Date and Sales. The data goes back 25 years. I would like a query that gives me the 365 day avg for each month in the last...

I have a field in a table that Utilizes a combo box that is populated by a field in a separate table. Then I have another field that I want to be populated...