If I run a select query, I can get my data without erro If I run a make table query, I got "Invalid argument" WOuld Appreciate advice -- Thanks a million for...

I guess this must be really simple, but I just cannot figure it out. I have a table which lists product images. The images are custom sorted with the help of...

We have a property management company with 100 properties in inventory. We have 3 contractors that maintain these properties. Each contractor has a...

Hello there i have mdb with sql tables. After i made link table manager, all the quries becume updateable what can cause it?

I swear I must be losing my mind, because for the life of me, I cannot get a simple querry to work. I am using the following criteria in my query for 3...

Hi, I'm having trouble adding records to secondary tables via query. I have Table1 with PO# as the primary key and I have Table2 with sPO# as they key. I...

I use MSexcel macros to collect prices data from various websites. The results are tables that I link into an Access database. The tables (TblPrice1 …...

I currently have one main table to which i compare many smaller tables against within a query. However, all queries are the same barring the name of the...

Hi All, how can i count the distinct value of my crosstab query? I need to count the distinct cust id by each period. however, the SQL below will show all...

Hi, Please help.... I am trying to workout the number of Working Days between the Visit Date and a Close Job Date. How can I do this, I know in excel its...

Hi I had a question about a very complicated cross-tab. The client wants a matrix of values that has one variable for the columns, and 25 different ones for...

Hi I have 2 tables with a one to many relationship (tblhousehold and tblfamilymembers) In order to do a mail merge email, I need to create a flat file...

I have a table which contains ten different categories: A through J. With the following of field... Category, Score, Player1, Player2, MatchID I'm trying to...

Hello all, I have this query named qry_Release_Open_FixTime that works well to provide a field FixTime. SELECT tbl_UAT_Tickets.*, DateDiff("n",,)\60 &...

I am attempting (have been trying to work this out of a few hours now) to join two tables. Normally this is a simple process (even for someone of limited...

How would I go about making a cross tab query in a view? Everything I see on how to do a cross tab query they are NOT in a project. These instructions do...

In Excel there is a "MOD" function which is described as "find the remainder from wholly dividing an amount by a variable" Is there such a thing in...

i'm sure the solution is easy, but i'm just not getting it i have a text field ServiceDateTime - 10/01/06-2230 i need to express this as a date mm/dd/yyyy...

Hi I've been reading up on creating reports in Access, and it seems that many recommend having a date record with the dates for the beginning and end of the...

I've got two tables with lots of records (Daily Detail has 918 records and General Charges has 260; all records in Daily Detail have an origin number and all...