Hi: I would like to check the following: What is the largest no. of records that Access 2000 can create in a single file?

How do I creat a compound index? I need to have an index that included 3 fields, one is textual and the other two are numerical. any guidance...

Hi, i have a big problem. I have the following table: ID Reference MsgID --------------------- 1 3234 * 2 3234 5428 3 ...

I've been using Total queries to count the numbers of duplicate records in a table, where one query field is a Group By and the other is a Count of the same...

I want to combine running a query to produce a report with a macro which ticks the 'confirmed' box for a booking. I can use the button wizard which will do...

I hsaave a table which contains meeting Dates for a Division. Other words Division XYZ Will have meeting for that last 4 years. There can many meetings held...

I have a query that sits underneath and invoice report. This query is duplicating each line item on every single invoice that I generate and I don't know why. ...

I have the following tables: Address, LState, Country, Contact Every Contact has one or more Addresses. Each Address may or may not have a State or Country. ...

Long story short: Adding the All predicate to a union query causes the dependant transform query to crash Access, a memo field is the value in the...

This is a follow up from previous posts for which I need further clarification. How can I run a select query to select records and produce a report, followed...

I have two tables. Production information in first table delay information in second table. I am trying to create a query that will show ALL information from...

Hiya, I hope someone here can help me with this. I have 2 date fields in a query. I would like to only display records where -7, which is fine. However,...

I'm trying to run an update query but keep getting an error of "Operation must use an updateable query". Im lost - my update query is trying to chage rows of...

I have two tables I need to pull data from; 1 has student demographic info and the other has course requests (This is not my database, so I cannot restructure...

Here is a simple query that should match Buy.ID with Sell.BuyID SELECT Buy.ID, Sell.ID, Sell.BuyID FROM Buy INNER JOIN Sell ON Buy.ID = Sell.BuyID; But here...

Subject: stripping off dash From: " Sent: 7/15/2004 9:01:46 AM It still...

Hi, That can be seen just on a purely technical basis: A parameter can hold just one value, if there are N records in table Styles, Styles.market is a set of...

I am comparing two fields A and B I want the query to only show when a is not equal to b I want to delete the record when the two fields are not equal. The...

Is there a way to put an unknown parameter in an If statement, but only have the query ask for the parameter when the criteria is met. Example: Field3:...