Search results

Ok, I'm getting closer........ The query so far is working for the first and second numbes correctly. I'm not getting beyond that. Here's what I got so far SELECT MASTER.DATE, MASTER.GAME, numbers, Nz(Left([Numbers],InStr([Numbers],"-")-1),0) AS First...

I'm using Access 97.......where do I find help on this function? Thanks, Kacy ________ BUY GLASS PIPES

Pat, I thought the same thing that the fields must be text. I noticed it would allow me to take the field and multiply it though. I tried doing something like this. =count1 *1 + count2*1 + count3 *1 and it summed the fields correctly. Strange, but it worked. Just thought I would pass it...

Not for sure if this is possible, but thought it's worth a try. I have a "number" field that has numbers seperated by dashes. I would like each individual set of number/s between dashes be placed in its on field. My problem is some of the numbers have 2 numbers before the dash while some only...

Pat, When I tried the code you gave me in the total field I'm getting the columns concatenated together. Say I have 7 5 3 = (its giving me) 753...........instead of 15. Any ideas why it's doing this? These are numeric fields. Thanks, Kacy ________ DEPAKOTE ATTORNEYS

I've searched several pages regarding sums and I'm still having trouble.....In my detail section I want a sum of each row. I thought it would be a simple textbox w/ its recordsource as =sum([count1]+[count2]+[count3]), but I have worked all afternoon on it w/ out getting it right. This report...

I've got it working........ SELECT DISTINCT tblNumbers.NUMBERS, NZ(qry1stNumbers.COUNT1,[0]) FROM tblNumbers LEFT JOIN qry1stNumbers ON tblNumbers.NUMBERS = qry1stNumbers.FIRST_BALL GROUP BY tblNumbers.NUMBERS, qry1stNumbers.FIRST_BALL, qry1stNumbers.COUNT1; ________ N02 Vaporizer

When using the NVL i'm getting an "undefined function in expression" error. Here's the query..... SELECT DISTINCT tblNumbers.NUMBERS, NVL(qry1stNumbers.COUNT1,0) FROM tblNumbers LEFT JOIN qry1stNumbers ON tblNumbers.NUMBERS = qry1stNumbers.FIRST_BALL GROUP BY tblNumbers.NUMBERS...

Can I put the Nz function into a query? I tried putting Nz before my counts field, but still leaving the field blank if there is no data. In the help section it doesn't give any examples of this use in a query. Just checking to see if I can do this function in a query. Thanks, Kacy ________...

place "0" in blank field I'm trying to place a "0" in the count field of this query when the count field for a particular number is blank. Is this possible? Here's my query that gives me the correct results, but when a number has no counts it is BLANK instead having a "0" like I...

Thought I had it figured out, but still WRONG. ________ Opa

In my table I have a date field and three different two position numeric fields called first, second and third. Currently I have 3 different queries that counts and groups each field. For example in the "First Query" data looks like First Qnty 02 10 11 5 07 6 , etc...

Thanks guys!.........making me look like I actually know what I'm doing here at work. Thanks, Kacy ________ Hemp marijuana

ok....I tried that, but not getting what I'm looking for. I want to get everything from table A.....even if it does not have a match from table B. And only those records from table B that does not have a match from table A. Sorry for being a pain Thanks, Kacy ________ GENETICALLY MODIFIED FOOD

I need to re-stat what I'm trying to do.....I didn't explain it very well. I want to include all records from table A and only those records from table B where the joined fields ARE NOT equal. Maybe the query below we give a better idea of what I'm trying to do. Although I can't get it to...

I have two tables that I am querying. I want to include all records from table A and only those records from table B where the joined fields ARE NOT equal Here is sort of what I'm trying, but it's not working. SELECT [table A].DLN, [table B].DUP FROM [table A] LEFT JOIN [table B] ON ([table...

As far as an appointment scheduler......and double booking....I still haven't found a good way to control that. In fact my company is looking for an appoinment scheduling software that will take care of this problem. Right now I have a button users can click on called "verify appointments"...

ok, think I about have it figured out. Thanks for you help guys. ________ Tsd Sports Spring Powered Airsoft

ok, I've read through several of the format() functions and I'm still having trouble. Here's what I got.....I have an Appointment table that users enter in the date in the future (i.e. 08/01/03). I also have a scheduled times table that says.....for example, facility 1 can only schedule two...

This is a long shot here....but thought I would ask. Is there any way to calculate what the day of the week would be from a date? For example, a calculation that would tell me 07/01/03 is on a Tuesday. I've never seen this or have read anything about, but thought I would try. Thanks, Kacy...