Hi I'm running XP and Access 2003. I have a query running off an ODBC table that comes back in about 30s normally. I'm trying to rename it (also tried...

Hi, I have table which has about 10 Yes/No fields. Each record also has a key/record number and as each record represents a press cutting, there is also a...

Access 2003 Novice The following query is on a combo on a subform. The query displays perfectly correctly in Datasheet view, but on the occasions when there...

table A carrier price year op 3333 2009 ot 233 2009 table B

Hi, From a table which contains Users (Un), HostNames(Hn) and Files(Fn), I'd like to know how many HostNames and how many Files belongs to each user. Each...

I want to know how to put a parameter into my query that will allow me to input several values at one time. For example I have a query with New...

Good Day, I have not run a query since Access97 but, I am trying to run a query from a form that has four different fields with combo boxes. When I select...

Please help, looking for good and accurate inventory data. We ship out our equipment to external locations within the company and need to see what our current...

I would like to create a query which will allow me to group by a fixed interval for selected table i.e. a record from table of road data has a name of "abc"...

I have a field containing a timestamp (0x0000000021178DA5) that I would like to convert a readable date/time, is there a way to do that? thanks, Faye

Hi, I'm trying to create a simple query to come up with the difference between two numbers. In the following expression, Limit is a value of 'Number' type in...

Hi, I am new to Access and I have a problem in Update Query. I am working on financial database which contains budget for each quaters. Every month I get new...

I have a need (unfortunately) to take a relational database and query out flat file output. Let's say I have two...

I have my time seperated out in but need to calculate peak times from the data. Is it possibe?

I trying to type a query that will let me display fields: MR#, Name, Sex, Age, Ans BUT, I want only to display unique (no Duplicates) from only MR#....

hello, Below is an example of my SQL. Currenlty it is taking the query over 5 minutes to Load (if it decides to do such) I read some other blogs which...

I am using Access 2003 and I am having a problem counting by date the number of instances in a table: I am using the following SQL: SELECT...

I have an 2 years worth of encounter data file that contains all records for the office visits of patients. I would like to create a query to count the no....

Hi, I use this code to run the query. It works fine the first time from 1 to 10. When i rerun the query, I got 11-20. Can you help me how to stop rerun...

table A carrier price year op 3333 2009 ot 233 2009 table B