Hello, I am looking for a way to query a table for the "latest workdate". The table fields would be: Project, Task (T1,T2,T3,etc) and workdate. Within each...

I have the following rows and columns in a table C1 C2 1 A B 2 A B C etc.

Scan steel receiving - P063141049 682875 4480 There is a space between each group of numbers. data length may be different so need to have the delimiter in...

I am making a database and i have a dropdown list in my table, in this list are values of another table. based on the value selected in this list i want to...

Can someone tell me whether Wombats live only in Australia, or also on other continents? Apart from zoos, of course. 153 -- Posted via a free Usenet...

Tell me about yourself?

after clearing the test data from the tables, forms are no longer writing to the tables.

I have a table regarding tours that are given at our facility. The main fields are Tour ID, Tour Date, Tour Guide, Host Organization, etc. All of the tours...

I designed the following query a couple weeks ago. It takes from an existing table and creates another to my specified parameters. It works fine with no...

I have linked through odbc to Oracle tables. The table has a date field that I want to use to limit the results of the query. When I place the exact date...

Hi I have a query whith Col-A and Col-B. How can I do a difference(dates Col-B) in Col-C? Col-A Col-B Col-C ...

Can someone please tell me how I would extract the first name from a text box in an access query? i.e. Burt Reynolds I want to extract Burt. I tried this in...

Hello, I have a form that allows the user select from one check box of criteria and then enter up to 4 "OR" criteria of data on 3 additional fields from 3...

In a query, how can I select 'yes' records or all (yes and no records). I either want to see only yes-records or all records. Thank you.

Hello, i have the foloowing query in access; SELECT dbo_AnalogHistory.DateTime, dbo_AnalogHistory.Tagname, dbo_AnalogHistory.Value FROM...

Hello to all i try to have a view but i am confuse i have 2 tables (A and B tb A fields: DateIN_A(date) | Cat(integer) | CatA_ID(text) tb B fields:...

I've tried to create a query that identifies the last record entered into a table. The field I'm using with this totals query is called projectID which is...

Is their a way I could create a "cut query". What I mean by that is to cut data from one table and place it in another. Sort of like an update or append...

This one is driving me nuts. I need to show two types of related data from the same table in the same report. I send endowment reports which include a...

I need to create a line chart that displays the number of a project's due dates for each month. There are 2 data series - original due dates and revised due...