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...

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...

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

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...

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,...

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 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...

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 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...

I have a form that will be used by 20 users. It has about 50 controls. In order to produce the correct criteria, I need to base it on a query of a query (can't...

I am creating a query , say Query1 in which I am joining 2 queries, say Query2 and Query3. I have joined them on a common field, say Field1. Values of Field1...

Quick background...2 tables. 1 with all user information including Week1, week2, week3 etc. (up to week 17). Every week, i have to enter a value into that...

i am trying to do an update of a table with an IIF() statement where if my criteria is true the upade copies the previous record i cannot get the synatx right...

Quick question, is a UNION queries supposed to return unique values? I have 2 tables, both with an field. When I generate an union query between the 2 to get...

Hello, I have a query that uses a parameter on my form to update a combo box. My SQL: SELECT DISTINCT FROM tblPhases WHERE LIKE("*"&!!&"*"); Here's my...

Hi I have 4 separate tables of which all have fields "Surname", "Forename" and "DOB", plus a data column. Tbl_0 = S | F | DOB (this is all 5 users)

hello everyone, sometime ago we had notes on this, but are unable to locate them. We have a file with a lot of garbage in it. All we want to do is select...

Hi there, I am hoping someone can help with my calculation error: I am trying to convert a formula into a workable solution in Access but am not getting the...

Hi, I am using Access 2003 on a XP machine. I have a table with 73,000 records with 4 columns: ID (data type = Autonumber), BIXS_Row_Code (data type = text),...

I have two tables.. The first contains contactIDno (autonumber) and other contact info. I would like to add records to the second table containing mailshot...