I have a table with 2 primary keys that are in TEXT format. Date is Primary Key 1 in this format (e.g. "2005.08.30") and Time is Primary Key 2 in this format...

I am trying to narrow a search field down by topic. I have over 200 rows of information, that fall into 4 topics. For sake of arguement we will say 50 rows...

Can a field in one table get its value automatically by referrencing the value of another field in its record against another table? as best I could explain...

Did this work? Have you done this? I was looking at doing something similar. If you got it to work I would be interested in the file if you wouldn't mind...

Hi All I have two tables - tbltaxes and tblvoters. The tables are structured the following way Tbltaxes Field Description Location Address of the...

I've been looking at similar questions posed on this discussion board, but I can't quite figure how to do what I need. I have a Guarantors table with...

I have a table consisting of several fields, where one is a customerID. I would like to repeat all records for one customerID in the table, but changing the...

I am required to find a daily average balance in an access database and am lost. The data that is entered is not on a daily basis

I have the following code on my report: Private Sub Report_Open(Cancel As Integer) Dim PONum As String PONum = "1276" ' Sample number for testing Dim db As...

Hello Access Gurus, I have a group of empty fields attached to purchase orders I need to update with the same number. Right now, I am having the update query...

In AccessXP, I'm looking for the proper way to set up a query that takes a number of records (rent and CAM amounts for each of several properties) and combines...

Hi! Thanks for your help. I'm using Access XP. I've created a query that needs to pull all client/matter numbers. The numbers appear like this: ...

Hi all, I have a form linked to an "invoice header". It contains a subform linked to an "invoice line" table. On the subform, I have a couple of calculated...

In a query, I want to display the value in a field if another permission field is yes. Ex: I want to display the email values in a list if the permission is...

Hi there, I have two queries that give me the information that i need. I want to join these queries together to have the results show in one query, not two. ...

I have a form that has a query named "qry_MemberFirmsView" but this query is not updating the table "tbl_MemberFirmsView". The value is in the query but not...

Hi there, I have a nested query. THe first one shows records for date 1 (say July 29). I have a second query that shows records for date 2 (say Aug...

I'm trying to write a query in Microsoft Access database that will give me a random statistical sample from the data in the table. For example I have roughly...

Hi, Short overview of the set up: qry1 retrives data-- acct, sale1, date1(mmyy); qry2_crosstab acct as rowsourse, date as column source, sale1 as sum...

I created a data base table with names and addresses to mail to - I would like to sort out only 4 states out of the 30 I have - can someone help me?Thanks in...