How can I show the remainder of the results after running a query? Eg. I enter a date criteria which shows the user id's for that day, how can i view the...

Table x has two field: customerid, customer_account_type, customer_account_type’s values = 0,1,2,3,4, one customerid may Different customer_account_type,...

Table x has only one field “minus�, whose value from (-∞,+∞). Query as below: Select count(x.minus0) as field1, Sum(iif(x.minus0,minus,0)) as...

There’s a table, with the format: Table1:price,with only one column. I want to use query to Make it output as follows: 1. Price in (0,50k) Price in...

Dear all, I have to run a query to generate the modified data like group a contains 30 perpon, group b contains 40 person, group c contains 20 person, group d...

I am trying to create a query that looks for only items with a time greater than 3:30pm. I created an expression to separate the time out of the date/time...

I have two different items which use Between...and statements and ask the user for beginning and ending information. For one of them the system is grabbing...

Hello! I am working with a table of orders that is related to a table of order activities. An activity record includes a beginning and ending date as well as...

For financial and budgeting purposes, we want to allocate a total project value across the 4 quarters of the year based on the start and end date. I'm...

I have a report that shows summary information received monthy by locations from policy holders. I would like the information to start with the month of the...

Given the start date, how do I calculate the expiration date while taking into account the leap year. Here's what I have so far using multiple fields in a...

I am new to access and am trying to create a query that joins the first and last name in a table to create a new field called fullname that has the first and...

In Access, How can I set criteria to only choose records NOT containing a certain word. I get that if I put "dog" in criteria it will show me all records...

I am trying to create a query that is going to look at the last record that was entered (this will hold the key piece of information). I created a query...

I am trying to do a like criteria with 2 wildcards using a text box as the parameter. The original data comes from our ERP system that I ODBC to. Everything...

Hello All i have a query that i need to make editable. i want to be able to use it to change some of the columns in the second table in my query. anything in...

Hello All I have need to know in one "line" the previous value, current value and the "future" value. here is my scenario. i have a "service report", these...

Hello All I have a query like this: SELECT utblPartListPriceQuery.ID, utblPartListPriceQuery.Partnumber, dbo_PART.ID, dbo_PART.DESCRIPTION, ...

Hello All I have a general question about how best to do something. I have a lot of queries in my app that do calculations at some point in the stacks of...

Here comes some hefty SQL code: qryNewRebuildReport SELECT tblproductpartlist.productid, tblproductpartlist.imwpartnumberid, ...