I am using Access 2002 and have a two character text field that holds the last to characters of the current year, (example 09). I want to retrieve all the...

I am using Access 2002 and have a two character text field that holds the last to characters of the current year, (example 09). I want to retrieve all the...

I am using Access 2002 and have a two character text field that holds the last to characters of the current year, (example 09). I want to retrieve all the...

Hello, I'm working on a membership database for a fitness club, I need to design a query for all the members joined in a certain month of the year, I currently...

I want to run a YTD report that will return the first day (January 1) of the same year of a date (ending date) that I manually enter on a form. If the date...

I have a table that has sales data stored for shipments on calendar days. I have built a query to total the shipments by year and then by week. In the...

This code returns the Month. I need another column to return the year but there is not a YEARNAME function... IIf( Is Null,Null,MonthName(Month(),True)) Any...

Is it possible_

Is this possible with Vista_

How do you pull data (in a query) from a datatype "text" that is manually typed in as either a Y or N so I can append or update to another field that is set up...

Hello, I am using 2 Cross-Tab queries to denormalize data to present in a datasheet view within a subform. I've added a YES/NO field to the underlying query,...

I am trying to put a criteria into a xtab query via the Combo on a form. I use the builder to get "Forms!!0" and this is inserted into the criteria field...

Hi, I have a problem with a crosstab query that sums orders and available inventory for plants at a nursery according to pot size (rows), and colors (columns)....

Hi There, Any help would be greatly appreciated from this forum: I am using the XPercentile function available...

XP Home US$19, Pro US$29 Vista US$29 Up MS Office US$49 Up

Hi, I am trying to calculate XIRR (excel function but not available in Access) using either Query or showing it directly on Report. How can I do...

Hi all i want to make query of data from my x% of the records.i have done it in two ways but both seems not working with me. /////first way i was using sub...

I'm trying to build a query that will show records where ANY of three different yes/no values have been selected. Any suggestions?

Dear friends, I have a table with the following columns: Code#, OrdDt, Quantity, amount, Salesrep, Customer, I want to form a query to show the...

I'm trying to create a query that can total week-to-date, month-to-date, and year-to-date stats. I think a separate query for each would be easist? Also,...