When I construct a query using Access, I can get data from a form by doing something like ExchRate:Forms!frm_Menu.TodaysRate Now I am trying to do this with...

Hello everyone! Using A02 on XP. I am trying to combine 2 select queries into an SQL so I can have one set of data. I am getting the error saying I am...

I have a (complex) query that uses a for it's criteria, which when entered, it finds any matching Run_No's (that are related via other criteria). All works...

Hello, my problem is access 97 started not to recognise the built-in functions suddenly, such as month() or year(). Could anyone help me how to resolve this?...

I cannot find anything in the help files to assist me with computed columns in a Access Queries using adp/SQL. For example when using Access (mdb) I could...

Hi. I want to create a querie with multiple criterias. In my form, I have several fileds to find a product. Nop Name Family Brand Type ...

I have a database that lists media contacts, the regions they are from and the different categories of media releases they have signed up to receive. I have...

I need a criteria to run a query to pick up the last four number of seven digit number. Is it possable to use a parameter such as Between And Or Like "*" ...

Hello. I've read several posts regarding this issue, but have not been able for find the solution. A vendor gave me this equation to determine total minues,...

I used a database in multiple PC and now I cannot make any entry in the query or forms. I changed the Recordset type to Dynaset (Inconsistent Updates) but now...

Hi All, I am using the contacts db that comes standard with MS Access. What I am trying to do is create a query that gives me all the contacts that have had...

Hello all, I am trying to create a query in which data is displayed for the current month beginning with the first day of the week, first week of the month...

I have a table with AcctNo, SecurityName, otherfields. I need to update this table with a new field that would indicate for each AcctNo row the number of...

I have a query in which i convert to pivot table view and place the fields from the field list, i do not have grand totals. In addition the fields go...

I created a database with 4 tables called Items, Date, Type, and Titles. The items Table uses combo boxes to enter the date, type, and titles from the Date,...

I need a query to that will combine data from two tables (photos, proveniences) but the method of record selection needs to vary based upon whether or not...

I have a database that has multiple dates in it. What I am trying to do is in one field I have a date and I am want that date to convert to months in another...

Hi I am trying to get the IDs of all those customers who have not purchased anything in the last 3 months. What SQL query do I use? The table has 2...

is there a way of having an incremental number for each row of a query, like an autonumber? -- Message posted via http://www.accessmonster.com

I am trying to use the ecount function: CountOfAcct Number: ECount("",""," ='ATLANTA PAS'",True) It seems to give me the correct total, however, I am trying...