i have a Database, which contains details of persons like Name, Age, Sex, Address. i want to make a query, in which, the query should ask for the min/max...

Sir/Ma'am, I currently have a query built to search for a text string in any part of the field. The problem that I am running into was that when I use Like...

I am trying to analyze the data I have to find our product sales for the last several years but our fiscal year is from Oct-Sept and the data base...

OUr fiscal year runs May - April. I need to create a report that spans multiple fiscal years. The actual month or day is not important, just the year. How...

I have four data sets that I must compare against each other for matches and similarities. The data is license plate numbers, meaning aplha and numeric chars,...

I know how to make a date format in a table to be mmddyy, but -- how do I get that same mmddyy format to appear in my query results?? It keeps reverting back...

How do I call a stored procedure from Access and make that a records source for a form or report?

I have a table (I)containing some columns with link to other tables(a,b,c,d). Filling in this table, I get a combo choose box to insert values from a,b,c,d in...

Time Schedule Query I have database, the purpose of which is for students to book a date and time for a test. Tests can only be taken at the following...

Hello, I have query into expenditure data as at month end should be entered. An example of the field format is given below Item of Expenditure Jul 31 ...

I have a query that depends on an input box. I would like to add a failsafe to the query so that if the input box is wrong or mis-spelt the user is re-prompted...

I have a database setup with street names and valid address ranges (tbl_segme). In another table, I have customer addresses (tbl_unpub). I want to compare...

All I am trying to do is to change the status of a shipment. I have the status field set to a look up with 3 values in it. Every time I try to change a value...

One of my tables (originally designed in Excel) has about 17 fields. I have several hundred (or even several thousand) records that differ by one field entry....

I totally understand the method for returning Top N values per group as explained in KB article 210039. I want the last 5 or fewer items bought by each...

ok here is my problem i have the following tables bottle size ( which has its own keys) item which has the field price in it and a drop down menu for the...

Hi, I´m trying to change the column name using ALTER TABLE, but I didn´t find any example how can I do that. Could you help me? -- Robson Previato

I have a crosstab query where the value crosstab outputs a date. I want it to output in medium date format but it always gives the general date format. Every...

Sir, I would like to make a bank statement and having problems in calculation because when i m calcualing it calculate whole field not record wise please help...

I have a input table as follows: UserName Action ActionTime FirstLogOnTime LastLogOffTime User1 Logon 10:04:24 10:00 ...