I have a text field with the following data in record one. Added 8/5/2009 2:57:08 PM For 8/4/2009 The field in record two has the following data. Added...

For example, a contract ID looks like "9999P01" or "604527P05". To do a Journal entry in our accounting software, I need to add a "Z" to the end of each...

Hello All Sorry but really struggling with this Date Query I have a table that holds Dates and times (General Date Format) of various daily server logs that...

Hi, my transform is failing with ERROR 2342 , How can I redo this... basically I want my "detect" to be the column headers and "values" as rows.. This run fine...

Have 2 queries, one is "CustomerNoSales" and the other "CustomerSales", both queries have these 2 fields "CID" (customerID) and "PrdtID" (productID). I need...

Hi all, I must have scoured this forum for a day looking for some alternative answer to this question, and googling the issue doesn't seem to help me much...

Can anyone advise the code to use an Access query to convert a date or time to a string - e.g. 04/07/2005 to 04072005? Thanks

I have queries that use set table names for them. E.g. a table called "Data" will be used in a Query. I import new tables each month. One of them will be...

I have 2 tables, Claims and Transactions. They have a 1 to many relationship, 1 claim can have many transactions. The issue I am having is that we are...

I have a simple query to generate sales closure rates Invoiced Rate: Format((/),"#00.00%") where Invoiced & Ordered values are linked from other tables. The...

Oh I feel a bit of a wally posting this but - can anyone tell me how to update a specific date field when a specific checkbox is ticked. This needs to be at...

I have a query like: SELECT tbl1.fiel, tbl1.field FROM ((tbl1 LEFT JOIN tbl3 ON tbl1.coID = tbl3.ID) LEFT JOIN tbl2 ON tbl1.field= tbl2.field) ...

I have a make-table query using two tables that each have primary keys that I need to have in the resulting table. The query gives me the message "Resultant...

Hello... I have the following two fields: Field1 Field2 red The apple is green I love grapes I want to produce this new field: Field 3 The apple is...

I need to append data from one table1 to table2 using the field in table3 as the criteria. This field in question is 'account number'. How can I write a...

Hi I am creating a Vehicle Bookings database and have created a query which identifies any clashes for bookings of vehicles to eliminate double bookings. When...

I have a table that has results on it with a winner and a loser. what I am trying to do is get a winning or losing streak query based on date and game id....

I have 3 queries 1.) Count of Employee ID by Department - table 1 2.) Count of Employee ID by Category - Table 3 3.) Count of Employee ID by Final Action...

ok i have this variable i am trying to use twice with different criteria and it doesnt work help after i do with i want to count them November: Date_mailed ...

Hi, I've looked through several different shortcut sites, but haven't been able to find a keyboard shortcut to create a new blank query in Access 2007. Is...