Queries
in [Access]
|
Convert to text I have a query that has one field that combines two other fields. Date Length Combined 12/2/2009 3 Day 12/2/2009 - 3 day I need the combined field to in plain text format. I tried the following hoping that it would work...no luck! Text(DateLength:[Date] &" - "& [Length]) Please hel... 4 Jan 2010 02:57
How do I copy a SQL query from one database to another in Acce Me too, Tom. BeanCounter: There might also be a "get external data" option in one of the menus that allows you select an Access file, and then browse the objects within that file, select one or more, and import them into your current database. ---- HTH Dale "Tom van Stiphout" wrote: On Wed, 30... 30 Dec 2009 12:02
Dynamic query -How? what are the types of dynamic queries? how can we use this ? ... 27 Dec 2009 09:47
revers minus hi guyz,we have little office and want to make some regular thing machinary here it is: we sell stuffs(for example think us as a newspaper company) , we give newspaper to our seller and then they return the amount of newspaper that remains at the end of the week , and because every day have a special rate for... 26 Dec 2009 10:00
access 2007 use the old query builder format Is it possible to use the query wizard builder format to edit existing queries in stead of the SQL format, if so how is it enabled ... 24 Dec 2009 12:59
Where Not Exists Hi Following on from Sunil's query - I had a similar time lag on my query below - which works but takes forever (only across 7,000 records though) and tried to change the criteria from: Not In (select ContactID from [qryvolsyrshelping2009]) to: Not Exists (select ContactID from [qryvolsyrshelping2009]... 27 Dec 2009 18:31
search with multi values and get resaults order I work with access 2003 i used the select queries for exampels select * from tbl where a=val1 or a=val2 or a=val3 i want to get the resalus with this order * select all values(val1 and val2 and val3) * select 2 value of the 3 ([val1 and val2] or [val1 and val3] or [val2 and val3] * select 1 of the value the... 24 Dec 2009 07:29
problem with query in ASP using date() Hi. Hi, I am novice to ASP,I am using vb script and MSacceess for database.When ever I use the following code it gives the error.I am sure the problem is with entry_datetime='#"data"#' but not sure how to resolve it.It would be great if some one helps me in resolving the following query. . <% data=date() d... 17 Dec 2009 08:11 |