What are best pratices to set up FE so I can make design changes to FE anytime I need? How about BE? Thanks

This is posting I have posted in many new newsgroups. And after many responses saying I can't do it. I would like a way around what I'm trying to do...

I have a table that contains a field for the RAM of a given machine and it is stored in HEX. I have created a new column and want to use an update query...

Hi, I want to make a query that compares a date field I have in my records with today's date and then pull out all the records that are 2 or more weeks old. I...

Hi, i have a little problem with the dsum function in an query. I have the field Datum with dates in it. Also i got Summe=20 von St=FCck as an quantity and...

Hi there, I have a table like...

Is there any way to determine programmatically if a query is currently open? Thanks Mark

I'm using "Select TOP 10 * From tblPost" to show my first 10 posts in a weblog. to create "next 10 posts" button, how can I change my command text? I need...

I am trying to write a Query that looks at two fields and then then reports when field 1 is less then field 2. It is a report that tells when to order parts. ...

I have 35 tables that are named File1 to File35 that I have to append to a table called tblUnivData. Is doing them one by one the only option? I know how...

table 1 ID BeginDate EndDate 1 1/1/2004 5/1/2004 2 10/1/2004 20/1/2004 3 10/2/2004 ...

How can I write a query that will count the following three fields? Thanks, Kris Field: 133 Table: 2004_April Total: Count Criteria: .05

Hello, I have a problem which is baffling me. I have found very tedious ways of resolving it, but was wondering if there was an eaiser way. I have a table...

Why "Yes" equals -1? Thanks

I have created a query based on a crosstab query. Its something like this. PF, SickTot, SickBalance, CompTot, CompBalance, Status. The SickBalance and...

Hello, In my query results I want to show only 5% of the results. I know about the TopValue which will show only the top percentage of the query...

Hi, I have an string expression as an number, (out of an DSum function) for example 19000 and i want to convert this string in an expression of type...

Hi I am trying to create a query that can be updated 'on the fly'. What I want to happen is for the user to select an option from a pop-up box and then the...

Dear All, How can I find out which data path my MS Query is using? I guess there's a really simple way but I cant find it! Thanks Peter

Is there a way to create a query where I can count the following: 988 where 988 is .05 110 where 110 is .03 330 where 330 is .04 I've tried the...