I need to know how to add a column to a crosstab query since the wizard only allows one column. The columns are monthly data, but I need 2 columns for each...

I am using VB.NET 2005 to program a Database Application, with Access 2003 as the DB backend. Every now & then, I have to make a series of updates to the...

I'm a novice with Access, but I have to learn it for an assignment for university. The fact is that I have two tables. The first is called tblStudent, with...

Hello. I am a newbie in Access. I am making a Boostore database. Here is the relationship in problem: http://moryasha.narod.ru/acc.gif I set the Data Type...

Hi I need to run a query when a new record is inserted and another one when a record is modified. What events do I need to trap? Thanks Regards

How to write If condition in Builder? I want to write: if a field = a certain value, such as 1, then another field = a text statement, such as good. Can...

Hi, I have the following question: I have a table with all kinds of data including the machine number. I also designed a form with a text field where you...

I was trying to create a form to enter parameters for my query for a date range. I followed all instructions and could not get my query to work or recognize...

Hi, I am creating a form and trying to insert a chart. The chart wizard just allow me to enter 6 fields, while I have 10 fields,how to enabled it.And How to...

I ran a "Make-Table Query" to create a new table in Access 2003. I sorted the "Make-Table Query" in ascending order on a Number field. However, the new table...

Hi, I'm using Access 2002 I have a Query (Query1) which creates 3 sum totals from a table of numerical data. I'd like this query run and the 3 totals...

Lets say I have a few tables; table1 Customers: CustomerID, Name,Address,.. table2: Products: ProductID, Description, Cost table3: Transactions: CustomerID,...

I have a table which shows visits to different units by dates and then whether there was a problem found (using Yes/No) and then several other fields to...

Other than changing the type of field, is there a way to convert dates to their numeric values? For example, 5/28/2006 to 38865.

Hello, I hope you can help. I am trying to get a set of results from my data (a sort of pivot table.. the number of clients referred by banks within a...

I have a problem with this update query I'm trying to make. I'll try to explain best I can. I have I table that contains a list of companys I deal with all...

Hi i have a field in the following format 'Surname, Forename'. I want to split this info two fields - which is the best way of doing this please./ Tks A

Can I run a make table query using two tables and also add a begin date field and a end date field that will prompt the user? Thanks,

Hello, I am trying to find all records in a table (whose entries have either 8 or 9 characters) where the value of the 8th character is either N, E, S, or...

I have a control table(pay_period) with 1 row and 1 column called pay_pd_id the value is '070105'. I'm trying to join to a table with many rows for the same...